Trimming spaces with calendar picker to send to sql statement

I have a Calendar PIcker that we choose a date from and send that out as a parameter to a sql statement. I have created my page in the visual studio designer and what I want to do is send is

RTrim(Calendar1.SelectedDate.ToShortDateString). My problem is since this was created in designer the code is all hidden. I can't place the RTrim() anywhere to accomplish this. Or maybe this whole process needs to be hard coded. It seems to me in VS 2003 you would see all the code thru expanding regions.

Thanks

Hey,

It should be there in the regions; I don't know how you are doing this; if you place it as an expression in the page, it could be in the page HTML. But how are you doing this? I need a little more info...

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.

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.ToSt ring()) 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.comwrote in message
news:1161382144.231799.326450@.b28g2000cwb.googlegr oups.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.ToSt ring()) but that just
what I set originally.

Thanks.