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

Visual Basic 6.0 part 2 - Inserting Data

This is a basic data inserting using Insert SQL statement for beginners.
1.) Make a table in your database name it tblData and has 3 fields name , age and gender . see the image below

2.) In your form  drag objects  2 textbox  ,1 combo box and 1 command button. Do not rename the objects and change the caption of the command button to SAVE.

3.) Go to combo box properties and go to list and then input Male and Female for your dropdown list.

4.)Lets start coding. Double-click the save button and then input the code. see the image below.

tips:BE CAREFUL number and string has different syntax if  your database value is string like ex. fullname use this  statement  ' " & text1 & " '  while the number value has no single quote " & text2 &". 

5.)After coding run the program.Input your name ,age and gender. Error will occurred if you leave it blank or input string to age.

 6.)after it successfully added!! check your database..

Enjoy :)

Part 3 will be displaying data from database using listview





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



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

Visual Basic 6.0 part 1 - Database Connection

All we have to do here is only the database connection using Microsoft Access and nothing else. If you already know what it is,skip to other part which makes helpful for you.

1)Open VB6.0 application. Go to project tab and select references. check if  Microsoft  ActiveX Data Objects is selected if not SELECT only one. see the image below

2.)Add module and Save the Project in one folder and lets the coding.

3.)Go to module and code. follow the code see image below

4.)After coding at the module go to Form1 double click and then call the function. Be sure it is coded at the form_load.

5.) After done coding click SAVE and then Run the program. If the msgbox pop-up it means your successfully connected to database

Enjoy :)

Part 2 is SQL Statement, Inserting Information to the 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

Crack Windows 7 using ULoader

Helping you out of trouble , i mean genuine win7. just follow the steps below.

1) download a ULoader , browse google and it will give you the link. I used the ULoader6.0.0.6 Orbit30

 2)Run ULoader  and select the ULOADER TAB , select your computer brand , use DEFAULT loader and then Install

3)Go to SLIC/MOD tab same procedure select your computer brand and install

 4)OEM info TAB select brand and input your MODEL and then apply

5) Last step KEYCHECK-Installer tab  select server and then click CHECK KEY wait until done loading. Finally Reboot your computer.

after rebooting check your propierties "GENUINE"

Enjoy :)

Installing Visual Basic 6.0 in Windows 7 (32/64)

-Even though my OS is Windows 7, I still need to fire up Visual Basic 6.0. Just Follow the steps below to run your visual basic 6.0 smoothly in Win 7 or Vista-

1) Create a 0-byte file in C:\Windows 

2.Go to visual basic 6.0 installer and run SETUP.exe as ADMINISTRATOR , if there's warning compatibility just click RUN.

3.SELECT, CUSTOM setup then click next , on the custom setup option , install only the following below and nothing else.
              *Microsoft Visual Basic 6.0
              *Active X
              *Data Access
              *Graphics
and click continue and the installation will start and complete.

4.Skip the installations of the MSDN CD, Back Office and SNA server , and uncheck the checkbox for "register now"

5.Final steps to make visual basic run very smoothly under win 7. Go to  C:\Program Files\Microsoft Visual Studio\VB98 , right clicking the VB6.exe ,and select PROPERTIES, go to COMPATIBILITY tab , check the following:
            *Run this program in compatibility mode for Windows XP (Service Pack 3)
            *Disable Visual Themes
            *Disable Desktop Composition
            *Disable display scaling on high DPI Settings and your "DONE"

-Enjoy :)