Library tagged with ado.net
Latest ado.net tutorials & articles
-
High-Performance .NET Application Development & Architecture
by Dimitrios Markatos
This article demonstrates the art of creating and architecting high-performance and scalable .NET applications, covering all stages, from planning to development and their perspective best practices.
-
DataGrid/GridView Paging and Sorting Using A DataReader
by Dimitrios Markatos
This article will demonstrate two ways one could implement the DataReader to bind a DataGrid, that includes caching, paging and persistent bi-directional sorting, all without the use of a DataAdapter/DataSet at all, and includes ASP.NET 2.0 GridView version!
-
Selecting, Confirming & Deleting Multiple Checkbox Items In A DataGrid/GridView - Part 2: Maintaining CheckBox State Acr
by Dimitrios Markatos
In this article, we will examine how to create a fully functional DataGrid and GridView in .NET 2.0 with all the features you'd find set up on Hotmail, Yahoo, and AOL Mail, and further demonstrate how you can multi-select items across pages and batch delete them all.
-
Filtering and Sorting in ADO.NET
by Martin Zahn
ADO.NET supports many ways to manage memory-resident data returned in a DataSet. This example demonstrates how to use the additional functionality exposed by ADO.NET to sort and filter data.
-
Using ADO.NET with SQL Server
by James Crowley
An extensive examination of using ADO.NET to access SQL Server databases, from establishing connections and executing stored procedures, to connection pools, data readers and data sets.
-
In Depth ASP.NET using ADO.NET
by John Godel
In this article we will discuss a number of ways to retrieve, show, and update data with ASP.NET forms using ADO.NET. Also, we will have a clear idea about the most common server controls in ASP.NET. In particular, with this article we will cover ASP.NET server controls, ADO.NET DataSource, and creating Templated DataBound Controls, ASP.NET forms, using data with controls. John Godel
Latest ado.net code
-
SQL Data Provider VB.NET Class
by Mehdi Golchin
This class includes some useful methods for working with Misrosoft SQL Server in .NET simply and quickly.
-
Transactions made easy with .NET 2.0
by Xavier Larrea
One of the more significant improvement in .NET 2.0 is the transactions area. Now with a single line it becomes extremely easy to support transactional code blocks using the concept of “ambient” transaction thanks to TransactionScope in the System.Transactions namespace.
-
Database Independent ADO.NET 2.0
by Xavier Larrea
ADO.NET 2 has new classes that makes it quite easy to write data-programs independent of the database engine. Learn how here.
-
How to run through multiple DataReader results
by Edward Tanguay
You can save code by piling SQL statements into one SqlCommand and then getting a DataReader with multiple result sets.
-
How to access a MySQL database with .NET
by Edward Tanguay
Demonstrates how to connect to a MySQL database with C#.
-
How to delete records with SqlCommand
by Edward Tanguay
This code shows you how to delete records with an SQL statement and get the number of records deleted returned back as an integer.
-
Placing results from DataReader into an Array
by Edward Tanguay
Since a connection cannot be used until a DataReader has been closed, it is quite often necessary to read the results of a DataReader into an array, then close the DataReader, then you can process the data in the array while you use the connection for something else. This shows you how.
Latest ado.net podcast
-
A Practical Look at Silverlight 2 Part 2
Published 3 months ago
Now that Silverlight 2 is at the Olympics and making a big splash, we wanted to explore this fascinating technology more. Microsoft Silverlight 2 is a cross-browser, cross-platform, and cross-device plug-in for delivering the next generation of .NET based media experiences and rich interactive ap...