Problem:

You have just changed the size of a varchar column (perhaps a size 20 to a size 50) in your database. You have then manually updated your data set to use the new size, but your data set does not save values with the new size. It keeps cutting off text.

Solution:

You have forgot to set the size of the parameter in your customized query.

• Select the query in on the table adapter.
• Right click and select properties.
• Expand the Parameters property and change the size of your column.

Now your problem is solved!

Happy programming!