Book review #1: Title: Database programming using vb

Focus: Database programming

Domain: Accounting Software
Tools used: VB 2008, and SQL Server for the windows os.
This book takes you through the steps of developing an accounting software. The first few chapters cover  topics like vb and sql server. Next, the steps for developing an accounting software are outlined.
The steps are fairly detailed and some of them [...]

What you should know to start Developing a Database Software Application using Visual Basic which has to work on a Client Server network

Basics of Visual Basic and SQL Server
Basics of the domain you want to develop the application for.
For example of Accounting domain or Inventory Domain.
Basics of Client / Server Application Development with Visual Basic ( visual basic ) and SQL Server or C# and SQL Server
Knowledge of how to install a Network Operating system.
Knowledge of how [...]

Navigating a Recordset and Binding controls to a recordset using Visual Basic

The Recordset object enables your application to access data returned from an SQL query or stored procedure. Using the Recordset object, you can navigate through the records that have been returned. A Recordset has a conceptual pointer, using which Visual Basic points at any one particular record, which is the current record.
A Recordset object has [...]

Creation of RecordSert as a Server-side Recordset and Client-side Recordset in Visual Basic

The following code is for creating a Server-side Recordset.
Option Explicit
Dim CN As Connection
Dim comobj As Command
Dim rs As Recordset
Private Sub Form_Load()
Set CN = New Connection
Set comobj = New Command
Set rs = New Recordset
rs.CursorType = adOpenStatic
rs.CursorLocation = adUseServer
With CN
.ConnectionString = “Integrated Security=SSPI;Initial Catalog=FinAccounting;Data Source=SYS1”
.Provider = “SQLOLEDB”
.Open
Option Explicit
Dim CN As Connection
Dim comobj As Command
Dim rs As Recordset
End [...]

Creation of Recordset in Visual Basic

Recordset object is created  in the same way as the Connection object and the Command object.
Type the following code in the frmAccountDetails form:
Private Sub Form_Load()
Set CN = New Connection
Set comobj = New Command
Set rs= new Recordset
With CN
.ConnectionString = “Integrated Security=SSPI;Initial Catalog=FinAccounting;Data Source=SYS1”
.Provider = “SQLOLEDB”
.Open
End With
With comobj
.ActiveConnection = CN
.CommandText = “SELECT * FROM AccountsTable”
End With
Set rs [...]

Types of Recordsets in Visual Basic

A resultset  returned from a database server as a result of the execution of an SQL statement can be stored in a Recordset object for further manipulation. In other words, a Recordset object can manipulate data returned by a provider. All Recordset objects consists of records (rows) and fields (columns).
There are 4 types of  recordsets
Dynamic [...]

Executing a Stored Procedure having INPUT and OUTPUT parameter using a Command object using Visual Basic

Executing a Stored Procedure  having INPUT and OUTPUT parameter  using a Command object
Stored procedures may contain output parameters and return values. For example, the procedure GetAccountName, can return the name of the Account for an Account Code passed as a parameter. First, create the stored procedure and then write code in the frmAccountDetails form.
Create Procedure [...]

Executing a Stored Procedure having INPUT parameters using a Command object in Visual Basic

Executing a Stored Procedure  having INPUT parameters  using a Command object
The stored procedure returns names when we pass the account category. As you can well understand, the below procedure accepts an input parameter. So, in order to execute the stored procedure, you need to create a Parameter object by using the CreateParameter method of the [...]

Free Microsoft Visual Basic Download

Many are not aware that they can download and use free of cost, Microsoft Visual Basic 2008 express edition free of cost. Here is the link:
Download Visual Basic 2008
Note that there are simple lessons on the page listed above.

Updating Records using CommandObject in Visual Basic

You can use the SQL Update statement to issue a command that changes a record or group of records. The below code demonstrates how to do this.
Option Explicit
Dim CN As Connection
Dim comobj As Command
Private Sub Form_Load()
Set CN = New Connection
Set comobj = New Command
With CN
.ConnectionString = “Integrated Security=SSPI;Initial Catalog=FinAccounting;Data Source=SYS1”
.Provider = “SQLOLEDB”
.Open
End With
With comobj
.ActiveConnection = [...]