[RESOLVED] DataTable Filtering

[RobDog888]

Ok so have looked into the DataView and read that its not going to do what I want as I already have a DT populated but have a situation where I now need to filter it with a DISTINCT query and WHERE clause so using a dataview wont work. I dont want to requery the db just for this since its already in memory.

Ideas?

Thanks

[RobDog888]

Looking at copying the datatable and doing a .DefaultView.ToTable(true, "chID").DefaultView.RowFilter = "chGrp = 'C'" but its giving an error that it cant find the column but it does exist in the dt.

DataTable dt = dsSTDDB.Tables["StandardCHP"].Copy();
DataView dv = dt.DefaultView.ToTable(true, "chID").DefaultView;
dv.RowFilter = "chGrp='C'";

Hmm ok well seems the distinct only pulls in the one field.

[techgnome]

?? What distinct? I don't see where you used distinct. Unless it was in the original SQL.

-tg

[RobDog888]

The "true" parameter is the distinct identifier in teh parameters

DataView dv = dt.DefaultView.ToTable(true, "chID").DefaultView;

I guess I could add the second column in hte list as I think it should still be distinct

[RobDog888]

Got it with this.

DataTable dt = dsSTDDB.Tables["StandardCHP"].Copy();
DataView dv = dt.DefaultView.ToTable(true, "chID", "chGrp").DefaultView;
dv.RowFilter = "chGrp='C'";

[techgnome]

Ahhh... didn't realize the .ToTable worked like that.

-tg