We are using Red Gates SQLDoc (http://www.red-gate.com) tool to document our databases and it works just fine. But as a matter of fact we do our documentations on the test server not the real server. And then a problem arises.

SQLDoc has no tool to copy the documentation from one DB to another.

And that's the problem because SQLDoc (and other tools including SQL Management Console itself) put the documentation text into the extended properties of SQL Server 2000 and SQL Server 2005, so you cannot simply copy the documented tables, procedures or functions within the help file. And documenting on the master DB did not prove usefull for us. More...

Paging through a resultset seems to be a common problem with Winforms and Webforms. While you could do it all clientside with loading your complete resultset into a Dataset and then page through it, this will only be reasonable with a small amount of data. If you try to do this with resultsets of more than 1000 rows, the dataset will soon be consuming all of your memory or bandwith when transfering the data from the SQL Server to the Dataset on the client. More...

When I first played around with the new .net 2.0 controls, I was fascinated by the ToolStrip-Control and its endless possibilities to render it to your will by using the new Renderer property.

Having this kind of approach on any user-defined control would give the developer a powerful way of designing his application without forcing him to play around in the inner workings of the source. More...

To give your textboxes a distinctive look has always been a hassle. In the old VB6 days it was almost not possible. The only thing you could do, was to incorporate the textbox into a ActiveX-control and set the looks of the ActiveX-Control.

With the advent of VB.net there seem to be 3 distinctive ways to accomplish this task. With the XPTextbox-control I tried them all and will explain them shortly and point out the advantages and disadvantages. More...