Login code in ASP.NET

Question

3.00/5 (2 votes)

See more:

this is the code of login but it is not working can u please help me out...

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class sigin_in : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
   
    }
    SqlConnection con = new SqlConnection("Data Source=KRISHN-PC;Initial Catalog=sign;Persist Security Info=True;User ID=sa;Password=***********");
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlDataAdapter obj = new SqlDataAdapter("select from login where userid = '"+TextBox1.Text+"'and password = '"+TextBox2.Text +"'",con);
        DataSet a = new DataSet();
        obj.Fill(a);
        //obj.Update(a);
        if (a.Tables[0].Rows.Count > 0)
        {
            Response.Redirect("home.aspx");
        }
        else
        {
            Label.Text = " wrong pswd";
        }
    }

}

Posted 22-Jul-11 2:01am

krishn2011

Updated 22-Jul-11 12:24pm

thatraja

v2

Add a Solution

Comments

Herman<T>.Instance 22-Jul-11 8:16am

select from login where userid --> leads to error because no fields are defined

krishn2011 22-Jul-11 12:56pm

dear i have given the field = to "textbox1.text"

Herman<T>.Instance 22-Jul-11 16:58pm

sql is something like select [fieldname] from login where.....

8 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)

Herman<T>.Instance · Answer 1 · 2011-07-22T02:05:00

a SqlDataAdapter needs an Open() SqlConnection and after the data is in the dataset the SqlConnection needs to be Closed()

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
  
 public partial class sigin_in : System.Web.UI.Page
 {
	string connectToDB = "Data Source=KRISHN-PC;Initial Catalog=sign;Persist Security Info=True;User ID=sa;Password=***********";
	protected void Page_Load(object sender, EventArgs e)
	{

	}
 
	protected void Button1_Click(object sender, EventArgs e)
	{
		SqlConnection con = new SqlConnection(connectToDB);
		string myQuery = string.Format("select from login where userid = '{0}' and password = '{1}'", TextBox1.Text, TextBox2.Text);
		SqlDataAdapter obj = new SqlDataAdapter(myQuery, con);
		try
		{
			con.Open()
			DataSet a = new DataSet();
			obj.Fill(a);
			
			if (a.Tables[0].Rows.Count > 0)
			{
				Response.Redirect("home.aspx");
			}
			else
			{
				Label.Text = " wrong pswd";
			}
		}
		catch (Exception err)
		{
		}
		finally
		{
			if (null != con && con.Connection.State == ConnectionState.Open)
				con.Close();
		}
	 }
 }

Reiss · Answer 2 · 2011-07-22T03:12:00

Although this isn't a solution, I didn't want to add it as a plain comment, as I feel it is to important to go there.

Don't connect to any database using the sa account - also this account needs to be renamed to something else at least.

If you can't use integrated security then create a specific accounts for your database and make sure you grant the least amount of privaleges to each as possibly.

Have a google to learn more about securing your databases.

Shameel · Answer 3 · 2011-07-22T02:35:00

Solution 5

Call the SqlConnection's Open method before passing it on to the SqlDataAdapter's constructor. SqlDataAdapter requires an open connection. And also specify the Column names in your select statement.

Posted 22-Jul-11 2:35am

Shameel

web works · Answer 4 · 2011-07-22T03:23:00

Solution 7

Your SQL 'Select' statement does not provide any field name.

'Select from login where ........' is a invalid sql statement.

Posted 22-Jul-11 3:23am

web works

Comments

krishn2011 22-Jul-11 12:43pm

dear it is ....and this is right... Select * from login where userid = '"+TextBox1.Text+"'and password = '"+TextBox2.Text +"'",con

web works 11-Aug-11 13:13pm

i don't see * in your select statement

string myQuery = string.Format("select from login where userid = '{0}' and password = '{1}'", TextBox1.Text, TextBox2.Text);

code

krishn2011 · Answer 5 · 2011-07-22T06:49:00

hey friends this code is right ...this code works..thanks

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class sigin_in : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
   
    }
    SqlConnection con = new SqlConnection("Data Source=KRISHN-PC;Initial Catalog=sign;Persist Security Info=True;User ID=sa;Password=12345");
    protected void Button1_Click(object sender, EventArgs e)
    {
        //con.Open();
        SqlDataAdapter obj = new SqlDataAdapter("Select * from login where userid = '"+TextBox1.Text+"'and password = '"+TextBox2.Text +"'",con);
        DataSet a = new DataSet();
        obj.Fill(a);
        //con.Close();
        //obj.Update(a);
        if (a.Tables[0].Rows.Count > 0)
        {
            Response.Redirect("home.aspx");
        }
        else
        {
            Label.Text = " wrong pswd";
        }
    }

}

surajkumbhar · Answer 6 · 2011-07-22T02:05:00

Solution 2

Try removing the ***** in password field of connection string and type actual password......hope it will work.

Posted 22-Jul-11 2:05am

surajkumbhar

Comments

Herman<T>.Instance 22-Jul-11 8:14am

Something tells me he did not want to provide the password to us

uspatel · Answer 7 · 2011-07-22T02:08:00

You can use this code

SqlConnection con = new SqlConnection("Data Source=KRISHN-PC;Initial Catalog=sign;Persist Security Info=True;User ID=sa;Password=***********");
con.open();
string str=
SqlCommand cmd=new SqlCommand(select from login where userid = '"+TextBox1.Text+"'and password = '"+TextBox2.Text +"'",con);
SqlDataRaeder dr=cmd.ExecuteReader();
if(dr.Read())
{
Response.Redirect("home.aspx");
con.Close();
}
<else>
{
Label.Text = " wrong pswd"
con.Close();
}</else>

Tajuddin_HYD · Answer 8 · 2011-07-22T02:10:00

here u have to open the connection and give completed pwd instead of giving **

C++

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class sigin_in : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
SqlConnection con = new SqlConnection("Data Source=KRISHN-PC;Initial Catalog=sign;Persist Security Info=True;User ID=sa;Password=giveurpwd");
con.Open();----------->Open connection
protected void Button1_Click(object sender, EventArgs e)
{
SqlDataAdapter obj = new SqlDataAdapter("select from login where userid = '"+TextBox1.Text+"'and password = '"+TextBox2.Text +"'",con);
DataSet a = new DataSet();
obj.Fill(a);
//obj.Update(a);
if (a.Tables[0].Rows.Count > 0)
{
Response.Redirect("home.aspx");
}
else
{
Label.Text = " wrong pswd";
}
}

} .

Login code in ASP.NET

8 solutions

Solution 1

Solution 6

Solution 5

Solution 7

Solution 8

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0