我需要进行登录并想要创建与数据库连接的登录。
OleDbCommand cm;
OleDbConnection cn = new OleDbConnection();
cn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\LakshanP\Documents\C Sharp work with database\adhideit.accdb";
cm = new OleDbCommand("select usnam,paswd from signin where usnam = @a and paswd = @b", cn);
cm.Parameters.AddWithValue("@usnam", textBox1.Text.ToString());
cm.Parameters.AddWithValue("@paswd", textBox2.Text.ToString());
string un;
string pw;
cn.Open();
OleDbDataReader dr = cm.ExecuteReader();
if (textBox1.Text == "usnam" & textBox2.Text == "paswd")
{
new Form1().Show();
}
else
{
MessageBox.Show("Invalied Username or Password");
}
如果要从执行的查询中获取数据,则需要从数据读取器(即dr.Read())读取数据,然后检查它是否具有表示用户名和密码有效的行,否则无效。
OleDbCommand厘米;OleDbConnection cn =新的OleDbConnection(); cn.ConnectionString = @“ Provider = Microsoft.ACE.OLEDB.12.0; Data Source = C:\ Users \ LakshanP \ Documents \ C Sharp使用database \ adhideit.accdb”
cm = new OleDbCommand("select usnam,paswd from signin where usnam = @usnam and paswd = @paswd", cn);
cm.Parameters.AddWithValue("@usnam", textBox1.Text.ToString());
cm.Parameters.AddWithValue("@paswd", textBox2.Text.ToString());
string un;
string pw;
cn.Open();
OleDbDataReader dr = cm.ExecuteReader();
if (dr.Read())
{
new Form1().Show();
}
else
{
MessageBox.Show("Invalied Username or Password");
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句