Page 240 - Open Soource Technologies 304.indd

Event Driven Programming

As part of the effort to develop Visual Studio 2005 and SQL Server 2005, Microsoft is addressing
all these limitations of MDSE, replacing it with a new product called SQL Server 2005 Express.
While information about SQL Server 2005 Express has so far been targeted at Framework
developers, this article will show how SQL Server 2005 Express is a boon for Visual Basic 6
development as well. SQL Server 2005 Express will provide the developer power of SQL Server,
but also the ease of use of access, by letting we connect directly to a database file on disk. Best
of all, it’s completely free, and can be redistributed with application.
10.5.2 Getting Started with SQL Server 2005 Express

If we want to work with SQL Server 2005 Express, the first step is to download and install it.
SQL Server 2005 Express is part of the family of Express products that can be found at http://
lab.msdn.microsoft.com/express/. Prior to installing SQL Server 2005 Express,
Unlike MSDE, SQL Express also includes an administrative tool known as Express Manager,
which lets we create databases and execute queries (see Figure 10.15).

Figure 10.15: Using Express Manager to Create a Sample Database.

10.5.3 Connecting from Visual Basic 6
To start working with Express, a simple user interface was created that uses an MSHFlexGrid
to display data (see Figure 10.16).

Figure 10.16: Using Grids to Display Data.

234 LOVELY PROFESSIONAL UNIVERSITY