Hi,
Where you get the data from?
You can check the DataRow.RowState to see the status of the row, then you
could run the required query (Update, Insert ) or as Paldino said use the
SqlDataAdapter.
cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Necqui Teja" <Ne*****@nospam.nospam> wrote in message
news:e%****************@TK2MSFTNGP15.phx.gbl...
Is there a quick and effcient way to insert records into SQL Server
database from a DataTable (DataTable dt;) when the DataTable and the SQL
Server database contain the same field names and attributes.
I'm using VS2005 Beta 2.
Thanks.