September 2, 2014
Hot Topics:
RSS RSS feed Download our iPhone app

Visual Basic Database Tutorial - Part 4

  • November 19, 2002
  • By Karl Moore
  • Send Email »
  • More Articles »

When it comes down to databases, you can do virtually everything in code. Here are a few of the top properties and methods of the Recordset object for you to play around with:

  • MoveNext - Moves to the next record in the Recordset
  • MovePrevious - Moves to the previous record
  • MoveFirst - Moves to the first record
  • MoveLast - Moves to the last record
  • Edit - Enters edit mode, for changing fields
  • Update - Saves any edits
  • AddNew - Adds a new, empty record
  • Delete - Deletes the current record
  • RecordCount - (Number) Returns the number of records currently accessed (move to the last record to get total number of records)
  • BOF - (Boolean) Hit when you step before the first record in a Recordset
  • EOF - (Boolean) Hit when you pass the last record in a Recordset
  • Indeed, using these simple properties and methods you could very simply replicate all the functionality of the Data control.

    Go on, have a go! Try to build a simple Customer browsing application, similar to the one we created in the third tutorial.





    Page 7 of 8



    Comment and Contribute

     


    (Maximum characters: 1200). You have characters left.

     

     


    Sitemap | Contact Us

    Rocket Fuel