You are here:   HomeVisual Basic
by Dinesh Thakur 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.

 
by Dinesh Thakur 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.

 
by Dinesh Thakur 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 .

 
by Dinesh Thakur Category: DataBase

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



 
by Dinesh Thakur 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

 
by Dinesh Thakur Category: DataBase

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

 
by Dinesh Thakur 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.

 
by Dinesh Thakur Category: DataBase

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 Category: DataBase

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

 

Page 9 of 9



Subscribe To Free Daily Newsletter!

Get Free News Updates Delivered Directly To Your Inbox
About Dinesh Thakur

Dinesh ThakurDinesh Thakur holds an B.SC (Computer Science), MCSE, MCDBA, CCNA, CCNP, A+, SCJP certifications. Dinesh authors the hugely popular Computer Notes blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps. For any type of query or something that you think is missing, please feel free to contact us.



What's New and Popular