Mouseover "OrderIDDropDownList.SelectedValue" in the code to see what it is. I'm wondering if the value you are providing the query is the problem.

-Peter
peterlanoie.blog

When I put the mouse over OrderIDDropDownList.SelectedValue I get the following text in the tooltip: "DropDownList administration_orderallocation.aspxOrderIDDropDown List".

I probably should have clarified that you need to do this while you are debugging. And make sure you hover over "SelectedValue" to see that value, not just the DDL instance tooltip.

-Peter
peterlanoie.blog

Right I have just debugged it and set the breakpoint and when I select 2 on the drop down list and click the button, then highlight "OrderIDDropDownList.SelectedValue" on the SelectedValue I get 2.

This thread is starting to get confusing and a bit vague. Can you reproduce the error and post all the exception information you can gather? I'm loosing site of what and where the problem actually is.

-Peter
peterlanoie.blog

Sorry for the confusion. It's even starting to really confuse me. When you say gather all the exception information, do you mean from the output window?

Wherever you can get it. If your application is throwing an exception that isn't being gracefully handled then you should be getting the "yellow screen of death" with lots of information about the error. The message includes the line of code it's blowing up on as well as the method call stack information. This is most helpful in tracking down the source of the problem. It's hard to diagnose with just the exception message text.

-Peter
peterlanoie.blog

Right after searching the internet on how to get the call stack up on the debugger (Ctrl-Alt-C) I added a break point and debugged the file. I only got one entry on the call stack:

> App_Web_a0v2xyfc.dll!ASP.administration_orderalloc ation_aspx.ViewDestinationBtn_Click(object sender = {Text = "View Destinations"}, System.EventArgs e = {System.EventArgs}) Line 45 C#

With this problem I have never had a yellow screen of death. And what confuses me even more is that I have code in another file which does nearly the same thing but to a different table and yet that works.

I don't know how to get more information. But if I do I'll post it on here.

Now we are getting somewhere though... what is line 45?

One fundamental problem here is that you are "swallowing" the exception. You have a catch with no body. You should let the exception bubble out. Then you'll see all the crash information that will help us figure out the problem. Once you have things working, you can add in the try/catch block so you can handle the error gracefully. Alternatively, you could just use a try/finally block. This will ensure the connection(s) are closed, but allow the exception to bubble up so you'll see it. It's never a good idea to swallow exceptions unless you really really mean to.

-Peter
peterlanoie.blog

Line 45 is the "catch" line. Okay, I'll remove the try and catch blocks and come back with some progress.

Many thanks.