CODEWITHSUNDEEP
asp.net
happysmile
happysmile

Reputation: 7777

dataset with bulk changes

i have an dataset around 1000 records in it. i have made changes around 50 rows in dataset, i have created an new 

dataset dsnew=   ds.GetChanges();

now this dsNew would contain all the new 50 rows which we made changes, now i want to update these values to Database,

here i do not want to call 5o times my update command or stored procdure to update my values to table which would really decrease the performance

is there any better way to solve it.

Thanks Prince

Upvotes: 1

Views: 70

Answers (1)

indiPy
indiPy

Reputation: 8062

This age old request to MS, but still you can try for following options,

  1. ADO.Net batch update.

Note : For insertion you can use SQL Bulk Copy,

Upvotes: 1

Related Questions