Tutorials

SQL intro

Submitted by admin on
SQL is an acronym for Structure Query Language, it is a language which helps program to communicate with the databases, regardless of the type of the database, the SQL syntax is almost the same except for extended commands which certain DBMS support or do not support or simply have its own versions or dialects.

How to Change Connection String of VB.NET Project at Design Time

Submitted by admin on

One of the problems that a beginner encounter when there is a project uploaded here, is they do not know on how to change the connection string that points to the correct database location. This is true with MS Access and even with SQL Server. Some programmers don’t add a code that will automatically change the location of the database just in case it will be ported in other machine.

How to Change the Data Type of a Column Using T-SQL

Submitted by admin on
There are some cases that you need to change the data type of a field in SQL Server by not using the Management Studio Tools. The reason is if your database is replicated. You cannot change it directly using the management studio tools so your best option is to use T-SQL. In my case I have a column name “TransDate” that has a datetime datatype.

How to Differentiate Two Cell Values in DataGridView Control

Submitted by admin on
I read a lot of question about this on the forum and thought it’s time to share with you on how to differentiate two cell values in DataGridView control. By default we use the Value property of cells like: QtyOrdered = InvoiceDetails("Qty", e.RowIndex).Value Another is to use the FormattedValue like: QtyOrdered = InvoiceDetails("Qty ", e.RowIndex).FormattedValue But the two code above will not work if you have a condition like If QtyOrdered > InvoiceDetails ("TotalQty", e.RowIndex).Value Then to determine if the Qty Ordered is less than the

Correct Way to Open a Windows Form in VB.NET

Submitted by admin on

Few months ago I encounter a problem with my windows form bound using a DataSet. When I open the form the first time, it seems that everything is fine. But when I open it again the second time, the fields are become blank. This happens when you trigger the “PerformClick” of “BindingNavigator” under the Form Load event.

This is not actually the common mistake that I encounter. But maybe, you encounter this problem also if you are used with VB 6.0 before.

Here’s the code to open the windows form the correct way:

ComboBox Binding Problem - Does Not Leave Focus

Submitted by admin on

After browsing several forum sites I found so many programmers having problem with ComboBox after they bind it to a DataSet.

The problem actually is not cause by a bug or the like. The error is caused by design. Here’s the following question on the internet that I found that will explain this error further:

http://thedailyreviewer.com/dotnet/view/data-bound-combobox-does-not-leave-focus-106127786

Add MDI Form and Main Menu

Submitted by admin on

In our previous tutorial I discuss on “How to Create Master/Detail Windows Forms” on our Library System Project.

Today we will add MDI Form and create a main menu to open the forms on our project. If you follow closely this tutorial you will have now several Windows Forms on your project.

Please follow the steps below to Add MDI Form and Main Menu on your Library System project.

Stop SelectedIndexChanged from Firing on Form Load Event

Submitted by admin on

If you are using SelectedIndexChanged in your ComboBox may be you encounter a problem with events being fired even if you did not click the ComboBox.

This happens when you open and close your Windows Form. The workaround for this is to use RemoveHandler statement.

Here’s an example: