changing where clause in datagridview

9 Jan 2006 8:20 PM

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.

9 Jan 2006 10:36 PM

I Don't Like Spam

The Other Mike wrote:

> 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

10 Jan 2006 1:16 PM

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.

Show quoteHide quote

"I Don't Like Spam" <no@spam.com> wrote in message
news:%23vN3M0WFGHA.3100@tk2msftngp13.phx.gbl...
> The Other Mike wrote:
>> 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