Visual Basic .NET

Display Record in DataGridView Based on ComboBox Selected Value

Submitted by admin on

In this tutorial I will teach you on how to display related record based on the selection value from a ComboBox.

The example displays a student’s subject in a DataGridView after a SelectedIndexChanged event of a ComboBox.

This tutorial assumes that you already know how to add a DataSet in your project.

The following are important steps in order to understand how I made this simple program.

1. Bind a ComboBox

[inline:ComboBox_Data_Binding.jpg=Bind a ComboBox]

2. Add a query in the Course Table under DataSet designer

How to Pass Value from One Form to another Form

Submitted by admin on

I think it’s time again to teach you on the features that can be found on my program like Hotel Reservation System (VB.NET).

A while ago I received a comment on how to pass value from one form to another form. Although I have already done this in almost all of my program but I know that some of you miss the opportunity to analyze it due to the complexity of the program.

Syntax error in UPDATE statement

Submitted by admin on

While I was working with Visual Basic .NET by adding a form to manage user account in my system I found an error called “Syntax error in UPDATE statement”. After figuring out what’s the cause of this error I found out that it was the name of the field that is causing the problem.

In my Users table I have the following fields:

UserID
Password
CompleteName

As you can see all of these fields are valid. The statement to save a record back to its database is:

Banking System

Submitted by admin on
This is an unfinished project for Banking System. I just want to upload it here so you will have an idea before the system becomes so complicated for a newbie’s programmer. The system has a functional customer’s profile, login system, manager user account, server path configuration, and a simple report. I am using SQL Server 2000 as a database server so you can upgrade it to a newer version of SQL