What is ADO.NET DataTable in C#?
The DataTable in C# is similar to the Tables in SQL. That means the DataTable is also going to represent
the relational data in tabular form i.e. rows and columns and this data is going to be stored in memory.
When we create an instance of DataTable, by default, it does not have table schema i.e. it does not have
any columns or constraints by default. You can create the table schema by adding columns and
constraints to the table. Once you define the schema (i.e. columns and constraints) for the DataTable,
then only you can add rows to the data table. In order to use DataTable, you must have to include the
System.Data namespace.
Note: The ADO.NET DataTable is a central object which can be used independently or can be used by
other objects such as DataSet and the DataView.
Step1: Creating DataTable instance
create an empty data table for which the TableName property is set to Student.
Step2: Adding DataColumn and Defining Schema
The following image shows adding Data Column using a few properties.
Creating Primary Key Column in Datatable:
Like SQL, the primary key of a DataTable object also consists of a column or columns that make up a
unique identity for each data row. The following image shows how to set the PrimaryKey property on
the Id column of the Student DataTable object.
