cant redirecting page

Question

1.00/5 (1 vote)

See more:

i have created login page when we pass the value to it doesnt redirect to home page
it doent generates any error while executing .... i m using vb .
i dont knw what going wrong wid my code..
plz help me..
thanks in advance..

here is my code for login page . it is on login button click event.

VB

Dim cn As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Welcome\Documents\Visual Studio 2010\Projects\fc\App_Data\fc.mdf;Integrated Security=True;User Instance=True")
        Dim str As String
        str = "select count(*) from r_user where eml='" & eml_txt.Text & "' and pwd='" & pwd_txt.Text & "'"

        Dim cmd As New SqlCommand(str, cn)
        cn.Open()
        cmd.ExecuteScalar()
        Session("eml") = eml_txt.Text
        If (eml_txt.Text = "admin" And pwd_txt.Text = "admin") Then
            Response.Redirect("admin.aspx")
        Else
            str = "select * from r_user where eml='" & Session("eml") & "'"

            Dim da As New SqlDataAdapter(str, cn)
            Dim dt As New DataTable
            Dim s = da.Fill(dt)

            If (s < 1) Then
                Response.Redirect("profile.aspx")
            Else

                Response.Redirect("login.aspx")
            End If

            cn.Close()

        End If

Posted 4-Mar-13 23:47pm

mahi0607

Updated 4-Mar-13 23:58pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v3

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 5-Mar-13 6:04am

There may be two problems here.

1. The conditions mentioned in if statements are not satisfied.

2. The path of page is not correct. I mean For example -

Response.Redirect("admin.aspx")

here "admin.aspx" should be at the same directory and folder as of this code file. Otherwise it can't load that page.

Please make sure point 1 is working fine by debugging line by line and point 2 by checking the paths of pages you want to redirect.

mahi0607 5-Mar-13 6:17am

it doesnt satisfy the if conditon... it retrive 0 while debuging .. can u help me out for this?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 5-Mar-13 6:46am

Do u mean the below condition ?

If (s < 1) Then

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 5-Mar-13 6:59am

You can do like below...

If (dt.Rows.Count < 1) Then

Try and let me know.

mahi0607 6-Mar-13 11:42am

not working... still redirecting on login page and password textbox were blank..

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 7-Mar-13 1:15am

Ok, let me understand what exactly you wanted to do ?

Dim s = da.Fill(dt)

That means if you get data from database, then you will redirect it to the "profile.aspx" page, right ?

But if that is the case, then it should be like...

If (s > 1) Then

not less than 1...

And you should try like...

If (dt.Rows.Count > 1) Then

Or else, let me understand the logic, which you want to execute.

And also check what is the value of "dt.Rows.Count" coming while debugging.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

dpalash · Answer 1 · 2013-03-06T04:28:00

Solution 1

Try this, This may help

HttpContext.Current.Response.Redirect("login.aspx", false);

Posted 6-Mar-13 4:28am

dpalash

jkirkerx · Answer 2 · 2013-03-06T12:45:00

cmd.ExecuteScalar()

That's for updating a database table without asking for any information back

You have to create a reader object, that will read the response back, and feed your command object into the reader.

myConnection.Open()
Dim myReader As SqlDataReader = myCommand.ExecuteReader()
Dim FieldCount As Integer = myReader.FieldCount
While myReader.Read()
  m_count = myReader.GetString(0)
End While

if (m_Count > 0) then
  httpcontext.current.response.redirect("home.aspx")  
end if