by Dinesh Thakur

1. You can bound data to data bound controls like Labels, Text Boxes, Checkbox. If you don?t want user to change the data you use Label control, where user can only view the data else you can use Text boxes.

 
by Dinesh Thakur

1. Two handy properties of the record set are BOF (beginning of file) and EOF (end of file). The BOF property is automatically set to true when the record pointer is before the first record in the record set.

 
by Dinesh Thakur

1. When you want to add new record you have couple of choices. If you are using data control?s navigation buttons, you can allow Visual Basic to do the adds automatically. Set the data control?s EOF action property to

 
by Dinesh Thakur

1. The delete method deletes current record. The user should display the record to delete and click a Delete command button or menu choice.

 
by Dinesh Thakur

The record set object has an Update method, which you can use to save any changes in the data.

 
by Dinesh Thakur

Database tables can be bound to controls, such as text box, labels, checkbox and list boxes. But it displays one row data at a time.

 
by Dinesh Thakur

When you want to make sure that a required field has an entry or that field has valid data, the Validate event is good location to check. If the field is not valid, you can display an error message and cancel the operation.

 
by Dinesh Thakur

Recordset:

 

The current group of records associated with a data control; may be a table recordset , a dynaset, or a snapshot.

 
by Dinesh Thakur

Visual Basic uses Structured Query Language (SQL) to create new dynasets. SQL is an Industrial Standard language for processing relational database.

 
by Dinesh Thakur

The Databound grid control in VB 6.0 adds power and flexibility to your DataBase programs. you can easily provide grid access to any available DataBase.

 
by Dinesh Thakur

You can use the Record count and absolute position properties of the Data Control Recordset to display the RecordNum and RecordCount when viewing DataBase Records.

 
by Dinesh Thakur

The fastest way to search for a particular record is to use the Seek method , which can be used only with a table recordset tab.The Seek method uses indexes for the search , which is much faster than checking every record in the table as you do in a find .