Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 12-06-2009
Member
 
Join Date: Jun 2009
Posts: 1
VB6 - Query against Textbox/Datagrid(ADO)

Hey guys(gals),

VB6 - using ADO
MySQL - database

I am writing a program in VB6 and I have a form with a datagrid (which I am populating with data from a MySQL table) that is bound to textboxes on my form. For example I have 'First Name', 'Last Name' and 'Middle Name' as columns in the datagrid and textboxes.

What I want to do is be able to query in those textboxes or in the datagrid itself. For example if I want to find everyone in the 'Last Name' column where their last name starts with D then I want to be able to put D* in the textbox or column in datagrid and hit enter and have all those records show up.

Is this possible?

Thanks,
ProgrammerMike
Reply With Quote
  #2  
Old 13-06-2009
Member
 
Join Date: May 2008
Posts: 23
Re: VB6 - Query against Textbox/Datagrid(ADO)

Hey ProgrammerMike,

Its good to see you on TechArena,

First what you want to do is not clear.
If you want to search your database & fetch result then you can query your table & fetch result for Surname or Username etc whatever you want. Make sure to place a new textbox to enter the value & fetch the result on Search button.
I hope this helps.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "VB6 - Query against Textbox/Datagrid(ADO)"
Thread Thread Starter Forum Replies Last Post
Excel/VBA: Copying text from UserForm Textbox to a Worksheet Textbox Neil Ives Software Development 2 20-08-2010 01:23 AM
Want to make query dependent on another query. MACE Software Development 4 01-02-2010 05:22 PM
How to create a query on datagrid view in vb.net Ainsley Software Development 3 10-12-2009 09:59 PM
How to print web datagrid in VB.NET spuff Windows Software 3 31-07-2009 11:33 AM
Turn on MySQL query cache to speed up query performance DMA2Superman Software Development 3 07-07-2009 10:26 AM


All times are GMT +5.5. The time now is 03:51 AM.