DataTable Properties

There are four properties of a Da`taTable:

CaseSensitive

Determines whether the comparisons after searching, sorting, or filter­ing records are case sensitive (the default value is False)

MinimumCapacity

Specifies the initial number of rows that the DataTable accepts (the default value is 25)

PrimaryKey

Specifies the array of columns to be used as the primary keys for the DataTable

TableName

Specifies the name of the DataTable Creating

Creating Datatables by using Programs

Typically, a DataTable can be created from an existing database table. However, programs can also be used, for creating a DataTable and adding it, to a DataSet.

A DataTable has a collection of rows and arrows represented by the Rows property and Columns property. A DataTable can be build by programming­, consisting of records by adding DataColumns to the columns collection and DataRows to the rows collection.

In the following example, a new DataTable is created with four columns: ProductID,ProductName, ProductCategory, and ProductPrice. Next, the two rows are added to the DataTable. The contents of the DataTable are then displayed.

In the above example, an instance of the DataTable class-named dtblCart-is created. Further, four columns are added to the DataTable by adding DataColumns to the DataTable's columns collection. Each column is created with a name and data type.

Next, two rows are added to the DataTable. By using the DataTable's NewRow( ) method, a new row is created with the correct column schema for the DataTable. After a value has been assigned to each column, the row is added to the DataTable's rows collection.

Finally, the contents of the DataTable are displayed by looping through the rows and columns collections of the DataTable. The value of each column for each row is displayed.

ExpertRating ASP.NET Certification - Get Certified Now!!