How to Store In Database This type Records In Windows C#

Question

How to Store In Database This type Records In Windows Application C#

Sno	Product name	dec	QTY	Unit Price	Tax	Total-Amount
1	mobile	no	2	5000	10	11000
2	ABC	no	1	500	10	550

Gridview Records

Database save Records

sno	Product name	dec	QTY	Unit_Price	Tax	Total_Amount	Tax_Amount	Grand_Total_Amount
1	mobile	no	2	5000	10	10000	1000	11000
2	ABC	no	1	500	10	500	50	550
0	0	0	0	0	0	10500	1050	11550

private void addbutton_Click(object sender, EventArgs e)

{

if (producttxt.Text != "" && dectxt.Text != "" && qtytxtprice.Text != "" && txtqty.Text != "" && txttax.Text != "")

{

int Qty = Convert.ToInt32(txtqty.Text);

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<dataGridView.Rows.Count-1;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

}

Attachment: databaseRecords.zip

Rafnas T P · Answer

actually you should not save over all total tax and over all total amount in each row you can not save it in the same row because may be this total is for more than one row recordif you wanted to save than you can have a seperate table for this for seperate customer or seperate bill wise you can save this data or dont save any where just calculate in front end or in back end and display it.

Jyoti Jodha · Answer

Yes sir my all records save like table 1 but iam want to all records save like table2 totalTax amount & Grand Total Amount Are show in 0 row

Karthi Keyan · Answer

hi jodha for store the details like in second table you want to do one simple task after store the data's in gridview you should calculate the Total_Amount Tax_Amount Grand_Total_Amount and insert the new row with all 0 values in another fields and total values in that 3 fields like how you insert the another values.

Karthi Keyan · Answer

appolgies for sent the another file. find the attachment.

Jyoti Jodha · Answer

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 (BillnoNameMobile_noDateOrder_NumberSnoProduct_NameDescriptionQtyUnit_PriceTaxAmountTax_AmountTotal_Amount) Values (' + Billno + '' + Nametxt.Text + '' + Phtxt.Text + '' + Datetxt.Text + '' + 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(); } }

Karthi Keyan · Answer

Find the attachment. in that i changed your Database table format. use like that. and why you are calculating the Total Amount twice??? is there any reason behind that??

Jyoti Jodha · Answer

This is Example type data Not Real data in database I am want to save in data this type......

Nitin Sontakke · Answer

I had already told you in one of your another questions. Let me say that again to you. The kind of information which can be derived from original information is NEVER persisted in the database. It should be DERIVED as and when required. Imagine someone changes the base information. Then you will have to keep on changing the calculated information also. What a user sees on the screen and what is present in database are TWO entirely different things. From the stored data you create a VIEW which is seen by the user. You DO NOT stored what user sees in the database. Such a practise is against 'Normalization'. Google and read about it.