Filling a DataTable or DataSet the Quick Way

Posted by: Imar Spaanjaars at Tuesday, September 19, 2006 8:29:13 PM in: ADO

In .NET 1.x filling a DataSet or a DataTable meant quite some work. You needed to create a Connection object, a DataAdapter and optionally a Command object. Then you had to call the Fill method on the DataAdapter and pass it a newly created DataSet or DataTable.

In .NET 2.0, this code model has been simplified, thanks to the Load method on the DataTable and DataSet classes that takes an IDataReader as a parameter.

Read on ...

How Do I Insert a Null Value in an Access Database?

Posted by: Imar Spaanjaars at Sunday, May 9, 2004 1:25:13 PM in: ADO
When you need to insert a null value into a column in an Access database, you could use "" to indicate a zero-length string. However, a zero-length string is not the same as Null. To insert a Null value, simple pass the keyword Null for the column, as shown in the code example.
Read on ...

ADO Connection and Recordset

Posted by: Imar Spaanjaars at Sunday, May 9, 2004 1:08:30 PM in: ADO
This simple snippet demonstrates how to create and setup an ADO Connection to retrieve and display information from a database.
Read on ... 1