Database Application

 

A database application can be created using data control in Visual Basic. The data control supports some methods that are useful in manipulating the database, for example, to move the pointer to a certain location. The following are some of the useful commands:

data_navigator.RecordSet.MoveFirst                       ' Move to the first record

data_navigator.RecordSet.MoveLast                       ' Move to the last record

data_navigator.RecordSet.MoveNext                      ' Move to the next record

data_navigator.RecordSet.Previous                        ' Move to the first record

data_navigator.RecordSet.AddNew                          ' Adds a new record

data_navigator.RecordSet.Update                           ' Updates and saves the new record

data_navigator.RecordSet.Delete                            ' Deletes a current record

*note: data_navigator is the name of data control

In the following example, you need to insert four commands and label them as First Record, Next Record, Previous Record and Last Record as well as  name them as cmdFirst, cmdNext, cmdPrevious and cmdLast.You also need to insert the data control.They will be used to navigator around the database without using the data control.

The Interface

The Code

Private Sub cmdFirst_Click()
dtaBooks.Recordset.MoveFirst
End Sub


Private Sub cmdNext_Click()                     
dtaBooks.Recordset.MoveNext     
End Sub


Private Sub cmdPrevious_Click()
dtaBooks.Recordset.MovePrevious
End Sub

Private Sub cmdLast_Click()
dtaBooks.Recordset.MoveLast
End Sub

 

 

 

 

<Back to Sample Programs>

Copyright ® 2008 Dr.Liew Voon Kiong . All rights reserved |Contact: admin@vbtutor.net

[Privacy Policy]