role base login ,open two seprate page for admin and user

Hi saba thank you for writing you to create table in sql server for both different like user & admin then when make connection with your application to server use select query of for user login table and for admin select admin table and create two aspx page for user and admin then write code

 

con.Open();

string str = "select * from ClientReg where UserID='" + aid + "' and Password='" + apass + "'";

SqlCommand cmd = new SqlCommand(str, con);

SqlDataReader dr = cmd.ExecuteReader();

if (dr.Read())

{

Session["id"] = dr["UserID"].ToString();

Response.Redirect("Home.aspx");

}

admin login code

con.Open();

string str = "select * from AdminLogin where UserID='" + aid + "' and Password='" + apass + "'";

SqlCommand cmd = new SqlCommand(str, con);

SqlDataReader dr = cmd.ExecuteReader(); // EndExecuteReader();

if (dr.Read())

{

Session["id"] = dr["UserID"].ToString();

Server.Transfer("AdminProducts.aspx");

txtId.Text = "";

txtPass.Text = "";

}