Hi, i have a typed view that returns the list of all active students with about 10 fields. using this typed view, i would like to create a data table and add 1 more field to it. this new field will hold the status of the student which is not returned by the view.

any suggestions what would be the best way to accomplish this?

it will be like: use all fields from the typed view add new field and set its value for each record view returns.

thank you -shane

As a matter of fact a TypedView is a DataTable. This is an approximate code:

DataTable nwDataTable =  myFetchedTypedView.DefaultView.ToTable();
nwDataTable.Columns.Add("Status");
foreach (DataRow r in nwDataTable.Rows)
{
      r["Status"] = something...;               
}

daelmo wrote:

As a matter of fact a TypedView is a DataTable. This is an approximate code:

DataTable nwDataTable =  myFetchedTypedView.DefaultView.ToTable();
nwDataTable.Columns.Add("Status");
foreach (DataRow r in nwDataTable.Rows)
{
      r["Status"] = something...;               
}

thank you that will work