In this article I will explain to you on how you can use some part of the code in Hotel Reservation System (VB.NET).

Introduction

In this article I will explain the important procedure or function that I used in Hotel Reservation System. I wrote this article in the purpose that you will be able to use some of the useful code here in my application. May it be a payroll system, inventory system, or any application that have the same concept like filling a Listview or Combobox.

Background

I made an upgrade with my Hotel Reservation System from VB 6.0 to VB.NET. Just a note though for VB 6.0 programmer –kindly continue with what you are doing right now if you feel you are more productive in version 6.0. But if you want to upgrade your knowledge, then I recommend using the new version which is VB.Net.

Using the Software

My Hotel Reservation System will help you manage a collection of data in your hotel. Moreover, you can record a reservation, check in, check out, payments, etc.
Since the purpose of this article is to teach you the importance of source code within this program, I attached here a link where you can read simple tutorial from my website at Free Hotel Management System Manual.

Using the Code

May be this code isn’t new to all of you but I do believe there are still programmer out there who needs this. I have three important code snippets to share which I used in this program – Hotel Reservation System.

Filling a ListView Control

Overview

The Windows Forms ListView control displays a list of items with icons. You can use a list view to create a user interface like the right pane of Windows Explorer. The control has four view modes: LargeIcon, SmallIcon, List, and Details. Source: Microsoft Visual Studio 2008 Documentation

In the previous paragraph, listview is used to display a list of items. So, in my application I used it to display a list of records from a table with a customize column.
To fill a listview in my program you call it like:

FillListView(lvList, GetData(sSql))

Where lvList in the first parameter is a ListView control in the FillListView procedure. The second parameter – GetData(sSql) will first call the GetData function and returns a data using OleDbDataReader.

Before we call the FillListView procedure, we will call first the procedure named FillList. In this procedure you can customize the number of columns that you want to show in a listview.

Here’s the code for FillList procedure:

<div style="background-color: #F8F8F8;">