New set of articles on ERP

New set of articles posted on :
ERP Articles
Click above link for all articles on ERP

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 [...]

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 = [...]

Retrieving data from the SQL Server database Using the Command Object in Visual Basic

A Command object is used to define an SQL command that you can execute on a data source.A Command object requires a Connection object. Data returned as a result of the execution of a command is accepted and stored in a Recordset object. The following diagram shows the relation between a Command object and a [...]

Visual Basic Single Point Resource of useful links:

A collection of Visual Basic Links:
Visual Basic Tutorial – Beginners
Visual Basic Tutorials for Newbies

First Visual Basic 6 Program Designing and Writing
Gary Beene’s Visual Basic Tutorials (popular)

VB Helper Tutorials
VB Tutorials Cool ones
Visual Basic journey tips tricks and tutorials
DevCentral – Visual Basic Tutorials
Visual Basic Info. covered on every aspect
Visual Basic Section
Visual Basic [...]

Yahoo Directory Visual Basic

Here is the link for Visual Basic in Yahoo Directory.
Visual Basic in Yahoo Directory

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!