How to search and fill dataset

[ldavis]

sorry kind of a newb here lol, i am trying to figure out how to search the database and only return the information under a spefic query

Example of query in my oledataadapter as it is now.

SELECT [Key], Domain, Company, Name, Email, Phone, Fax, Address, Address1, City, State, Zip, Rep#, Notes, [Email Info], [Postal Info], [Last Contact], [Is Customer], [Hosting Co], [Entry By] FROM Calllog WHERE ([Is Customer] = 'no' AND Domain = '" & Textbox26.text & "')


and for some reason that doesnt work any help is appreciated.

 

[TechGnome]

Take a look at the ADO.NET tutorials in my sig.... they'll walk you through setting it up and even does a search.

-tg

 

[ldavis]

thanks man that did it