Visual Basic 6.0 part 3 - Displaying Data

Displaying data using LISTVIEW object and SELECT statement. just follow the steps below.

1.) First thing to do is add the Components for LISTVIEW press CTRL+T to open components window and find Microsoft Windows Common Controls 6.0 (sp6) and select and then apply. see image.

2.)Add Listview in your form

3.)to set up the listview property press mouse right click and then select properties. Follow the image below.

4.)Go to module and declare this variables.To import listview subitems we need to declare and assign to a variable and then for our recordset also.see image.

See database on what option you like to use in calling the fields.
its either rs.Fields(index) or rs!FieldsName

5.)After done coding run the program. If you successfully run it without bugs it means you copy the code correctly.

6.)Additional Info
Since we have done already our step 2.
Call the display function in your SAVE button.

ou

 and run your program and then add new data. It will automatically display the data without refreshing.

Enjoy :)

Part 4 will be updating data from you database





Database Connection , Insert Data , Display Data , Update Data , Deleting Data , Search Data , Not Isnumeric



Others:
Install VB6.0 in win7 , Crack Win 7 Genuine