How to Write Data from dataset back to Database?

  • Thread starter Thread starter news.microsoft.com
  • Start date Start date
N

news.microsoft.com

Hello NG,

i have have the following problem:

Im updating a Dataset like this:

Dim winsortDs As New DataSet()
Dim winsortDa As New SqlDataAdapter("SELECT * FROM barcodeClasses",
getActiveConnection())

For i = 0 To svrBarcodeClasses.Rows().Count - 1
winsortDs.Tables(0).ImportRow(svrBarcodeClasses.Rows(i))
Next


'after that, i show for Debugpurposes the recordcount in a textbox:

UpdateForm.txtDebug2.Text += winsortDs.Tables(0).Rows.Count.ToString


'The correct recordCount is shown.
'Then i do the following:

winsortDs.AcceptChanges()
winsortDa.Update(winsortDs)

'When i take a look in the database, i see that there happens nothing.
'The program does not throw any exception, it seems to work fine.

I wonder why does the dataset not update the SQL-Database?
Have someone any ideas?

Thanks in advanced,
Ralf
 
Back
Top