Hi,

When I bind a DataTable to DataView, I can sort it, etc. When I delete or update a row in DataView it gets deleted or updated as well in its bound DataTable. Then why instead of adding sorting methods to DataTable object , Microsoft has choosen to create a DataView object?

Thanks in advance.

DataViews correspond to the views in the database and the DataTable corresponds to the tables in the Database. The view can be derived from a DataTable and helps to have a different representation of the table.

Regards
Ganesh

Ganesh,

That is incorrect. DataView has nothing to do with what database "views" like in MSSQL. I think the intent is that a DataView is a "view" of the data in the source DataTable. The DataView of a DataTable provides the sorting and filtering capabilities for the underlying data that lives in the DataTable.

Sorry Peter for the wrong post.

I was taking about the similarity of usage of these two objects. the dataViews can be sorted representation of the DataTable. Correct me if I am wrong.

Regards
Ganesh

Ganesh,

Yes, you're correct.

A DataTable is like a database table and a DataView is like a database view. So they are functionally the same in that the DataTable holds the actual data while the DataView provides a filtered and/or sorted view of that data.

I have a similar question. I have some data returned from a database in a DataSet. I want to sort the data in the dataview, but don't see the data being sorted after I call the sort method on the dataview. The data is sorted is the DataGrid OK, but how do I access the rows in the dataview to see the data has been sorted? Here is my code. Thank you.

DataSet ds = new DataSet();
ds = GetProceedings(currentUser, ddlTime, ddlRoom, strJudge);
if (ds != null)
    {
    DataView dvSearchResults = ds.Tables[0].DefaultView;
    DataRow row = dvSearchResults.Table.Rows[0];
    string test = row["PersonName"].ToString();

    dvSearchResults.Sort = "CaseNumber ASC";
    row = dvSearchResults.Table.Rows[0];
    test = row["PersonName"].ToString();

pbyrum-

When you call "<dataview>.Table.Rows[n]" you are calling row n of the original source table for the dataview, not the row of the view itself.

The Dataview class has an indexer which returns a DataRowView object for the row of the data view. So you should be able to do this:

DataRowView row = dvSearchResults[0];