Hi Kevin
I understand how to create views but I am still wondering whehter this the best way to mimic the "Use Again" functionality of VFP?
Secondly, if data is changed in dv1 will those changes be reflect in dv2 or these trested as completely separate objects?
Thanks
Simon
>Hi, Simon,
>
>Excellent question...you can create multiple views of the same datatable, by doing something like the following:
>
>
>DataView dv1 = new DataView(MyDataSet.Tables["MyTableName"]);
>dv1.Sort = " column1 ";
>dv1.RowFilter = " column2 > 100 ";
>
>DataView dv2 = new DataView(MyDataSet.Tables["MyTableName"]);
>dv2.Sort = " column4 ";
>dv2.RowFilter = " column6 > 50 ";
>
>
>Keep in mind that there is no 'record pointer' in ADO.NET - though there is the binding manager position if you've bound a control (like a grid) to a particular dataview.
>
>Let me know if that helps, or if you need more...
>
>Kevin
Simon White
dCipher Computing