#region Access // OleDbConnection dbconn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data source=D:\Dedop.mdb"); // // dbconn.Open(); // DataSet df = new DataSet(); // System.Data.OleDb.OleDbDataAdapter dfs = new System.Data.OleDb.OleDbDataAdapter("select D_Mark from Login where D_Mark= '"+txtName.Text.Trim()+"'",dbconn); // dfs.Fill(df,"Login"); // if(df.Tables[0].Rows.Count.ToString() != txtName.Text.Trim()) // { // DataSet dd = new DataSet(); // System.Data.OleDb.OleDbDataAdapter dfe = new System.Data.OleDb.OleDbDataAdapter("select D_PWD from Login where D_Mark='"+txtName.Text.Trim()+"'",dbconn); // dfe.Fill(dd,"Login"); // if(dd.Tables[0].Rows.Count.ToString() == txtPWD.Text.Trim()) // { // Menu menu = new Menu(); // menu.Show(); // this.Hide(); // return; // } // MessageBox.Show("密码不正确","错误"); // txtPWD.Focus(); // txtPWD.SelectAll(); // return; // } // MessageBox.Show("用户名不存在","错误"); // txtName.Focus(); // txtName.SelectAll(); // return; #endregion 修改连接数据库和表名,例名就好了!
不行啊....提示有为处理的exception 再麻烦你 一下吧!
// System.Data.OleDb.OleDbDataAdapter dfe = new System.Data.OleDb.OleDbDataAdapter("select D_PWD from Login where D_Mark='"+txtName.Text.Trim()+"'",dbconn); // System.Data.OleDb.OleDbDataAdapter dfs = new System.Data.OleDb.OleDbDataAdapter("select D_Mark from Login where D_Mark= '"+txtName.Text.Trim()+"'",dbconn); 这两条 sql语句也要改的
select count(*) from tab_user where uid='Jeff' and pwd='123'
#region Access
// OleDbConnection dbconn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data source=D:\Dedop.mdb");
//
// dbconn.Open();
// DataSet df = new DataSet();
// System.Data.OleDb.OleDbDataAdapter dfs = new System.Data.OleDb.OleDbDataAdapter("select D_Mark from Login where D_Mark= '"+txtName.Text.Trim()+"'",dbconn);
// dfs.Fill(df,"Login");
// if(df.Tables[0].Rows.Count.ToString() != txtName.Text.Trim())
// {
// DataSet dd = new DataSet();
// System.Data.OleDb.OleDbDataAdapter dfe = new System.Data.OleDb.OleDbDataAdapter("select D_PWD from Login where D_Mark='"+txtName.Text.Trim()+"'",dbconn);
// dfe.Fill(dd,"Login");
// if(dd.Tables[0].Rows.Count.ToString() == txtPWD.Text.Trim())
// {
// Menu menu = new Menu();
// menu.Show();
// this.Hide();
// return;
// }
// MessageBox.Show("密码不正确","错误");
// txtPWD.Focus();
// txtPWD.SelectAll();
// return;
// }
// MessageBox.Show("用户名不存在","错误");
// txtName.Focus();
// txtName.SelectAll();
// return;
#endregion
修改连接数据库和表名,例名就好了!
// System.Data.OleDb.OleDbDataAdapter dfs = new System.Data.OleDb.OleDbDataAdapter("select D_Mark from Login where D_Mark= '"+txtName.Text.Trim()+"'",dbconn);
这两条 sql语句也要改的