User authentication

Question

I have a Log in form which connect to database to check username and password, in this User table I have a roleID which is FK from Role table (RoleID, Name, Description)

In C# Windows form application, I would like to check if it is "Admin" then show some text box on different form,

How can I implement code for this.

Thank you.

Riddhi Valecha · Answer

Hi.... I am giving the logic. It will work. Do the following steps. -------- 1)On LoginPage fire the query - select * from Table_Users where Username='+txtbox1.text.tostring()+' AND Password='+txtbox2.text.tostring()+'; 2)Login is successful then fire the query -select RoleID from Table_Users where Username='+txtbox1.text.tostring()+'; 3)If you are using Datareader you can use the statement - int roleid=convert.toint32(dr[RoleID].Tostring()); 4) Now lastly fire the query - select Role from Table_Role where ID='+roleid+'; 5)Here you will get the role of the user. 6)Put the conditions. i.e. if(role==Admin) {// code here.} ------------ Do let me know if you need any other help regarding this.