ASP.NET DataSet: Remember the length of parameters

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!

How to print a calendar using Microsoft Office Outlook 2007

Problem:

You would like to print a calendar, but the standard Microsoft Office Outlook 2007 calendar printing features does not fullfill your needs.

Solution:

Install the Microsoft Office Outlook Calendar Printing Tool and get all your wishes granted. More information is available here. You can skip reading and download the whole application for free.

Happy programming and calendar printing! :-)