gridview to sql server database
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.
2 Solutions collect form web for “gridview to sql server database”
Have a look at using SqlBulkCopy Class
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.