changing where clause in datagridview

[The Other Mike]

VS 2005

Is their a way to dynamically change the where clause in a datagridview or
dataset?

I have a search window where the user can enter a part number or description
or customer etc... and would like to change the where clause based on what
the user has filled out.

 

[Guest]

VS 2005

Is their a way to dynamically change the where clause in a datagridview or
dataset?

I have a search window where the user can enter a part number or description
or customer etc... and would like to change the where clause based on what
the user has filled out.

Are you trying to go back to the server to get new data or just trying
to filter the datagridview down from the full dataset?

Chris

 

[The Other Mike]

Going back to the server to get new data. When the user first opens the
window, there will be no data. They will enter in search criteria. I will
then build the where clause and get the data from the server.