Hi,

You can take the table in the dataset and can use the following C# code to
determine the Autoincrement value

dtEmployee.Tables[0].Columns[0].AutoIncrement  

In the above case the first table in the dataset has the first column name
as identity.

The above statement would return you true or false.

Thanks and Regards,

Piyush Thakuria

net_learner_sp,

Here is an example:

       Dim connectionString As String =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=CourseInfo.mdb;"
       Dim cn As New OleDb.OleDbConnection(connectionString)
       Dim cmd As New OleDb.OleDbCommand
       Dim rdr As OleDb.OleDbDataReader
       Dim tbl As DataTable

       cmd.CommandText = "Select * From Students"
       cn.Open()
       cmd.Connection = cn
       rdr = cmd.ExecuteReader(CommandBehavior.SchemaOnly Or
CommandBehavior.KeyInfo)
       tbl = rdr.GetSchemaTable
       rdr.Close()

       Dim row As DataRow
       For Each row In tbl.Rows
           If row("IsAutoIncrement") Then
               MsgBox(row("ColumnName") & " is autoincrement")
           End If
       Next

Kerry Moorman