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.

Might want to put some example code up.

madcolor
– madcolor

2009-04-29 15:48:27 +00:00
Commented Apr 29, 2009 at 15:48 — madcolor
– madcolor, Commented Apr 29, 2009 at 15:48

TheTXI · Accepted Answer · 2009-04-29 15:48:58Z

3

Use your datasource to fill a datatable or dataset and you can loop through the records and columns, but if you are looking for something which is going to give you a point-blank representation of the sql results, your best option would be binding it to a datatable.

answered Apr 29, 2009 at 15:48

TheTXI

38k10 gold badges89 silver badges110 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

dev.e.loper Over a year ago

so there doesn't seam to be a way to see data by looking just at datasource object?

TheTXI Over a year ago

I am not certain, but I think in newer versions of visual studio there was a way to see a table-view of data returned when you are debugging and set a breakpoint in the program and you highlight over a datatable/datasource, but this is just from my foggy memory.

Alper · Accepted Answer · 2009-04-29 16:54:41Z

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();
}

answered Apr 29, 2009 at 16:54

Alper

1,40314 silver badges16 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related