column exceeds the max length limit error RRS feed

  • Question

  • Dear All 

    Please check this error ... i am using MS Sql Server 2008 on back end and i got this error 

    i was using VARCHAR(max) in sql database but in vb datagridview im getting this error

    how i can solve this becz im facing this issue in 6 modules and users are complaining abt it while entering long descriptions it showing this error .

    Friday, November 8, 2019 7:25 AM


  • Try using NVARCHAR(MAX) and make sure the DataColumn MaxLength is -1

    Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.

    NuGet BaseConnectionLibrary for database connections.

    profile for Karen Payne on Stack Exchange

    • Marked as answer by Omi4u Thursday, November 28, 2019 8:51 AM
    Friday, November 8, 2019 10:29 AM

All replies