C# ต้องการดึงข้อมูลรายการสั่งซื้อจาก Gridview ไปเก็บ ไว้ใน database

private void dgvArticle_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex == -1)
            {
                return;
            }
            else
            {
                int rowIndex = e.RowIndex;
                tbArticle_Id.Text = dgvArticle.Rows[rowIndex].Cells[0].Value.ToString();
                tbArticle_Style.Text = dgvArticle.Rows[rowIndex].Cells[1].Value.ToString();
                tbArticle_Model.Text = dgvArticle.Rows[rowIndex].Cells[2].Value.ToString();
                tbArticle_TypeId.Text = dgvArticle.Rows[rowIndex].Cells[3].Value.ToString();
                tbArticle_Typename.Text = dgvArticle.Rows[rowIndex].Cells[4].Value.ToString();
                tbArticle_Cateid.Text = dgvArticle.Rows[rowIndex].Cells[5].Value.ToString();
                tbArticle_Catename.Text = dgvArticle.Rows[rowIndex].Cells[6].Value.ToString();
                tbArticle_Price.Text = dgvArticle.Rows[rowIndex].Cells[7].Value.ToString();
                tbArticle_Rate.Text = dgvArticle.Rows[rowIndex].Cells[8].Value.ToString();
                tbArticle_Life.Text = dgvArticle.Rows[rowIndex].Cells[9].Value.ToString();
                tbArticle_DepartId.Text = dgvArticle.Rows[rowIndex].Cells[10].Value.ToString();
                tbArticle_Departname.Text = dgvArticle.Rows[rowIndex].Cells[11].Value.ToString();
                tbArticle_Compid.Text = dgvArticle.Rows[rowIndex].Cells[12].Value.ToString();
                tbArticle_Compname.Text = dgvArticle.Rows[rowIndex].Cells[13].Value.ToString();
                tbArticle_Year.Text = dgvArticle.Rows[rowIndex].Cells[14].Value.ToString();
                tbArticle_Note.Text = dgvArticle.Rows[rowIndex].Cells[15].Value.ToString();
            }
        }

string sSqlConnectionString = "SERVER=server;USER ID=sa;PASSWORD=pass;DATABASE=TEST;CONNECTION RESET=FALSE";

            try
            {
                for (int i = 0; i < dataGridView1.Rows.Count-1; i++)
                {
                    string ID = dataGridView1.Rows[i].Cells[0].Value.ToString();    // Column  ID
                    string Name = dataGridView1.Rows[i].Cells[1].Value.ToString(); // Column  Name
                    string Phone = dataGridView1.Rows[i].Cells[2].Value.ToString();  // Column  Phone

                    string sqlQuery = "INSERT INTO TEST_CUST(ID,NAME,PHONE) VALUES('" + ID + "' , '" + Name + "', '" + Phone + "')";

                    SqlConnection SqlConn = new SqlConnection(sSqlConnectionString);
                    SqlCommand SqlCmd = new SqlCommand(sqlQuery, SqlConn);
                    SqlConn.Open();
                    SqlCmd.ExecuteNonQuery();
                   // SqlConn.Close();

                }
                MessageBox.Show("Successfully!");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            } 

for(i=0;i<จำนวนrow;i++)
{
                tbArticle_Id.Text = dgvArticle.Rows[i].Cells[0].Value.ToString();
                tbArticle_Style.Text = dgvArticle.Rows[i].Cells[1].Value.ToString();
                tbArticle_Model.Text = dgvArticle.Rows[i].Cells[2].Value.ToString();
                tbArticle_TypeId.Text = dgvArticle.Rows[i].Cells[3].Value.ToString();
                tbArticle_Typename.Text = dgvArticle.Rows[i].Cells[4].Value.ToString();
                tbArticle_Cateid.Text = dgvArticle.Rows[i].Cells[5].Value.ToString();
                tbArticle_Catename.Text = dgvArticle.Rows[i].Cells[6].Value.ToString();
                tbArticle_Price.Text = dgvArticle.Rows[i].Cells[7].Value.ToString();
                tbArticle_Rate.Text = dgvArticle.Rows[i].Cells[8].Value.ToString();
                tbArticle_Life.Text = dgvArticle.Rows[i].Cells[9].Value.ToString();
                tbArticle_DepartId.Text = dgvArticle.Rows[i].Cells[10].Value.ToString();
                tbArticle_Departname.Text = dgvArticle.Rows[i].Cells[11].Value.ToString();
                tbArticle_Compid.Text = dgvArticle.Rows[i].Cells[12].Value.ToString();
                tbArticle_Compname.Text = dgvArticle.Rows[i].Cells[13].Value.ToString();
                tbArticle_Year.Text = dgvArticle.Rows[i].Cells[14].Value.ToString();
                tbArticle_Note.Text = dgvArticle.Rows[i].Cells[15].Value.ToString();
                เปลี่ยนจาก textbox เป็นตัวแปร string ก็ได้
                แล้วก็ต่อด้วย code ที่ใช้บันทึกลง database  

}