DataView Row Filter isn't working

[Kim]

I need to filter this datatable but when I do it gives me all the data
not filter not sure what Im doing wrong.
DataView dv = new DataView();
dv.RowFilter = "ClientID = " + clientid;
gridControl1.Da taSource = dv;

I also tried adding this but it didn't work either:
dv.RowStateFilt er = DataViewRowStat e.ModifiedCurre nt;

when I added the Row State Filter after the Row Filter no records was
return.
Any help will be greatly appreciated.
Thanks
Kim

[Yunus Emre ALPÖZEN [MCAD.NET]]

What about datatable? where is it? My advice u to use DefaultView property
of datatable

--

Thanks,
Yunus Emre ALPÖZEN
BSc, MCAD.NET

"Kim" <gi***@aol.co m> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

I need to filter this datatable but when I do it gives me all the data
not filter not sure what Im doing wrong.
DataView dv = new DataView();
dv.RowFilter = "ClientID = " + clientid;
gridControl1.Da taSource = dv;

I also tried adding this but it didn't work either:
dv.RowStateFilt er = DataViewRowStat e.ModifiedCurre nt;

when I added the Row State Filter after the Row Filter no records was
return.
Any help will be greatly appreciated.
Thanks
Kim

[joelcochran]

I modified this for you from some working production code:

<code>
DataView dv = new DataView( %DATATABLE% , %FILTER_STRING% ,
%ORDER_BY_STRIN G% , DataViewRowStat e.CurrentRows );
gridControl1.Se tDataBinding( this.currentVie w , null );
</code>

Replace the %...% markers above with your variabIes and use the
SetDataBinding method instead of just setting the DataSource property.
Works great for me...

HTH,
Joel

[Maqsood Ahmed]

Hello,
Have you tried putting single quotes around clientID?

something like
dv.RowFilter = "ClientID = '" + clientID + "'";??

Trying using it, it should help.

Maqsood Ahmed [MCP,C#]
Kolachi Advanced Technologies
http://www.kolachi.net

*** Sent via Developersdex http://www.developersdex.com ***