gridview to sql server database

Question

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.

Answer 1

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.

Answer 2

Have a look at using SqlBulkCopy Class