How to delete SQL transaction logs with a query.

June 16, 2011 - 11:18

When using a Microsoft SQL server regularly, you may find that the transaction log can get quite large. If an import is ran every day then the database log file can quickly grow to several gigabytes.

Display the contents of a Table from a Dataset

June 4, 2011 - 11:50

So you have already queried the database and obtained all the needed information which is contained in a database. This example will step through the rows in the table and display the values. I am assuming you already have a datatable in the dataset ds called "Results".

Run a query on an sql database in VB.Net

July 14, 2010 - 17:09

Connecting to a microsoft sql database is done by first creating the database on your server and assigning the correct username and password. Once this is done then create your connection string. This will look something like this:

Run a command on an sql database in VB.Net

July 14, 2010 - 05:48

Connecting to a microsoft sql database is done by first creating the database on your server and assigning the correct username and password. Once this is done then create your connection string. This will look something like this:

  • 1



© 2011 simplevb.net