WPF user authentication against SQL database with 2 roles

Question

Hi guys,

First I want to thank you for your great knowledge sharing. I have project in school to do this week in VS 2013 C#. WPF(not Win-forms)

Login window with user authentication against MS SQL database with 2 different roles: Admin and Client(open Window1 on success login). I have connected my DB with my WPF fine. I have 1 question if you can help.

In my SQL DB I have made table "users" with this columns("id, username, password, role") I need to have only 1 Admin so I assigned 1st user with id "1" and username "admin", password "pass" and Role "Admin". Rest 3 users I made are assigned as "Client" in "Role" Column. How can I use Role column on button_click event handler to authorize 2 different access Roles or levels

My MainWindow.Xaml.cs: http://pastebin.com/xDk823JE
My Xaml Designer Code: http://pastebin.com/9jkyhXFF

Any help is much appreciate, uploaded complete project if you want to take a look and help me out with this. Just need simple, non-secured working example, advice, pointers.
Thanks a lot.

Raja T · Answer

Hi, If you using role concept ? try like private void button1_Click(object sender, RoutedEventArgs e) { SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=Aukcija;Integrated Security=True"); con.Open(); SqlDataAdapter sda = new SqlDataAdapter("SELECT Role FROM users WHERE Username='"+ textBoxUser.Text +"' and Password='"+ passBoxPwd.Password + "' ", con); DataSet ds=new DataSet (); sda .Fill (ds,"Login"); for (int i = 0; i { String role = ds.Tables[0].Rows[0]["Role "].ToString(); // here check admin login/client login if(role=="admin") { //here admin form show code like bellow this.Hide(); Window1 w1 = new Window1(); w1.Show(); } else { //here client form show code this.Hide(); Window1 w1 = new Window1(); w1.Show(); } } con.Close(); }

Milisav Radivojevic · Answer

Hi Raja Prs, I think this could be the solution I was searching for. Will try to use it on my concept. I was wondering how to put Role in some variable so I can use it exactly for this. Will notify you later when I check it from home :)

Raja T · Answer

Hi, private void button1_Click(object sender, RoutedEventArgs e) { SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=Aukcija;Integrated Security=True"); con.Open(); SqlDataAdapter sda = new SqlDataAdapter("SELECT Role FROM users WHERE Username='"+ textBoxUser.Text +"' and Password='"+ passBoxPwd.Password + "' ", con); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count == 1) { this.Hide(); Window1 w1 = new Window1(); w1.Show(); } con.Close(); } I have reviewed your code it is working fine. But for your requirement not correct as per my understanding. Because above code is checking only userid and password correct or not there is not and also if correct showing new form in that no logic here. i need one questiong why are using role ?what purpose of role? Please confirm?

Milisav Radivojevic · Answer

Can you please check my source proj. and confirm that it works with your code? If so, please send it back so I can give you a positive vote. This scenario does not cover or include my texbox and pass fields at all. Just confuses me, sry...

Raja T · Answer

Hi, try like in btn click event like con.Open(); SqlCommand cmd=new SqlCommand("select username,password,role from Login ",con); SqlDataAdapter da=new SqlDataAdapter (cmd); DataSet ds=new DataSet (); da.Fill (ds,"Login"); string v1,v2,v3; for (int i = 0; i { v1 = ds.Tables[0].Rows[i][0].ToString(); v2 = ds.Tables[0].Rows[i][1].ToString(); v3 = ds.Tables[0].Rows[i][2].ToString(); //here store the value v3(role) in Session/global variable } Here check role If(v3==" admin") { //here admin code }else { //here client code }

WPF user authentication against SQL database with 2 roles

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (5)