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