Working, sorta...drop down list

  • Thread starter Thread starter zamdrist
  • Start date Start date
Z

zamdrist

I have an ASPX codebehind webform with two drop down lists. The first
code below gets data and populates the ddl. The second (ddlGroups)
fails and I cannot figure out why. I checked the permissions of the
stored procedure, even ran it via query analyzer.

Although I haven't figured out how to turn debugging on, by process of
elimination I believe it's the line .DataSource=...in the second With,
End With that appears to be failing with a runtime error. The first
works splendidly.

Any thoughts, ideas? Thanks...

Dim adoComm_Attorney As New
SqlCommand("sp_UTL_MGProlawContacts_GetAttorneyCategories", adoConn)

With ddlAttorney
.DataSource = adoComm_Attorney.ExecuteReader()
.DataTextField = "Category"
.DataValueField = "Category"
.DataValueField = "Category"
.DataBind()
End With


Dim adoComm_Groups As New
SqlCommand("sp_UTL_MGProlawContacts_GetGroups", adoConn)

With ddlGroups
.DataSource = adoComm_Groups.ExecuteReader()
.DataTextField = "CategoryGroup"
.DataValueField = "CategoryGroup"
.DataBind()
End With
 
Close the first reader before the second ExecuteReader,
since you are executing both the readers on the same connection.

In the future, remember it's easier to answer a question if you provide
the actual error message instead of a generic "appears to be failing
with a runtime error"

hope this helps
 
Like this?

adoComm_Attorney.ExecuteReader.Close()

Unfortunately, because debugging isn't configured correctly via ASP.Net
& the web server, all I do get is 'runtime error' and no real
explanation of what the actual error is. I wish I could give you more
info, but I've never been able to get asp.net debugging to work.

Closing the reader as I did above unfortunately only returns runtime
error...again :(

Thanks...
 
I figured out, I needed to define a SQLDataReader variable.

..
..
..
Dim GroupReader As SqlDataReader
GroupReader = adoComm_Groups.ExecuteReader
..
..
..
GroupReader.Close()

Thanks for pointing me in the right direction!
 
I figured out, I needed to define a SQLDataReader variable.

.
.
.
Dim GroupReader As SqlDataReader
GroupReader = adoComm_Groups.ExecuteReader
.
.
.
GroupReader.Close()

Thanks for pointing me in the right direction!
Click to expand...

Yay, now that it works...let's work on another one of your
problems...getting ASP.Net Debugging to work :)

When you try to start with debugging, do you get an error? If so, open the
MSDN library and enter this in the address bar for it:

ms-help://MS.MSDNQTR.2003FEB.1033/vsdebug/html/vxtbsHTTPServerErrors.htm

This has several solutions to some common problems with setting up ASP.Net
debugging :)

If you still have trouble, let us know :)

Mythran
 
Back
Top