Tuesday, March 13, 2012

troubleshooting markup SQLDataSource with a bunch of session variables?

I've got a page with Formview that has a sqldatasource doing a
compicated select with a bunch of session parameter variables set in a
calling page.
1. Is there anyway to response.write all session variables without
having to specify each one?
2. How can I see the actual SQL that is being passed to the Formview?
I've tried
response.write(ChargeDataSource.SelectCommand.ToString()) but that just
what I set originally.
Thanks.For (1):
foreach (string o in Session.Keys)
{
Response.Write (o + ": " + Session[o] + "<br/>");
}
"jobs" <jobs@.webdos.com> wrote in message
news:1161382144.231799.326450@.b28g2000cwb.googlegroups.com...
I've got a page with Formview that has a sqldatasource doing a
compicated select with a bunch of session parameter variables set in a
calling page.
1. Is there anyway to response.write all session variables without
having to specify each one?
2. How can I see the actual SQL that is being passed to the Formview?
I've tried
response.write(ChargeDataSource.SelectCommand.ToString()) but that just
what I set originally.
Thanks.

0 comments:

Post a Comment