943,946 Members | Top Members by Rank

Ad:
Feb 9th, 2007
0

ListView Help..

Expand Post »
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....

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
  1.  
  2. With adorecordset
  3. .Fields!Name = Text1.Text
  4. .Fields!Address = Text2.Text
  5. .Fields!Phone = Text3.Text
  6. 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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
bad_robot is offline Offline
2 posts
since Sep 2005
Feb 10th, 2007
0

Re: ListView Help..

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

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
  1. Private Sub Command2_Click()
  2. With adoRecordSet
  3. .AddNew
  4. .Fields!Name = itemToAdd.SubItems(1)
  5. .Fields!Address = itemToAdd.SubItems(2)
  6. .Fields!Phone = itemToAdd.SubItems(3)
  7. .Update
  8. 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:
Reputation Points: 10
Solved Threads: 0
Newbie Poster
bad_robot is offline Offline
2 posts
since Sep 2005

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Help Please, how do i read from text file into array?
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Please help me in making code for browsing button





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC