how to textbox and gridview values save in database in c#

Question

how to textbox and gridview values save in database in c# windows application

 

private void btn_Insert_Click(object sender, EventArgs e)

{

string Product_Name = string.Empty;

string Description = string.Empty;

string Qty = string.Empty;

string Unit_Price = string.Empty;

string Tax = string.Empty;

string Total_Amount = string.Empty;

foreach (DataGridViewRow row in this.dataGridView.Rows)

{

Product_Name = row.Cells[0].Value.ToString();

Description = row.Cells[1].Value.ToString();

Qty = row.Cells[2].Value.ToString();

Unit_Price = row.Cells[3].Value.ToString();

Tax = row.Cells[4].Value.ToString();

Total_Amount = row.Cells[5].Value.ToString();

this.Save(Product_Name, Description, Qty, Unit_Price, Tax,Total_Amount);

}

MessageBox.Show("Data Added");

}

private void Save(string Product_Name, string Description, string Qty, string Unit_Price, string Tax, string Total_Amount)

{

//string conString = ConfigurationSettings.AppSettings["conString"];

string sqlStatment = "INSERT INTO TestData( Name,Mobile,Date,Orderno,Description,Qty,Unit_Price,Tax,Total_Amount) VALUES(@Name,@Mobile,@Date,@Orderno,@Product_Name,@Description,@Qty,@Unit_Price,@Tax,@Total_Amount)";

//using (SqlConnection con = new SqlConnection(conString))

{

using (SqlCommand cmd = new SqlCommand(sqlStatment, con))

{

cmd.Parameters.AddWithValue("@Name", Nametxt.Text);

cmd.Parameters.AddWithValue("@Mobile", Phtxt.Text);

cmd.Parameters.AddWithValue("@Date", Datetxt.Text);

cmd.Parameters.AddWithValue("@Orderno", ONtxt.Text);

cmd.Parameters.AddWithValue("@Product_Name", Product_Name);

cmd.Parameters.AddWithValue("@Description", Description);

cmd.Parameters.AddWithValue("@Qty", Qty);

cmd.Parameters.AddWithValue("@Unit_Price", Unit_Price);

cmd.Parameters.AddWithValue("@Tax", Tax);

cmd.Parameters.AddWithValue("@Total_Amount", Total_Amount);

con.Open();

cmd.ExecuteNonQuery();

con.Close();

}

}

}