incorrect syntax near ' 0'. in window Application c#

Jyoti Jodha

foreach (DataGridViewRow g1 in dataGridView.Rows)

{

cmd = new SqlCommand("insert into MainBillForm Values (Datetxt.Text,Nametxt.Text,Phtxt.Text,ONtxt.Text,TotalTaxtxt.Text,totalamounttxt.Text,row.Cells[0].FormattedValue.ToString(),row.Cells[1].FormattedValue.ToString(),row.Cells[2].FormattedValue.ToString(),row.Cells[3].FormattedValue.ToString(),row.Cells[4].FormattedValue.ToString(),row.Cells[5].FormattedValue.ToString(),row.Cells[6].FormattedValue.ToString())", con);

con.Open();

cmd.ExecuteNonQuery();

MessageBox.Show("Records Inserted SuccessFully");

con.Close();

}

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel9y ago
Accepted answer
Hi Jyothi,

Try this code,
foreach (DataGridViewRow g1 in dataGridView.Rows)
{
cmd = new SqlCommand("insert into MainBillForm Values ('"+Datetxt.Text+"','"+Nametxt.Text+"','"+Phtxt.Text+"','"+ONtxt.Text+"','"+TotalTaxtxt.Text+"','"+totalamounttxt.Text+"','"+row.Cells[0].FormattedValue.ToString()+"','"+row.Cells[1].FormattedValue.ToString()+"','"+row.Cells[2].FormattedValue.ToString()+"','"+row.Cells[3].FormattedValue.ToString()+"','"+row.Cells[4].FormattedValue.ToString()+"','"+row.Cells[5].FormattedValue.ToString()+"','"+row.Cells[6].FormattedValue.ToString()+"')", con);
con.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Records Inserted SuccessFully");
con.Close();
}
Ramesh Palanivel9y ago
Hi Jyothi,

Try this code,
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);
}
TaxTotalAmount.Text=taxtotal.toString(); //tax total amount text box field value setting
TotalAmount.Text=totalamount.toString(); //total amount text box field value setting
}
Jyoti Jodha9y ago
See This Image
Total Tax Show 2100

Not Show 30
Ramesh Palanivel9y ago
Hi Jyothi,
I am note clear.. Can you explain briefly?
Jyoti Jodha9y ago
TotalTax is Show only add Taxt Values
Donot Show How much tax in Total Amount
I mean Show Tox Rupies
Not Add Tax Values Add
Ramesh Palanivel9y ago
Hi Jyothi,

Try this code,
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
{
taxtotal=taxtotal+Convert.toDecimal(dataGridView.Rows[i].Cells[5].value);
totalamount=totalamount+Convert.toDecimal(dataGridView.Rows[i].Cells[6].value);
}
TaxTotalAmount.Text=taxtotal.toString(); //tax total amount text box field value setting
TotalAmount.Text=totalamount.toString(); //total amount text box field value setting
}
Jyoti Jodha9y ago
In This Image
How to get tax Price (Tax) And Total Amount ......???

This recods show in Gridview down Text box
Like Tax show how Much Tax
And Total Amount Show All Gridview Rows Total Amount.....
Ramesh Palanivel9y ago
Hi Jyothi,

Kindly post exact issue what you are getting while inserting the record.
Jyoti Jodha9y ago
// Add in Grid view
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);
ClearData();
}
}
//Add In Database
private void btn_Insert_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow g1 in dataGridView.Rows)
{
cmd = new SqlCommand("insert into MainBillForm Values ('" + 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");
con.Close();
}

}
Ramesh Palanivel9y ago
Hi Jyothi,

Instead of g1 in foreach loop, change row.. It will work..
Jyoti Jodha9y ago
row.Cells[0].FormattedValue.ToString()
Ranjeet Patra9y ago
Hi Jyoti,

Better to go for a stored procedure instead of writing inline queries like this.
Write an stored procedure which will accept the input parameters fpr your insert operation.

Reference:

https://www.codeproject.com/Tips/1007874/A-Beginner-s-Guide-to-SQL-Server-Stored-Procedures

https://www.codeproject.com/Articles/15403/Calling-Stored-procedures-in-ADO-NET