DsAddressBook1 is the Dataset
The Table "Address_Lst" has an Identity Col "ADDRESS_ID "(seed)
Dim dt As DataTable = DsAddressBook1.Tables("Address_Lst"
Dim dr As DataRow = DsAddressBook1.ADDRESS_LST.NewRow
dr("FIRST_NM" = txtFirstName.Text.Trim
dr("LAST_NM" = txtLastName.Text.Trim
DsAddressBook1.ADDRESS_LST.AddADDRESS_LSTRow(dr)
DAAddressUSA.UpdateCommand = Me.SqlInsertCommand1()
The Above Code not working.
It says
Exception Details: System.Data.NoNullAllowedException: Column 'ADDRESS_ID' does not allow nulls.
I would be appreicated any one give a solution to insert Identity column value to the Table
Note: I have used DataAdapter in Design time and used "Configure DataAdapter". The select,insert and update commands generated automatically.
Karthik Bala
The Table "Address_Lst" has an Identity Col "ADDRESS_ID "(seed)
Dim dt As DataTable = DsAddressBook1.Tables("Address_Lst"
Dim dr As DataRow = DsAddressBook1.ADDRESS_LST.NewRow
dr("FIRST_NM"
= txtFirstName.Text.Trimdr("LAST_NM"
= txtLastName.Text.TrimDsAddressBook1.ADDRESS_LST.AddADDRESS_LSTRow(dr)
DAAddressUSA.UpdateCommand = Me.SqlInsertCommand1()
The Above Code not working.
It says
Exception Details: System.Data.NoNullAllowedException: Column 'ADDRESS_ID' does not allow nulls.
I would be appreicated any one give a solution to insert Identity column value to the Table
Note: I have used DataAdapter in Design time and used "Configure DataAdapter". The select,insert and update commands generated automatically.
Karthik Bala