ADO.NET Programming

Working with DataRow and DataColumn using a DataTable
(Rated 0 from 0 votes)
Demonstrates on parsing through rows and columns in a DataTable Read More...
Posted to: ado-net-disconnected-data by Jagadish Pulakhandam | Monday, August 29, 2011 12:20:25 PM | 0 Comments
Copy data from DataReader to List of Objects
(Rated 0 from 0 votes)
Demonstrates on loading / copying data (rows) from DataReader to List of Objects. Read More...
Posted to: ado-net-querying-for-data by Jagadish Pulakhandam | Friday, August 26, 2011 2:47:44 PM | 0 Comments
Filling DataTables and DataSets using SqlDataAdapter
(Rated 0 from 0 votes)
Demonstrates on working with "disconnected" architecture available in ADO.NET Read More...
Posted to: ado-net-disconnected-data by Jagadish Pulakhandam | Friday, August 12, 2011 6:03:56 AM | 0 Comments
How to Retrieve Data Asynchronously using SqlDataReader
(Rated 0 from 0 votes)
Demonstrates on loading data into a DataGridView in an asynchronous fashion. Read More...
Posted to: ado-net-querying-for-data by Jagadish Pulakhandam | Friday, August 5, 2011 1:57:49 PM | 0 Comments
Introducing ADO.NET Command Parameters
(Rated 0 from 0 votes)
A simple way of understanding "SqlCommand" parameters. Read More...
Posted to: ado-net-querying-for-data by Jagadish Pulakhandam | Friday, August 5, 2011 1:21:24 PM | 0 Comments
Retrieving multiple results (multiple SELECT results) in a single batch
(Rated 0 from 0 votes)
Demonstrates the feature of "Multiple Active Result Sets" (MARS) available from .NET Framework 2.0 and SQL Server 2005 Read More...
Posted to: ado-net-querying-for-data by Jagadish Pulakhandam | Friday, August 5, 2011 1:10:43 PM | 0 Comments
How to read all rows in SqlDataReader and make them available offline
(Rated 0 from 0 votes)
Demonstrates on reading all rows from SqlDataReader and place them in an ArrayList. Read More...
Posted to: ado-net-querying-for-data by Jagadish Pulakhandam | Friday, August 5, 2011 12:57:31 PM | 0 Comments
How to read XML based SQL Server result set (query result) using ADO.NET
(Rated 0 from 0 votes)
Demonstrates on retrieving XML returned by an SQL Server Query which includes FOR XML clause. Read More...
Posted to: ado-net-querying-for-data by Jagadish Pulakhandam | Friday, August 5, 2011 12:42:14 PM | 0 Comments
Database Independent development using ADO.NET
(Rated 0 from 0 votes)
This sample demonstrates on executing same code against multiple data sources (Sql Server and Excel in this case). Read More...
Posted to: ado-net-connecting-to-db by Jagadish Pulakhandam | Thursday, August 4, 2011 11:16:22 AM | 0 Comments
Connecting to any data source using DbProviderFactory
(Rated 0 from 0 votes)
Demonstrates on connecting to any data source using DbProviderFactory available in "System.Data.Common" namespace. Read More...
Posted to: ado-net-connecting-to-db by Jagadish Pulakhandam | Thursday, August 4, 2011 11:06:19 AM | 0 Comments