What could be Simple solution ?

Hi,

In my project a webpage facilitates Search, I have the following controls used

1-TextBox for keywords

2-ComboBox for Search Type

3-Submit Button

User comes & type a keyword, select search field from combobox & press submit, I retrieve record from an Ms Access database.

Using that selection I genrate a query

example(select * from [TableName] where [FieldName]=[Keyword]

Which control can execute this query, because gridview ask for a select statement before running the program

If possible please help me with code

Thanks

[790 byte] By [YasirImran] at [2007-12-25]