is there any way to insert in bulk (i mean all gridview rows) to sql server database in single submit. its an ASP.Net app and I also want to validate data.
4
-
stackoverflow.com/questions/4396018/…jcolebrand– jcolebrand2010-12-21 13:00:10 +00:00Commented Dec 21, 2010 at 13:00
-
stackoverflow.com/questions/2566022/updating-batches-of-datajcolebrand– jcolebrand2010-12-21 13:00:47 +00:00Commented Dec 21, 2010 at 13:00
-
1stackoverflow.com/questions/1296100/bulk-insert-asp-netjcolebrand– jcolebrand2010-12-21 13:01:54 +00:00Commented Dec 21, 2010 at 13:01
-
@marc_s I am calling a SP from C# and binding that DataTableRaj– Raj2010-12-21 13:12:34 +00:00Commented Dec 21, 2010 at 13:12
Add a comment
|
2 Answers
Have a look at using SqlBulkCopy Class
Comments
In oracle we have batch insert for example
your query returns two rows with column name as a,b,c
a:b:c
1:2:3
4:5:5
you can use
insert into tab_name(a,b,c)(qry)
commit;
Make it dynamic and it should work.
