Multiple search criteria datagrid

[Bigfoot]

Hi,

I have a webform with a datagrid, 2 textboxes and a button. The datagrid is
filled by a sql database.

What I want is: to search the database based on the values of the 2
textboxes. I think I have to combine the values somehow into 1 sql query,
but I don't know how. The results wil be displayed in the datagrid.

So I want is a search within a search but I don't know how to do this.

Thanx in advance!

Stefan

 

[Alvin Bruney [MVP]]

not sure what you are asking. the textboxes will form the where clause of
the query
select * from blah where item = textbox1.text and item2 = textbox2.text

if you have all the data in the grid, you should just filter the dataset but
the textbox criteria to prevent unnecessary load on the database. have a
look at the datatable. select function