when i insert a data in a table the error occured like string or binary data would be truncated

Question

hai,
   in sql already i insert 120 rows now  want to insert 20 rows when i insert it there was an error occur like "string or binary data would be truncated",the statement has been terminated.
 
 
 
Thank "u"

Answer 1

Hi Jignesh,
use this for doing that.
string str = "welcome";
string newString = str.Substring(1, str.Length - 1) + str.Substring(0, 1);