Authenticate users

mahmud_uk

Hi guys, I have two forms, form1 and form2. I also have this login page written in C# in form1. I'm trying to authenticate users through SQL database, if authenticated they will login to form 2, if not an error message should pop up and not allow form2 to open. Also after authentication is sucessfull, form1 should close and form2 should stay open. Here's the code: da.Open(); SqlCommand thisCommand = da.CreateCommand(); String sQuery = "SELECT * FROM License WHERE Name = '"+ textBox1.Text +"' AND LicenseID = '"+ textBox2.Text +"'"; SqlCommand cmd = new SqlCommand(sQuery, da); SqlDataReader dr = cmd.ExecuteReader(); Form2 frm = new Form2(); //if (dr.Tables["License"].Rows.Count == 0) //MessageBox.Show("Incorrect UserName and/or ID, Try again!"); da.Close(); frm.Show(); I'm stuck on authentication and closing the form1, can someone direct me where i have gone wrong. Thanks, Mac

4 Replies

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

p.jones22y ago
To close form1 you would have to say Form1.Close()?
0
Adam Erstelle22y ago
As I had indicated in a private email, you will have to check the proper use of the ExecuteScalar method in the framework documentation. Sorry, as I should have stated that in my previous post.
0
mahmud_uk22y ago
for some reason cmd.executescalar is not recognised. No definition could be found.
0
Adam Erstelle22y ago
Instead of "SELECT * FROM License WHERE Name = '"+ textBox1.Text +"' AND LicenseID = '"+ textBox2.Text +"'", Try "SELECT count(*) FROM License WHERE Name = '"+ textBox1.Text +"' AND LicenseID = '"+ textBox2.Text +"'" then do the following if (cmd.executescalar() ==0) MessageBox.Show("Incorrect UserName and/or ID, Try again!");
0