update dataset
Tomasz Dreßler <[email protected]> Sat, 10 Apr 2004 14:52:17 +0200
| Newsgroups | gmane.comp.lib.sql.sqlpp |
|---|---|
| Message-ID | <[email protected]> |
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
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click