C# Data Content

Database

Data usage in the C# language is called ADO.NET and is critical to the operation of many programs. The .NET framework provides very powerful classes in the System.Data namespace. Through this collection of articles, we see how to use several of these classes.

Using rows and columns

The System.Data namespace provides the DataRow and DataColumn types to represent rows and columns in a DataTable. DataRow instances contain the actual data; the DataColumn instances simply specify the characteristics of the columns.

See DataRow Examples.

See DataColumn Class.

See DataRow Field Extension Method.

Using DataTable

Using DataTables in the C# language can be complex and somewhat difficult. These articles, particularly the first one, help show how you can use DataTable instances in a useful way. DataTable instances represent a collection of rows and columns of data.

See DataTable Examples, Columns and Rows.

See DataTable Foreach Loop.

See Using DataTable Block.

Using DataView

Another type you can use in the System.Data namespace is the DataView type. This gives you the ability to sort and filter data stored in DataTables. This article can be used as a supplement to the other data articles here.

See DataView Usage.

Using DataSet

The DataSet type can be used as a container for many DataTables. These articles describe specific aspects of the DataSet type in the .NET Framework and System.Data namespace.

See DataSet GetXml Method.

See DataSet GetXmlSchema Method.

SQL

Some aspects of data usage in the C# language are covered in the section focusing on SQL. The articles about SQL cover both how to use SQL through the C# language, and also how to use specific database servers in your applications.

See SQL Information.

© 2007-2010 Sam Allen. All rights reserved.

Dot Net Perls  Sam Allen