Hi!
I am looking for a goog practice to update dataset into database.
I use this example.
'execute folowing stored procedure
' SELECT * FROM dbo.[kundes] AS K
' INNER JOIN dbo.[Unterbrechungs] AS U
' ON K.KundeNr = U.KundeNr
' WHERE K.KundeNr = @KundeNr
Dim storedProc As New EarNet.Providers.StoredProcSqlDataProvider
DataGrid.DataSource = storedProc.UnterbrechungsByKundeDataSet(1)
'now I make changes in dataset
'fetch changed rows
Dim tChanges As DataTable = CType(DataGrid.DataSource,
DataSet).Tables(0).GetChanges()
How I can get a Collection of UnterbrechungDataReader objects now, so I
that it is possible to do the following:
For each x as UnterbrechungDataReader in col
unterbrechungDB.UpdateUnterbrechung(x)
Next
thanks for attention
|