Software Tips

Normally a Frontend Software is used to design the Input screens, processing the data in the database, to develop menues and reports generation i.e. output generation. Visual Basic is very useful Front end software. Given are some routines which are helpful for a software design.

Connection of a database to the frontend Visual Basic

A connection with database using Active X Data Objects Controls, in Visual Basic. It is the easiest way to connect with a database.
To add a ADO Data control in the tool Box of a Visual Basic. Select Components from the top Project Menu and select Microsoft ADO Data Controls. An Icon will appear in the tool box for the ADO Data Control.

Insert a form on the screen. Put 4 Text Boxes in the form for the four fields we want to retrieve from the database. e.g. Text Box Names --- Text1, Text2, Text3, Text4. Put two command Buttons on the screeen for navigation of the data. e.g. names of the command button Command1, Command2.

Declare the following variables before any subroutine

Dim Connect1 as new ADODB.connection
Dim Recordset1 as new ADODB.recordset
Dim Sqlstring as String

Connect1.Constring = "Providers = SQLOLEDB; Data source = path of the file from which the data is to be displayed on the screen; "
Connect1.open

For getting data from table i.e. database
SqlString = "Select * from Tablename"
Recordset1.open sqlstring, connect1, cursor_type_for_the_table, lock_type_for_table

For asigning the value of field from table to the textboxes on the screen
Text1.text = Recordset1!field1
Text2.text = Recordset1!field2
Text3.text = Recordset1!field3
Text4.text = Recordset1!field4

Note: "! is called as bang operator"