Save GridView records to SQL Server database

Refer this link....

http://www.aspsnippets.com/Articles/Save-and-Retrieve-Dynamic-TextBox-values-in-GridView-to-SQL-Server-Database.aspx

You can loop through the rows in GridView and extract each row values to be inserted.

Here's a quick example:

protected void Button1_Click(object sender, EventArgs e)
{
 StringCollection sc = new StringCollection();
 string field1 = string.Empty;
 
 for (int i = 0; i < GridView1.Rows.Count; i++)//loop the GridView Rows{

            field1 = GridView1.Rows[i].Cells[0].Text; // get the  field to be Inserted
            sc.Add(field1); // add the field to be Inserted in the StringCollection

 }
 
     InsertRecords(sc); // call method for insert and pass the StringCollection values
     
}


//Multiple Inserts
private void InsertRecords(StringCollection sc)
{
   SqlConnection conn = new SqlConnection("Your Connection String");
   StringBuilder sb = new StringBuilder(string.Empty);
 
   foreach (string item in sc)
   {
     const string sqlStatement = "INSERT INTO TableName (ColumnName) VALUES ";
     sb.AppendFormat("{0}'{1}'; ",sqlStatement, item);
   }
   try
   {
            conn.Open();
            SqlCommand cmd = new SqlCommand(sb.ToString(), conn);
            cmd.CommandType = CommandType.Text;
            cmd.ExecuteNonQuery();
    }
    catch (System.Data.SqlClient.SqlException ex)
    {
            string msg = "Insert Error:";
            msg += ex.Message;
            throw new Exception(msg);
     }
     finally
     {
            conn.Close();
     }

}

Thanks for the code...

I am getting error as "insert error" I am using a columns.

const string sqlStatement = "INSERT INTO TableName (ColumnName) VALUES ";

Refer here on how to write queries

http://www.aspsnippets.com/Articles/Parameterized-Queries-ADO.Net.aspx

What's the actual error you get? can you post it here?

SabirJani says:

Thanks for the code...

I am getting error as "insert error" I am using a columns.

const string sqlStatement = "INSERT INTO TableName (ColumnName) VALUES ";

     sb.AppendFormat("{0}'{1}'; ",sqlStatement, item);

I am not able to get this line of code plz send the code as example of a columns ...