The value violates the MaxLength limit of this column


  • pleas help me

    i have textbox that binding to dataset table1.name
    my database in sqlserver 2000,my lenght name= 100 and nchar
    but i update sqldataadapter e error ecord The value violates the MaxLength limit of this column. please help me
    what error happen my lenght is 50 and my input 20 ?
    my database lenght is 100 but my input char is 20 but this error happend
    please help me
    Saturday, July 29, 2006 6:48 AM

All replies

  • Try using nvarchar instead of nchar as the field type...
    Sunday, July 30, 2006 12:43 PM
  • Didn't help me...

    Thursday, August 16, 2007 9:41 PM
  • Make certain that the max length value of the column is the same in your dataset and in your database, also when do you get the error, are you trying to update data to the database when you recive this or, are you just inserting the row in the Table in the data set?


    Friday, August 17, 2007 5:52 PM

    Try deleting some of the space to the right of the value in the field, then modify the field.
    Sunday, November 04, 2007 7:36 PM