Posted on: 7/17/2013 4:29:04 PM | Views : 366

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 ...