title: how i can insert data into database from gridview
body: <p>SqlConnection connStr = new SqlConnection
      ("Data Source=SERVER;Initial Catalog=HRPR;Persist Security Info=True;User ID=hr;Password=11");</p>
  
  <pre><code>SqlCommand com;
  
  protected void Button2_Click(object sender, EventArgs e)
  {
  
  SqlConnection connStr = new SqlConnection("Data Source=SERVER;Initial Catalog=HRPR;Persist Security Info=True;User ID=hr;Password=11");
  connStr.Open();
  foreach  (GridViewRow g1 in GridView1.Rows) 
  {
      com = new
      SqlCommand("INSERT INTO tblExmWrittn(Cirname,publishingDate,ApplicantId,Applicantname,HighestMrk,WrittnAchievMrk) VALUES( '" + row.Cells[0].Value.ToString(); + "', '" + row.Cells[1].Value.ToString();+ "' , '" + row.Cells[2].Value.ToString();+ "' ,'" + row.Cells[3].Value.ToString();+ "','" + row.Cells[4].Value.ToString();+ "' ,'" + row.Cells[5].Value.ToString();+ "','" + row.Cells[6].Value.ToString();+ "')", connStr);
  
      com.ExecuteNonQuery();
      connStr.Close();
  }
  
  Label1.Text = "Records inserted successfully"; 
  
  
  }
  </code></pre>