My suggestion:
String s = "insert into RSBIlls Values(" + cb_sno.Text + ",'" + cb_billno.Text + "','" + dateTimePicker1.Text + "','" + cb_name.Text + "','" + txt_Area.Text + "','" + txt_street.Text + "','" + txt_location.Text + "'," + textBox1.Text + "," + txt_dieselservice.Text + "," + txt_subtotal.Text + "," + txt_servicetax.Text + "," + txt_educess.Text + "," + txt_addcess.Text + "," + txt_grandtot.Text + ")";
Debug.WriteLine(s);
SqlCommand cmd = new SqlCommand(s, con);
Take the contents of the debug screen, run in Management Studio, and see the errors there.
My guess: either
txtLocation.Text
is something like 'Manchester
, England' or one of the others is empty.
Also, don't forget to add single quotes around literal strings ('this is a string', this_is_a_database_object_name).
Tell me if the spirits were right...
:)
Hope this helps,
Pablo.