473,324 Members | 2,179 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

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.

Oct 20 '06 #1
1 1152
For (1):
foreach (string o in Session.Keys)
{
Response.Write (o + ": " + Session[o] + "<br/>");
}

"jobs" <jo**@webdos.comwrote in message
news:11**********************@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.

Oct 21 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Ned Balzer | last post by:
I'm trying to create a formview bound to a sqldatasource, and use a stored procedure to insert data from the formview into several tables. I have some simplified code below, the real code is much...
0
by: | last post by:
I'm being driven nuts by what I'm sure is a simple solution, I have to pass some user and company id variables between 2 pages and on the second page use the params in a SQL query to list all items...
2
by: djc | last post by:
1) I am wondering if I should be using an sqlDataSource object for my particular scenario. I need to loop through a listbox and perform an INSERT sql operation for each item. Could be a few or...
1
by: John Kotuby | last post by:
Hello again... I have tried using the SQLDatsource control as part of a user control that just conatins a Repeater and the SQLDatasource control which is designated as the Datsource for the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.