hey,

how can i deactivate my filter in the datagrid?
how can i change it back to see all data?

thanks again!

[Edited by blacklisted on 01-10-2006 at 11:08 AM GMT]

By setting the datagrid's recordset filter on an empty string, with
   DataGrid1.Filter = ""
or
    Adodc1.Recordset.Filter = ""

Hope it helps.


[Edited by yronium on 01-10-2006 at 04:01 PM GMT]

____________________________
Real Programmer can count up to 1024 on his fingers

hi,
the code doesnt work. my datagrid displays empty data.

What code are you using to set the filter on? If you have set the Filter property of whatever to an SQL criteria, you have to set the same Filter property to an empty string in order to remove the filter. This method works either if you linked the datagrid on a recordset, or if you linked it on an ADODC control, or else: wherever you have set before the Filter property you have to put an empty string, with something like:
    (...whatever you used...).Filter = "".

Hope it helps, otherwise, post the code you use to link the datagrid.

[Edited by yronium on 01-10-2006 at 06:36 PM GMT]

____________________________
Real Programmer can count up to 1024 on his fingers

here is what i did

Adodc2.Recordset.Filter = "title like '" & Combo2.Text & "*'"

the datagrid is connected to adodc

i put the

Adodc2.Recordset.Filter = ""

code to a command button so if i click it it will show again all the data.

is there something wrong with my coding?

quote:

---

is there something wrong with my coding?

---

OK, try one of the following two:

' (the next two lines would mean the same)     Adodc2.Recordset.Filter = adFilterNone     Adodc2.Recordset.Filter = 0

And let me know.

____________________________
Real Programmer can count up to 1024 on his fingers