If you use the SQLDataAdapter and fetch 1000 rows to a dataset, you can make changes to the dataset locally, then a simply call to sqldataadapter.update will apply all the changes for you.
What this call is doing I am not sure of, and Ive never tried to add rows to the dataset. My guess is...
There is no way to use the sqldataadapter, or a datatable or dataview to bulk insert data into SQL?
I know you can make mass updates in this fashion, so I was wondering if its possible to get 1 row, then add in thousands more and then do an update statement?
I have an application that inserts thousands of data values from a text box within the application, performs a number of functions, then inserts the values into a sql table.
Right now I have a for loop that goes through each value and does an insert.. I have to believe there is a more...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.