Hi,

I have created a datatable, dataadapter, added the table to a dataset
and filling the table.

Here I want to add an identity column to the above datatable and Later I
will use this identity colum for printing the records using print
document.

How to create an identity column that increments its value when each row
added to it.

Here is the code snippet... Pls help.

myCommand = New SqlClient.SqlCommand(mySql, gSQLConnection)
UsrAdapter = New SqlClient.SqlDataAdapter(myCommand)
myDataSet = New DataSet

Dim myDataTable As New DataTable("ShareHoldersAuditReport")
myDataSet.Tables.Add("ShareHoldersAuditReport")
Dim aColumn As DataColumn
aColumn = myconstraint
aColumn = New DataColumn("aaaa")
myDataSet.Tables("ShareHoldersAuditReport").Columns.Add(aColumn)
aColumn = New DataColumn("bbbb")
myDataSet.Tables("ShareHoldersAuditReport").Columns.Add(aColumn)
aColumn = New DataColumn("cccc")
myDataSet.Tables("ShareHoldersAuditReport").Columns.Add(aColumn)
UsrAdapter.Fill(myDataSet, "ShareHoldersAuditReport")
myTable = myDataSet.Tables("ShareHoldersAuditReport")
gSQLConnection.Close()



Regards.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi,

You have to make the column auto increment. Set the auto increment
seed to the starting value.
dsPriceList.Tables(0).Columns("ID").AutoIncrement = True

dsPriceList.Tables(0).Columns("ID").AutoIncrementSeed = 1

Ken

------------------------

"Omavlana Omav" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>
>
> Hi,
>
> I have created a datatable, dataadapter, added the table to a dataset
> and filling the table.
>
> Here I want to add an identity column to the above datatable and Later I
> will use this identity colum for printing the records using print
> document.
>
> How to create an identity column that increments its value when each row
> added to it.
>
> Here is the code snippet... Pls help.
>
> myCommand = New SqlClient.SqlCommand(mySql, gSQLConnection)
> UsrAdapter = New SqlClient.SqlDataAdapter(myCommand)
> myDataSet = New DataSet
>
> Dim myDataTable As New DataTable("ShareHoldersAuditReport")
> myDataSet.Tables.Add("ShareHoldersAuditReport")
> Dim aColumn As DataColumn
> aColumn = myconstraint
> aColumn = New DataColumn("aaaa")
> myDataSet.Tables("ShareHoldersAuditReport").Columns.Add(aColumn)
> aColumn = New DataColumn("bbbb")
> myDataSet.Tables("ShareHoldersAuditReport").Columns.Add(aColumn)
> aColumn = New DataColumn("cccc")
> myDataSet.Tables("ShareHoldersAuditReport").Columns.Add(aColumn)
> UsrAdapter.Fill(myDataSet, "ShareHoldersAuditReport")
> myTable = myDataSet.Tables("ShareHoldersAuditReport")
> gSQLConnection.Close()
>
>
>
> Regards.
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

AutoIncrement and AutoIncrementSeed are the properties you need to set.

NOTE: Be careful of database concurrency, et al, when heading this
direction, as it is easy to get the auto-increment out of touch with the
database.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
"Omavlana Omav" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>
>
> Hi,
>
> I have created a datatable, dataadapter, added the table to a dataset
> and filling the table.
>
> Here I want to add an identity column to the above datatable and Later I
> will use this identity colum for printing the records using print
> document.
>
> How to create an identity column that increments its value when each row
> added to it.
>
> Here is the code snippet... Pls help.
>
> myCommand = New SqlClient.SqlCommand(mySql, gSQLConnection)
> UsrAdapter = New SqlClient.SqlDataAdapter(myCommand)
> myDataSet = New DataSet
>
> Dim myDataTable As New DataTable("ShareHoldersAuditReport")
> myDataSet.Tables.Add("ShareHoldersAuditReport")
> Dim aColumn As DataColumn
> aColumn = myconstraint
> aColumn = New DataColumn("aaaa")
> myDataSet.Tables("ShareHoldersAuditReport").Columns.Add(aColumn)
> aColumn = New DataColumn("bbbb")
> myDataSet.Tables("ShareHoldersAuditReport").Columns.Add(aColumn)
> aColumn = New DataColumn("cccc")
> myDataSet.Tables("ShareHoldersAuditReport").Columns.Add(aColumn)
> UsrAdapter.Fill(myDataSet, "ShareHoldersAuditReport")
> myTable = myDataSet.Tables("ShareHoldersAuditReport")
> gSQLConnection.Close()
>
>
>
> Regards.
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!