Session of role

saifullah khan

15y1.9k.NET

i have 2 web pages one for login and other index.
for login 3 cols are defined in database table. name, password, and role
i want that when user loges in a session is created that saves the role of user(means it takes the role from database table for that particular user). after loging in to the index pages the role session is to be checked whether the user is user or admin. how is it possible. please help me.

3 Replies

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

Morcos Adel15y ago
Accepted answer
sqlconnection connection=new sqlconnection("ConnectionString);

sqlcommand command=new sqlcommand();
command.connection=connection;
command.commandType=CommandType.Text;
command.commandText="select role from [your Tablename] where name='name'";

sqlDatareader Dr=command.ExecuteReader();
while (Dr.read())
{
String x=Dr["role"].tostring();
}
// Now String x has The Value Returned from the query

Session["Role"]=x;

// Now Session["Role"] has the Value of x

you can check on it in the Index Page

i hope this helps...
saifullah khan15y ago
can you please give me the query?
Morcos Adel15y ago
you can get the role of the current user by querying the database and get the role then you can assign it to a session and check it in the page_load() of the index page

or
you can use the ASP.NET SQL Server Registration Tool which will give you more features to use.