log-on form

theo philus

please help me in the coding. i m a beginner in C#.Net. i would like to create a login form and the username and the password will be check in the MYSQL SERVER. the form contains two textboxes and two buttons - OK, Cancel. in the form_load, the username is retrieve from the MYSQL server , the database = "USERS", Table="Logon", with the field= username and password.The username="Admin" and the password="Admin" is the first record. The user can select login as a Admin. then they have to enter the password and username in the textboxes.the pressed OK button. If the username and the password is correct, then the form2 will display else the error message " invalid user and password".

can you show me this with codes

2 Replies

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

Arupa Behera17y ago
string connect="data source=server,initial catalog=database name,user id=user_id,password=pwd"; SqlConnection con=new SqlConnection(connect); con.Open(); string sql="select * username,password from logon where username='"+textBox1.Text+"'" and password='"+textBox2.Text+"'; SqlDataAdapter da=new SqlDataAdapter(sql,con); SqlCommandBuilder bld=new SqlCommandBuilder(da); DataSet ds=new DataSet(); da.Fill(ds,"logon"); if(ds.Tables["logon"].Rows.Count>0) { MessabeBox.Show("Successfullylogin"); } else { MessageBox.Show("Invalid user & password"); }
0
Jan Montano17y ago
Database Programming in C# with MySQL : Using OleDB

The link above will show you how to access a mysql database. Read pages 1-4 first. You could see the code in page 3.

just use the details below instead...

// the user id and password for the connection string must be your userid and password used in connecting to mysql.
string strConnect = "Server=localhost;Database=myDatabase;Uid=Admin;Pwd=Admin;"Connect Timeout=30;"

string strSQL= string.Format("Select password from Logon where username='{0}'","Admin");

while( reader.Read())
Console.WriteLine(reader.GetString(0));

*Do you already know how to handle click events of buttons?

0