title: inserting data from datagridview to database
body: <p>There are some existing data in the database and users will be entering new data into the datagridview which I wanted to add into database.</p>
  
  <p>And I  really don't know how to  add ONLY the new inserted rows of data in datagridview into the database. How do I get the new inserted data only? I was told that I can use tempID to assign it to the new inserted row, but I have no idea on how to do it. Can anyone give me some links to it?</p>
  
  <p>This is my code for now:</p>
  
  <pre><code>private void button1_Click(object sender, EventArgs e)
  {
      con = new System.Data.SqlClient.SqlConnection();
      con.ConnectionString = "Data Source=tcp:SHEN-PC,49172\\SQLEXPRESS;Initial Catalog=LSEStock;Integrated Security=True";
      con.Open();
      SqlDataAdapter da = new SqlDataAdapter();
  
      for (int i = 0; i&lt;dataGridView1.Rows.Count-2; i++ )
      {
  
          String insertData = "INSERT INTO CostList(SupplierName, CostPrice, PartsID) VALUES (@SupplierName, @CostPrice, @PartsID)" ;
          SqlCommand cmd = new SqlCommand(insertData, con);
          cmd.Parameters.AddWithValue("@SupplierName", dataGridView1.Rows[i].Cells[0].Value);
          cmd.Parameters.AddWithValue("@CostPrice", dataGridView1.Rows[i].Cells[1].Value);
          cmd.Parameters.AddWithValue("@PartsID", textBox1.Text);
          da.InsertCommand = cmd;
          cmd.ExecuteNonQuery();
      }
  
      con.Close();
  }
  </code></pre>