c#数据库连接代码.docx

private void button1_Click(object sender, EventArgs e) { conn.Open(); string strSql = select * from loginUser where User_id= + textBox1.Text + and User_pass= + textBox2.Text + ; 设置 Command OleDbCommand olecmd = new OleDbCommand(strSql, conn); try { if (olecmd.ExecuteScalar() == null)// {  执行查询得到数据 MessageBox.Show(  用户名或者密码错误  ); } else { Form2 b = new Form2(); b.Show(); this.Hide(); } } catch (Exception ex) { throw new Exception(ex.ToString()); } finally { conn.Close(); } } private void Form1_Load( object sender, EventArgs e) { conn =  string  connString = Provider=Microsoft.Jet.OLEDB.4.0; Data Source=db.mdb new OleDbConnection (connString);  ; } private void button1_Click(object sender, EventArgs e) { conn.Open(); string strSql = select * from loginUser where User_id= + textBox1.Text + ; OleDbCommand olecmd = new OleDbCommand(strSql, conn); try { OleDbDataReader adobj = olecmd.ExecuteReader(); if (adobj.HasRows) { adobj.Read(); string studer = adobj.GetString(2); if (studer == textBox2.Text) { Form2 b = new Form2(); b.Show(); this.Hide(); } else { MessageBox.Show( 密码错误 ); } } else { MessageBox.Show( 没有此用户 ); } } catch (Exception ex) { throw new Exception(ex.ToString()); } finally { conn.Close(); } } private void button1_Click( object sender, EventArgs e) { conn.Open(); string strSql = select * from loginUser where User_id= + textBox1.Text + ; OleDbDataAdapter oleado = new OleDbDataAdapter (strSql, conn); DataSet ds= new DataSet (); try { oleado.Fill(ds, loginUser ); DataTable table = ds.Tables[0]; if (table.Rows!= null ) { DataRow a = table.Rows[0]; if (a[ User_Pass ] == textBox2.Text) { Form2 b = new Form2(); b.Show(); this .Hide(); } else { MessageBox.Show( 密码失败 ); } } else { MessageBox.Show( 用户失败 ); } } catch ( Exception ex) { throw new Exception (ex.ToString()); } finally { conn.Close(); } } } }