Datatable to SQL database

Posted by Riasul under VB.NET on 5/7/2011 | Points: 10 | Views : 3195 | Status : [Member] | Replies : 1
Hi,

I want to u-pdate bulk data available in datatable to SQL database without making loop. is it possible?


please send the coding in vb.net

regards
Raisul




Responses

Posted by: SheoNarayan on: 5/7/2011 [Administrator] HonoraryPlatinum | Points: 25

Up
0
Down
Hi Riasul,

You can't do that directly from the DataTable but you can do this using DataSet. Read this article http://www.dotnetfunda.com/articles/article489-backup-and-restore-database-in-aspnet-.aspx or http://www.dotnetfunda.com/articles/article1215-changing-database-records-in-adonet-part-5-.aspx.

In the first article I have shown how to update record from one DataSet to another DataTable, in the second article Naimish has explained in great details.

Hope this helps.

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Riasul, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response