One of
INVOICE_EXC_DUTY1.Text(),INVOICE_E_CESS1.Text(),INVOICE_SHE_CESS1.Text(),INVOICE_TOTAL1.Text(),INVOICE_TAX1.Text(), INVOICE_A_TAX1.Text(, INVOICE_G_TOTAL.Text(), INVOICE_EXC_WORDS.Text(), INVOICE_G_WORDS.Text(), INVOICE_PH_NO.Text()
is greater than 20 characters
OR
one of
INVOICE_TIN.Text(),INVOICE_ECC.Text(),INVOICE_RANG.Text(),INVOICE_DIV.Text(),INVOICE_COMM.Text(),INVOICE_QTY1_TOTAL.Text(),INVOICE_QTY2_TOTAL.Text()
is greater than 50 characters
OR
INVOICE_ADD.Text()
is greater than 500 characters
You haven't supplied the data that you are passing to the statement so we can't tell you exactly which one.
You can truncate the data before passing it into this statement (example of how to do that
here[
^])
or you can (and should) validate the content before you get to this point.
Lastly, this is a bad way to format an insert statement - read up on
sql injection[
^]