Saving Data Using DataGridview and Doing Calculations

Hi. Many programmers have problems creating Invoicing and Billing Software. This article will help them to save the data (Items via DataGridView) in the database. And this is for those basic programmers who don't know how to save data using DataGridView in Window Forms using C# and SQL Server.

Code For Saving Data In Database (Microsoft SQL Server) via DataGridView

In this article I have created a function for collecting the information entered by the use and after that he can save all that information in the database.

void Save()

{

try

{

if (dataGridView1.Rows.Count > 1)

{

for (int i = 0; i <= dataGridView1.Rows.Count - 1; i++)
{

string col1 = dataGridView1.Rows[i].Cells[0].Value.ToString();

string col2 = dataGridView1.Rows[i].Cells[1].Value.ToString();

string col3 = dataGridView1.Rows[i].Cells[2].Value.ToString();

string col4 = dataGridView1.Rows[i].Cells[3].Value.ToString();

string col5 = dataGridView1.Rows[i].Cells[4].Value.ToString();

using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString))
{

string insert = "INSERT INTO InvoiceItems(SNo,Quantity,Rate,Description,Total) VALUES (@SNo,@Quantity,@Rate,@Description,@Total)";

con.Open();

SqlCommand cmd = new SqlCommand(insert, con);

cmd.Parameters.AddWithValue("@SNo", col1.ToString());

cmd.Parameters.AddWithValue("Description", col2.ToString());

cmd.Parameters.AddWithValue("@Quantity", col3.ToString());

cmd.Parameters.AddWithValue("@Rate", col4.ToString());

cmd.Parameters.AddWithValue("Total", col5.ToString());

cmd.ExecuteNonQuery();

con.Close();

}

}

}

}

catch (Exception ex)