Ponyboy99
asked on
Response.Redirect doesn't work in any processing is done on aspx page
Hi,
Recently, I have been experiencing sparadic problems with Response.Redirect in aspx pages. I created a new web project using vb.net and setup my image buttons for redirection and they work fine. However, when I load some dropdownlist controls when the pages loads for the first time, and click the image button, I get the error "The page cannot be displayed". I comment out the subs that load the dropdowns and viola, the page redirects. I'm connecting to SQL Server 2K with the sqlclient object.
Is this happening to anyone else and how do I fix it? This happened a few weeks ago also, but mysteriously quit. If anyone can help or give me some direction on this, it is appreciated greatly!
Thanks!
Recently, I have been experiencing sparadic problems with Response.Redirect in aspx pages. I created a new web project using vb.net and setup my image buttons for redirection and they work fine. However, when I load some dropdownlist controls when the pages loads for the first time, and click the image button, I get the error "The page cannot be displayed". I comment out the subs that load the dropdowns and viola, the page redirects. I'm connecting to SQL Server 2K with the sqlclient object.
Is this happening to anyone else and how do I fix it? This happened a few weeks ago also, but mysteriously quit. If anyone can help or give me some direction on this, it is appreciated greatly!
Thanks!
since you're doing the response.redirect when the page posts back, there are a couple things we can look at. Your best bet is to post the code and we can take a look and probably give you an answer very quickly.
Hai,
Try encapsulating all code in the Function:
Private Sub Page_Load(
.....
with:
If Not Page.IsPostBack Then
.....
End if
Bye
Ajai
Try encapsulating all code in the Function:
Private Sub Page_Load(
.....
with:
If Not Page.IsPostBack Then
.....
End if
Bye
Ajai
ASKER
The procedure calls to load the data are in a "If Not IsPostBack" statement in the Page_Load event as follows:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not IsPostBack Then
LoadProviderNames()
LoadProviderSSNs()
LoadProviderTINs()
End If
End Sub
These load 3 respective dropdown lists using System.Data.SQLClient methods to a SQL Server 2000 database:
(all three procedures are identical, substituting the ddlProviderName.* with ddlProviderSSN.* and ddlProviderTIN.* and the called views as SSNLookupProv and TINLookupProv)
Dim sConnection As String = GetConnectionString(giConn TypeNP, Server.MapPath(gsConnFileP ath))
Dim conn As New SqlConnection(sConnection)
Dim cmd As SqlCommand
Dim myReader As SqlDataReader
Dim sSQL As String = ""
Try
conn.Open()
'fill the providername ddl
sSQL = "Select Name from NameLookUp"
cmd = New SqlCommand(sSQL, conn)
myReader = cmd.ExecuteReader
If myReader.HasRows Then
ddlProviderName.Items.Clea r()
ddlProviderName.Items.Add( " ")
Do While myReader.Read
ddlProviderName.Items.Add( myReader.G etValue(0) )
Loop
End If
cmd.Dispose()
cmd = Nothing
myReader.Close()
myReader = Nothing
conn.Close()
If conn.State <> ConnectionState.Closed Then
conn.Close()
conn.Dispose()
conn = Nothing
End If
Catch ex As Exception
If conn.State <> ConnectionState.Closed Then
conn.Close()
conn.Dispose()
conn = Nothing
End If
Session("Exception") = CleanException(ex.Message. ToString)
Response.Redirect("errorpa ge.aspx")
End Try
And the page loads fine, however when you click on the image button control ibtn0, no work is done and the get the "Page cannot be displayed" http error page is displayed. It will not even hit a breakpoint in the ibtn0_Click event unless I use a simple html <A href> link instead of a button control. Note that ALL other button events work as expected everywhere else in the program and on this page, unless any processing is done as shown in the procedure above. One procedure call and everything is fine, more than one procedure call and nothing. Currently, these are the only 4 procedures addressed on this aspx page of the program.
This is the ibtn0 event:
Private Sub ibtn0_Click(ByVal sender As System.Object, ByVal e As System.Web.UI.ImageClickEv entArgs) Handles ibtn0.Click
Response.Redirect("Provide rEdit.aspx ")
End Sub
Like I said, I had this occur a few weeks ago, but it mysteriously went away & I never had another problem till now. I am at a total loss to explain or fix it and have found no reference to this type of problem. Any help is greatly appreciated.
Thanks!
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not IsPostBack Then
LoadProviderNames()
LoadProviderSSNs()
LoadProviderTINs()
End If
End Sub
These load 3 respective dropdown lists using System.Data.SQLClient methods to a SQL Server 2000 database:
(all three procedures are identical, substituting the ddlProviderName.* with ddlProviderSSN.* and ddlProviderTIN.* and the called views as SSNLookupProv and TINLookupProv)
Dim sConnection As String = GetConnectionString(giConn
Dim conn As New SqlConnection(sConnection)
Dim cmd As SqlCommand
Dim myReader As SqlDataReader
Dim sSQL As String = ""
Try
conn.Open()
'fill the providername ddl
sSQL = "Select Name from NameLookUp"
cmd = New SqlCommand(sSQL, conn)
myReader = cmd.ExecuteReader
If myReader.HasRows Then
ddlProviderName.Items.Clea
ddlProviderName.Items.Add(
Do While myReader.Read
ddlProviderName.Items.Add(
Loop
End If
cmd.Dispose()
cmd = Nothing
myReader.Close()
myReader = Nothing
conn.Close()
If conn.State <> ConnectionState.Closed Then
conn.Close()
conn.Dispose()
conn = Nothing
End If
Catch ex As Exception
If conn.State <> ConnectionState.Closed Then
conn.Close()
conn.Dispose()
conn = Nothing
End If
Session("Exception") = CleanException(ex.Message.
Response.Redirect("errorpa
End Try
And the page loads fine, however when you click on the image button control ibtn0, no work is done and the get the "Page cannot be displayed" http error page is displayed. It will not even hit a breakpoint in the ibtn0_Click event unless I use a simple html <A href> link instead of a button control. Note that ALL other button events work as expected everywhere else in the program and on this page, unless any processing is done as shown in the procedure above. One procedure call and everything is fine, more than one procedure call and nothing. Currently, these are the only 4 procedures addressed on this aspx page of the program.
This is the ibtn0 event:
Private Sub ibtn0_Click(ByVal sender As System.Object, ByVal e As System.Web.UI.ImageClickEv
Response.Redirect("Provide
End Sub
Like I said, I had this occur a few weeks ago, but it mysteriously went away & I never had another problem till now. I am at a total loss to explain or fix it and have found no reference to this type of problem. Any help is greatly appreciated.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This didn't help, but the standard .net button controls work correctly. I've been through IIS and verified security permissions on the folders and they are correct. I'm to the point of starting a new project & redoing the code from scratch just to see if there is something I inadvertantly screwed up. Thanks.