What is a record set ? What are its type ? Explain

Category: DataBase

Recordset:

 

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

 

What is SQL, and how is it used in Visual Basic

Category: DataBase

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

 

Explain deference between a data control and data-bound control

Category: DataBase

 

 

What is the purpose of record count and absolute position properties

Category: DataBase

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.

 

Explain how BOF and EOF properties are set and how they might be used in a project

Category: DataBase

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.

 

What are the steps needed to add a new record to database

Category: DataBase

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

 

What is grid control ? How will you create it

Category: DataBase

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.

 

Which controls can be data bound

Category: DataBase

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.

 

Seek method

Category: DataBase

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 .

 

What are the steps needed to delete a record from database

Category: DataBase

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

 

Page 1 of 2



Dinesh ThakurDinesh Thakur is a Columinist and designer with strong passion and founder of Computer Notes. if you have any ideas or any request please get @me on
linkedin FaceBook Twitter Google Plus