Asp.net Datasource - view sql data by lookin at datasource object?

Question

Is there a way to view data that is returned from db by looking at DataSource or DataSourceView object in codebehind? I'm trying to view DataSourceView in debug but I don't see the data returned.

Answer 1

DataView dv = (DataView) YourDataSourceObject.Select(DataSourceSelectArguments.Empty);
for (int i = 0; i < dv.Table.Rows.Count; i++)
{
    string c = dv.Table.Rows[i]["c"].ToString();
}