Second Try Insert data from Dataset in to database

  • Thread starter Thread starter Ruslan Shlain
  • Start date Start date
R

Ruslan Shlain

I have looked high and low and i cant get anything to work.
I have a dataset that i fill with data from text file.
I need to populate my SQL Server 2000 database with data in that dataset.
Dataset has close to 3000 records and may have as many as 70 + columns.
I am looking for an exemple of some sort. PLEASE HELP
 
Ruslan,

Does the database already contain the table(s) from the
DataSet, or do you need to create the table(s) before submitting
the new rows?

David Sceppa
Microsoft
This posting is provided "AS IS" with no warranties,
and confers no rights. You assume all risk for your use.
© 2004 Microsoft Corporation. All rights reserved.
 
It has a table with exactly the same structure as dataset
Click to expand...

The advice suggested in the other thread to use a
CommandBuilder in conjunction with a DataAdapter to generate the
updating logic should suffice. However, you'd get more control
and better performance by supplying your own updating logic.

I hope this information proves helpful.

David Sceppa
Microsoft
This posting is provided "AS IS" with no warranties,
and confers no rights. You assume all risk for your use.
© 2004 Microsoft Corporation. All rights reserved.
 
Hi Ruslan,

You might create a dataadapter at design time using vs.net wizard (same as
CommandBuilder but more flexible).
 
Back
Top