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.

  • How to save a PDF file in a SQL Server column using vb.net code
  • How to search text in all database objects in MS SQL Server
  • How do I prevent SQL Server sysadmin users write access?
  • Select multiple values from two tables using horizontal relation with other table
  • SQL SERVER - Understanding how MIN(text) works
  • Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'D:'
  • Retrieving Return value from stored procedure
  • Hash passwords using crypto and then save to database
  • What's the correct way to layout this database design? The current design seems bloated
  • Connection timeout for SQL server
  • How to download and view images from SQL Server table?
  • Read data from a SQL server
  • 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.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.