Hello,

I am using a DataView that has 100 records in it. I am also sorting the DataView with sort method. This DataView is also displayed in a DataGrid on a web page. The DataView displays the data sorted in the DataGrid, so that is working OK. However, the problem is that when I get a field value from a row from this DataView, the data is not sorted. Row 0 always has the same value. Basically, I want to select a row in DataGrid and get other data from the DataView. Currently, the DataView rows do not match what is shown in the DataGrid, becuase the DataView is not sorted, but the datagrid is. I am using MS Visual C# .Net.

Here is some of my code:

DataView dvSearchResults = (DataView) Session[_ViewStateCalSearchResults];

DataRow rowCase = dvSearchResults.Table.Rows[0];
string test = rowCase["PersonName"].ToString();

dvSearchResults.Sort = strNewSortExpr + " " + strSortDir;

rowCase = dvSearchResults.Table.Rows[0];
string test2 = rowCase["PersonName"].ToString();

Thanks,

Paul

It looks like you are accessing row[0] of the table the view is based on. You need to just use dataview[0] instead of dataview.table.rows[0]

Thanks for your input. I have been reading that I should be using the default view, which can be sorted. Tables can not be sorted and its difficult to change the order of them. I wrote a little VB app where the sort method works on the default DataView.

Dim dvCases as DataView
Dim dtCaseData As New DataTable
dvCases = dtCaseData.DefaultView
dvCases.Sort = "name ASC"

Anybody know how to rewrite this in C#?

This is the code that I have now, but this is still not sorting.

DataSet dsSearchResults = GetProceedings(dtSelectedDate, ddlTime.SelectedValue.Trim(), ddlRoom.SelectedValue.ToString(), strJudge);

DataView dvSearchResults = dsSearchResults.Tables[0].DefaultView;
DataRow rowCase = dvSearchResults.Table.Rows[0];
dvSearchResults.Sort = "PersonName ASC";

Any help would be much appreciated on why the sort method is not sorting.

Thank you,

Paul