WPF user authentication against SQL database with 2 roles

Milisav Radivojevic

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.

5 Replies

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

Raja T11y ago
Accepted 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 < ds.Tables[0].Rows.Count; 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();
}
+2
Milisav Radivojevic11y ago
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 :)
0
Raja T11y ago
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?
+1
Milisav Radivojevic11y ago
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...
0
Raja T11y ago
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 < ds.Tables[0].Rows.Count; 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
}
-1