To set the primary key column in the DataTable, you need to create arrays of column and store column you want as primary key for the DataTable and set its PrimaryKey property to the column arrays. you don't want duplicate records into that column, then set its Unique property to true like below.Īuto.Unique = true Specifying Primary Key column in the DataTable If you want a particular column to be a unique column ie. Whenever a new row will be added its value will automatically increase by 1 as I am specified AutoIncrementSeed value as 1. See the code below, here I am setting the first column 'AutoID' as autoincrement field. To specify a column as AutoIncrement (naturally it should be an integer type of field only), you need to set some properties of the column like AutoIncrement, AutoIncrementSeed.

Int32 )) ĭataColumn name = new DataColumn ( 'Name', typeof ( string )) ĭataColumn address = new DataColumn ( 'Address', typeof ( string )) ĭ(address) Specifying AutoIncrement column in the DataTable Then call add method of DataTable column and pass the DataColumn object as parameter.ĭataColumn auto = new DataColumn ( 'AutoID', typeof (System.

To create column in the DataTable, you need to use DataColumn object. Instantiate the DataColumn object and pass column name and its data type as parameter. Here, I have pased a string as the DataTable name while creating DataTable object.ĭataTable dTable = new DataTable ( 'Dynamically_Generated' ) To create a DataTable, you need to use System.Data namespace, generally when you create a new class or page, it is included by default by the Visual Studio. Lets write following code to create a DataTable object. I have tried to cover most of the frequently used activity in the DataTable, I hope you will like it. In this tutorials, I will explain how to work with DataTable. If you are working with ADO.NET - accessing data from database, you can not escape from DataTable. Other objects that use DataTable are DataSet and DataView. IntroductionDataTable is a central object in the ADO.NET library.

Datatables removed showhide filter