{"id":3621,"date":"2013-07-15T10:21:07","date_gmt":"2013-07-15T02:21:07","guid":{"rendered":"http:\/\/www.vbtutor.net\/?page_id=3621"},"modified":"2018-06-24T18:27:11","modified_gmt":"2018-06-24T10:27:11","slug":"visual-basic-2012-lesson-31-working-with-databases-part-3","status":"publish","type":"page","link":"https:\/\/www.vbtutor.net\/index.php\/visual-basic-2012-lesson-31-working-with-databases-part-3\/","title":{"rendered":"Visual Basic 2012 Lesson 31: Working with Databases Part 3"},"content":{"rendered":"

[Lesson 30]<\/a>\u00a0<\/strong><<\u00a0[CONTENTS]<\/a><\/strong>>>[Next]<\/a><\/strong><\/h4>\n

In previous lessons, you have learned how to connect to a database as well as filling up the table with data in Visual Basic 2012, now you shall learn how to manipulate data in the database. Manipulating data means adding news records, editing records, deleting records, browsing records and more.<\/p>\n

31.1 Browsing Records\u00a0<\/strong><\/h2>\n

In the previous lesson, we have learned how to display the first record using the showRecords sub procedure. \u00a0In this lesson, we will create command buttons and write relevant codes to allow the user to browse the records forward and backward as well as fast forward to the last record and back to the first record.The first button we need to create is for the user to browse the first record. We can use button’s text <<\u00a0<\/strong>to indicate to the user that it is the button to move to the first record and button’s text >> to move to the last record. \u00a0Besides we can use button’s text < \u00a0for moving to previous record and button’s text > \u00a0for moving to next record.
\n