how to make login page in website?

Question

1.00/5 (1 vote)

See more:

VS2010

C#

protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(@"Data Source=ABHINAV-PC\ABHI;Initial Catalog=Onlineexam;Integrated Security=True");
        con.Open();
        string cmd = "select * from Login where Institute='"+DropDownList1.Text+"'And Username='"+TextBox2.Text+"' and Password='"+TextBox3.Text+"'";
        SqlDataAdapter da = new SqlDataAdapter(cmd, con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        if ((ds.Tables[0].Rows.Count > 0))
        {
            Response.Redirect("Exam.aspx");
        }
        else {
            lblloginError.Text = "Username or password must be wrong"; 
        }
        
        
    }

What i'm doing wrong in this?
its not redirecting to the exam page...it is directly showing the error text...please help!

Posted 12-Jul-14 18:45pm

Abhinav Chaudhary

Updated 12-Jul-14 18:59pm

Thanks7872

v2

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Jul-14 1:40am

What is that error?

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)

u mani · Accepted Answer · 2014-07-13T20:54:00

C#

 con.Open();
                SqlCommand cmd = new SqlCommand("select * from Login where Institute='"+DropDownList1.Text+"'And Username='"+TextBox2.Text+"' and Password='"+TextBox3.Text+"'", con);
                SqlDataReader dr = cmd.ExecuteReader();
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        Response.Redirect("Exam.aspx");


                    }
                }
 else {
            lblloginError.Text = "Username or password must be wrong"; 
        }
con.Close();

try like this it will work ;)

DamithSL · Accepted Answer · 2014-07-12T19:11:00

can't tell direct answer to your question with these information. you can find the solution by your self.
put break point just after below line and run the program

C#

string cmd = "select * from Login where Institute='"+DropDownList1.Text+"'And Username='"+TextBox2.Text+"' and Password='"+TextBox3.Text+"'";

check the value of cmd you get when you debug. do you have values you expect as institute, user name and password? if not you need to find why you not getting expected value.
if all these values are correct then you can copy the sql statement and run this directly on sql server management studio and confirm whether you have records for generated sql or not.
hope this helps you to find where is the issue and then you will able solve by user self or update the question with more specific details.

below are few side notes to improve your code:
1. use sql parameters[^]
2. dispose the connection with using block

how to make login page in website?

2 solutions

Solution 3

Solution 1

Add your solution here

Preview 0