How to Login Two Table Users in a single Button using asp.ne

Hi Every one,

Here Iam creating Two tables in sql server when student click the submit button check the user crendtials in first table and when admin click the check the Admin Credtinals .so here iam writing Code is perfectly working but i dont know how to insert the if statement . ....... any one let me where i do wrong in my code...

protected void BtnSubmit_Click(object sender, EventArgs e)

{

SqlConnection conn = new SqlConnection("Data Source=SERVER;Initial Catalog=MuraliIIT;User ID=sa;Password=rits@1234");

SqlCommand cmd = new SqlCommand("select COUNT(*)FROM NewStudentRegistrationForm WHERE UserName='" + TxtUserName.Text + "' and password='" + Txtpassword.Text + "' and ApproveStatus=1");

cmd.Connection = conn;

conn.Open();

int OBJ = Convert.ToInt32(cmd.ExecuteScalar());

if (OBJ > 0)

{

Session["UserName"] = TxtUserName.Text;

// Response.Write("password is correct");

TxtUserName.Text = "";

Response.Flush();

Response.Redirect("StudentLoginSuccessfully.aspx");

}

else

{

Response.Write("");

}

SqlConnection conn1 = new SqlConnection("Data Source=SERVER;Initial Catalog=MuraliIIT;User ID=sa;Password=rits@1234");

SqlCommand cmd1 = new SqlCommand("select COUNT(*)FROM Admin WHERE UserName='" + TxtUserName.Text + "' and password='" + Txtpassword.Text + "'");

cmd1.Connection = conn1;

conn1.Open();

int OBJ1 = Convert.ToInt32(cmd1.ExecuteScalar());

if (OBJ1 > 0)

{

Session["UserName"] = TxtUserName.Text;

// Response.Redirect("AdminAcceptstudents.aspx");

Response.Redirect("AdminAcceptstudents.aspx");

TxtUserName.Text = "";

}

Hi,

First of all i did not understand why you are using two different tables for storing login credentials. I think you can do it using single table. You can add UserRole column in your login table to identify whether user is Normal user or Admin user.

Suppose below is your Login table structure :

Table Name LoginMaster and UserID with PrimaryKey Column.

UserID	UserName	Password	UserRole
USER1	USER NAME 1	123	1
USER2	USER NAME 2	123	2

Here, for example i am using UserRole 1 for Normal User and 2 for Admin User.

Your code will be like this :

SqlConnection conn1 = new SqlConnection("Data Source=SERVER;Initial Catalog=MuraliIIT;User ID=sa;Password=rits@1234");

SqlCommand cmd1 = new SqlCommand("select UserRole FROM LoginMaster WHERE UserName='" + TxtUserName.Text + "' and password='" + Txtpassword.Text + "'");

cmd1.Connection = conn1;

conn1.Open();

var cmdResult = cmd1.ExecuteScalar();

if (cmdResult != null)

{

int OBJ1 = Convert.ToInt32(cmd1.ExecuteScalar());

if (OBJ1 == 1)

{

// Normal User Login Message

}

else if (OBJ1 == 2)

{

// Admin User Login Message

}

else

{

// else Part

}

else

{

//No such user found message

}

I hope this will help you.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manoj Bhoir11y ago
Accepted answer
Hi,

First of all i did not understand why you are using two different tables for storing login credentials. I think you can do it using single table. You can add UserRole column in your login table to identify whether user is Normal user or Admin user.

Suppose below is your Login table structure :
Table Name LoginMaster and UserID with PrimaryKey Column.

UserID UserName Password UserRole
USER1 USER NAME 1
123
1
USER2 USER NAME 2
123
2

Here, for example i am using UserRole 1 for Normal User and 2 for Admin User.

Your code will be like this :

SqlConnection conn1 = new SqlConnection("Data Source=SERVER;Initial Catalog=MuraliIIT;User ID=sa;Password=rits@1234");
SqlCommand cmd1 = new SqlCommand("select UserRole FROM LoginMaster WHERE UserName='" + TxtUserName.Text + "' and password='" + Txtpassword.Text + "'");
cmd1.Connection = conn1;
conn1.Open();
var cmdResult = cmd1.ExecuteScalar();
if (cmdResult != null)
{
   int OBJ1 = Convert.ToInt32(cmd1.ExecuteScalar());
   if (OBJ1 == 1)
   {
       // Normal User Login Message
   }
   else if (OBJ1 == 2)
   {
      // Admin User Login Message
   }
   else
   {
      // else Part
   }

}
else
{
   //No such user found message
}
I hope this will help you.
Manoj Bhoir11y ago
Most Welcome. :)
Venkata Subbareddy11y ago
Thanks Bro