DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

ListView Help..

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site

Thread Solved

•

Join Date: Sep 2005

Posts: 2

Reputation: bad_robot is an unknown quantity at this point

Solved Threads: 0

bad_robot

Offline

Newbie Poster

ListView Help..

Feb 9th, 2007

Hi i'm new to VB6 and i just wanted to ask how to save the columns in a ListView to an Access DB... The format i use to save individual textbox to an Access DB is....

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
 
With adorecordset
 .Fields!Name = Text1.Text
 .Fields!Address = Text2.Text
 .Fields!Phone = Text3.Text
End WIth
 
With adorecordset
 .Fields!Name = Text1.Text
 .Fields!Address = Text2.Text
 .Fields!Phone = Text3.Text
End WIth

I just wanted to know how to do somthing like this with a ListView..

Thank You!

Last edited by bad_robot; Feb 9th, 2007 at 8:48 pm.

•

Join Date: Sep 2005

Posts: 2

Reputation: bad_robot is an unknown quantity at this point

Solved Threads: 0

bad_robot

Offline

Newbie Poster

Re: ListView Help..

Feb 10th, 2007

Its me again i figured out how to save a row in a ListView into an ACCESS DB its something like this...

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
Private Sub Command2_Click()
    With adoRecordSet
        .AddNew
        .Fields!Name = itemToAdd.SubItems(1)
        .Fields!Address = itemToAdd.SubItems(2)
        .Fields!Phone = itemToAdd.SubItems(3)
        .Update
    End With
Private Sub Command2_Click()
    With adoRecordSet
        .AddNew
        .Fields!Name = itemToAdd.SubItems(1)
        .Fields!Address = itemToAdd.SubItems(2)
        .Fields!Phone = itemToAdd.SubItems(3)
        .Update
    End With

...but this only saves the first row.... i want to save all the rows at the same time with just one click of the command button..... Hope someone could help me..... Thanks.... Maraming Salamat :mrgreen: