How to Store Records In Database Windows Application C#

Table2

My Records Save like Table1

And I am want to save records table 2

How to do.....???

decimal Unit_Price = Convert.ToDecimal(qtytxtprice.Text);

decimal Tax = Convert.ToDecimal(txttax.Text);

decimal Amount = (Qty * Unit_Price);

decimal PercentageAmount = ((Amount * Tax) / 100);

decimal TotalAmount = Amount + PercentageAmount;

int Sno = dataGridView.Rows.Count ;

dataGridView.Rows.Add(Sno, producttxt.Text, dectxt.Text, txtqty.Text, qtytxtprice.Text, txttax.Text, TotalAmount);

btnclr_Click(sender, e);

CalculateTotalAmount();

ClearData();

}

}

public void CalculateTotalAmount()

decimal taxtotal=0;

decimal totalamount=0;

for(int i=0;i

{

decimal TotalAmount = (Convert.ToDecimal(dataGridView.Rows[i].Cells[3].Value) * Convert.ToDecimal(dataGridView.Rows[i].Cells[4].Value));

taxtotal=taxtotal+((Convert.ToDecimal(dataGridView.Rows[i].Cells[5].Value)*TotalAmount)/100);

totalamount=totalamount+Convert.ToDecimal(dataGridView.Rows[i].Cells[6].Value);

}

TotalTaxtxt.Text=taxtotal.ToString(); //tax total amount text box field value setting

totalamounttxt.Text=totalamount.ToString(); //total amount text box field value setting

}

// Insert records in databse

private void btn_Insert_Click(object sender, EventArgs e)

{

int Billno = billno("Select ISNULL(Max(Billno+1),1) From MainBillForm");

foreach (DataGridViewRow g1 in dataGridView.Rows)

{

SqlCommand cmd = new SqlCommand("insert into MainBillForm (Billno,Name,Mobile_no,Date,Order_Number,Sno,Product_Name,Description,Qty,Unit_Price,Tax,Amount,Tax_Amount,Total_Amount) Values ('" + Billno + "','" + Nametxt.Text + "','" + Phtxt.Text + "','" + dateTimePicker1.Value + "','" + ONtxt.Text + "','" + g1.Cells[0].FormattedValue.ToString() + "','" + g1.Cells[1].FormattedValue.ToString() + "','" + g1.Cells[2].FormattedValue.ToString() + "','" + g1.Cells[3].FormattedValue.ToString() + "','" + g1.Cells[4].FormattedValue.ToString() + "','" + g1.Cells[5].FormattedValue.ToString() + "','" + g1.Cells[6].FormattedValue.ToString() + "','" + TotalTaxtxt.Text + "','" + totalamounttxt.Text + "')", con);

con.Open();

cmd.ExecuteNonQuery();

MessageBox.Show("Records Inserted SuccessFully");

this.Hide();

MainBillfrm sd = new MainBillfrm();

sd.Show();

con.Close();

}

}