Hi

I have used filter and sort option in a datatable's default view. I need the new data (with sorting and filtering) from the defaultview. I have tried the below code(bold letters). but its not working. I got the old data only.

Datatable dt,dtnew;
DataView dv
daAdapter.Fill(dt)
dt.DefaultView.Sort = "F1 ASC,F2 ASC,F3 ASC";
dt.DefaultView.RowFilter = "F1 <> 'Country'";


dtnew = dt.DefaultView.Table;


Thanks in advance

Hi

Try this

dtnew = dt.DefaultView.ToTable();

__________________
The OXYGEN
Delivers edgy, intelligent Technology to all...

Even i have tried a lot by writing a seperate function to convert view to table, but it really helps.. thanks....

__________________
$enthil