Tutorials

How to Attach and Detach a Database

Submitted by admin on

Sometimes you want to transfer or backup your database in SQL Server. When the database is attached you cannot copy/move it to any location. All you have to do is detach it first using SQL Server Management Tools.

Another reason why I write this tutorial is to teach you so that when we finish the Library System project you will be able to switch from my own database to your own database just in case you want to differentiate each of the table.

To attach a database

1. Open SQL Server Management Tools.

2. Right click Database and click Attach.

How to Create Database Relationships

Submitted by admin on

In my previous tutorial I discuss on “How to Add Table to Your Existing Database”. Now, I will explain to you on how to create database relationships between one or more tables. Relationship is very important to prevent data inconsistency in your database. For example, you cannot add record in the related table without first adding a record in the primary table.

A relationship exists when two tables are related using a primary key and a foreign key.

How to Add Table to Your Existing Database

Submitted by admin on

In my previous tutorial I discuss on “How to Create Database in SQL Server 2005 Express Edition”. This time you will learn how to add a table in your “LibSys” database using SQL Server Management Studio.

Since LibSys database may contain several tables, I will only teach you to create at least one table and the rest will be done by executing a script.

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.

Populating Elements

Submitted by kevern010101 on
  1. Option Explicit
  2.     Dim conn As ADODB.Connection
  3.     Dim rs As ADODB.Recordset
  4.    
  5.    
  6.    
  7.    
  8. ' pupulate element
  9. ' @author: Kevern
  10. ' @date: checkDate 07/28/2009
  11. Public Sub init()
  12.     Set conn = New ADODB.Connection
  13.     Set rs = New ADODB.Recordset
  14.         conn.connectionString = ConnectionStringModule.connectionString
  15.             With conn

Google Map For Your Web Applications

Submitted by ravenr1 on
Hey , its so simple. Where am I? [inline:whereamid.jpg=Where Am I] The current location of the map is where I am situated. Copy and paste the code to you web projects making it NEAT. You can also use the ff. link to get the coordinates of the location you want to appear. http://www.gorissen.info/Pierre/maps/googleMapLocation.php