VB.NET: How to Enter Values in AutoIncrement Columns of DataTable.

[PulkitZery]

Hello,

I am trying to create a Dataset and save it to an XML file. I have one column “JobID” for which I have set the autoincrement property to true. Here is the function that creates and save the dataset:

Public Sub CreateDataSet()

Dim tbMain As DataTable = New DataTable("Uplo adLog")

'Job ID – Auto increments
Dim drJobID As New DataColumn("Job ID")
drJobID.DataTyp e = Type.GetType("S ystem.Int64")
drJobID.Unique = True
drJobID.AllowDB Null = False
drJobID.ReadOnl y = True
drJobID.AutoInc rement = True
drJobID.AutoInc rementSeed = 1000
drJobID.AutoInc rementStep = 1
tbMain.Columns. Add(drJobID)


'Upload Type
Dim drUploadType As New DataColumn("Upl oadType")
drUploadType.Da taType = Type.GetType("S ystem.String")
drUploadType.Al lowDBNull = False
tbMain.Columns. Add(drUploadTyp e)

'Status
Dim drStatus As New DataColumn("Sta tus")
drStatus.DataTy pe = Type.GetType("S ystem.String")
tbMain.Columns. Add(drStatus)


Dim ds As New DataSet
ds = New DataSet("MediaT raqLogs")
ds.Tables.Add(t bMain)

ds.WriteXmlSche ma(sFileName)

End Sub


Now if I try to add new row in this data table the auto increment column does not auto-increments. Here is how I am adding row into this datatable:

Public Sub AddDataRow(ByVa l Status As String, ByVal UploadType As String)

Dim DS As New DataSet()

DS.ReadXml(sFil eName)

Dim tbUpload As DataTable = DS.Tables("Uplo adLog")

Dim oRow As DataRow = tbUpload.NewRow

oRow.Item("Stat us") = Status
oRow.Item("Uplo adType") = UploadType

tbUpload.Rows.A dd(oRow)

DS.AcceptChange s()

DS.WriteXml(sFi leName)

End Sub

But for some reasons it give first row as Job ID = 1000 and does not give any JobID to next rows which I add to this table.

Please help, I don’t understand what I am doing wrong in here.

[santuvssantu]

Try declaring the DS as Global(to use it only once). I think that should work.

Thanks

[PulkitZery]

Hi Thanks for the reply.

I figured it out. What I did was every time inserting a row before reading XML file I would create the schema for my DS. And it did the trick. Anyways, Thanks very much for the reply.