how to add 0 row in database Windows Application #

Question

how to add 0 row in database

and How to Create 0 Row Insert Query For Insert data in database

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

Rafnas T P · Answer

hi jyothi why do you wnated to store tax total and grand total is it necessary? instead of that you can display in front by calculating.

Subash · Answer

hello jyothi why do you like to add the total in the records?

Rafnas T P · Answer

ok. Is those data's are base on customer basis or any bill wise I mean is there any unique column for those records?

Jyoti Jodha · Answer

actually I am Want to save records like Table Records Save How Can One Table Store All Data in DataBase like Table.....???

Jyoti Jodha · Answer

ohk sir I Am Create two table Now how to insert Data in two table

Ramesh Palanivel · Answer

Hi Jyothi Create the bill no in table 1 and store the same bill no in table 2 and set this bill no as foriegn key in table 2.

Jyoti Jodha · Answer

If We Create Two Table Then How to generate Bill no in Table1

Ramesh Palanivel · Answer

HI Jyothi The best way is Store the Id(PK)BillnoOrder_NumberDateCustomerNameTotalTaxAmountTotalAmount in Table1 and Store the Id(PK)BillId(FK_table1_Id)Product IdProductNameQtyUnitPrice tax amountTotalAmount in table2 This is the best way to maintain the records.

Jyoti Jodha · Answer

Data Insert Query is this In Table m Don't show Customer Details foreach (DataGridViewRow g1 in dataGridView.Rows) { SqlCommand cmd = new SqlCommand(insert into MainBillForm (BillnoNameDateOrder_NumberSnoProduct_NameDescriptionQtyUnit_PriceTaxAmountTax_AmountTotal_Amount) Values (' + Billno + '' + Nametxt.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(); }

Ramesh Palanivel · Answer

Hi Jyothi May I know where you are saving the customer details in this table?

Jyoti Jodha · Answer

Hello Sir All Records Save in One Table Don't Use Two Table....

Ramesh Palanivel · Answer

Hi Jyothi Instead of saving total value in table2  store the totals in table1.. It will help you!..