From: <td...@te...> - 2004-04-10 12:52:19
|
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 |