Hi,
I want to insert Date/DateTime data in a table PaymentDetails,where there is a field called expirydate having datatype datetime
Now here's the Code:-
ctn.dmlsmt("insert into ShoppingCart values('" + ss1.bino + "','" + TextBox1.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox2.Text + "','" + TextBox5.Text + "','" + TextBox8.Text + "','" + TextBox7.Text + "','" + Convert.ToDateTime(TextBox6.Text)
+ "'," + ss1.tprc + ")");
textbox6 caryying d datetime field
////This Exception is showing
String or binary data would be truncated.
The statement has been terminated.
Go to the complete details ...