Query based on a text box value..

5 Apr 2006 7:08 AM

rj

Hi All,

How do I query based on a value in a text box?

eg:
"select username, tel, email from users where user_id = userid.text"

something like that..

thanx in advance..

5 Apr 2006 7:14 AM

pavankumar

hi this is pavan.,

         I am using installshield11 version for packaging vb app which
is using crystal reports 10 version.

        After creating package when i try to install in client system
total application is installing properly but when i try to open repots
it showing that TLV error....

       please suggest ur answer...............

5 Apr 2006 7:52 AM

dev.amit

Your Query is fine but u wnat to do this by using what method is
important.
Describe ur question in detail.
Specify that also then only anyone can help u.

Love
Amit
http;//insidetungi.blotsopt.com
http://tungiprogramming.blogsopt.com

5 Apr 2006 10:02 AM

rj

is it possible for me to specify it in the data adapter wizard?
if not how else could i do it?

5 Apr 2006 8:17 AM

Aziz

Where is your information stored? If it is a DataBase you will need to
create a Primary Key in the XML Designer. Then you can find a field
relating to a specified Primary Key.

If you use a typed DataSet you can do something like this:

dsDataset.Customer.FindByUserID(userid.text).UserName.ToString
dsDataset.Customer.FindByUserID(userid.text).UserEmail.ToString
dsDataset.Customer.FindByUserID(userid.text).UserPhone.ToString