How to Create Database in SQL Server 2005 Express Edition

Submitted by admin on

In this tutorial you will learn how to create a Database in SQL Server 2005 Express Edition. The name of the database that we are going to create is “LibSys” which stands for Library System.

Note that I am using SQL Server Management Studio that is bundled with SQL Server 2008 R2. Regardless of version that you are using the environment still looks the same.

Please follow the steps below to create a database.

Visual Basic .NET 2008 Tutorial

Submitted by admin on

In this tutorial I will teach you on how to create a Windows Application using Visual Basic .NET 2008. For the sake of this tutorial I will be using Library System as the system model.

I came up with this idea in the hope to help beginner who wish to learn Visual Basic .NET the EASY WAY. I know there are a lot of tutorials out there but they focus on different things. Unlike this tutorial I will create an actual application which will guide you up to the end of this article.

Insert Null Value into Date/Time Field

Submitted by admin on
This simple project will simply insert a null value to a date/time field if the checkbox within DateTimePicker is False. In order to determine if the Checkbox is true/false you need to use the isNull function. Private Sub CmdInsert_Click() Dim cn As New Connection Dim strSQL As String cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Data.mdb;" strSQL = "INSERT INTO NOSOld