-
When specifying varchar or nvarchar parameters in stored procedures or functions, get into the habit if specifying the size. If you don't you will find yourself in a situation with difficult to find bugs, because if you don't specify a size, SQL Server assumes a default of 1. For instance, running...
-
If you need to restart your .NET application, there are a number of ways to do it. The most commonly ised is to programatically kill the process and then start it, using the System.Diagnosics.Process class. A better way is to use the lesser know System.Windows.Forms.Applciation.Restart() method. The...
-
If you're doing development against an Oracle database, you can use the built in Oracle client, System.Data.OracleClient. However this is a bad idea for a two reasons: It will be deprecated in .NET 4.0 Oracle's provider, ODP.NET is better in several ways: Faster Supports more Oracle features...
-
In the course of your development, you might find that you need to change the font style of a control to somthing like bold or italic. Upon investigation, you find that each control has a Font property, that additionally has a boolean Bold property. So you would attempt the following: 1: // 2: // Set...
-
In the lifetime of your application you undoubtedly create several forms and present them to the user. The code will invariably look as follows: In C# 1: //Create the form 2: Form f = new FormUser(); 3: //Show the form 4: f.Show() In VB.NET 1: 'Create the form 2: dim f = new FormUser() 3: 'Show...