连接到ACCESS数据库的登陆界面
注意 ACCESS数据库文件放在 **\bin\Debug 目录下
1
using System;2
using System.Collections.Generic;3
using System.ComponentModel;4
using System.Data;5
using System.Drawing;6
using System.Linq;7
using System.Text;8
using System.Windows.Forms;9
using System.Data.OleDb;10

11
namespace 信息管理系统12


{13
public partial class FrmDenglu : Form14

{15
public FrmDenglu()16

{17
InitializeComponent();18
}19

20
private void button2_Click(object sender, EventArgs e)21

{22
this.Close();23
}24

25
private void button1_Click(object sender, EventArgs e)26

{27
string CString = "Provider=Microsoft.Jet.OlEDB.4.0;Data Source=学生信息管理.mdb";28
string SQLStr = "select * from 用户表";29

30
try31

{32
OleDbConnection myCon = new OleDbConnection(CString);33

34
myCon.Open();35

36
OleDbCommand MyCom1 = new OleDbCommand();37
MyCom1.Connection = myCon;38
MyCom1.CommandType = CommandType.Text;39
MyCom1.CommandText = SQLStr;40

41
OleDbDataAdapter mydataAdapter1 = new OleDbDataAdapter();42

43
mydataAdapter1.SelectCommand = MyCom1;44

45
DataSet myds = new DataSet();46
mydataAdapter1.Fill(myds, "用户表");47

48
int i;49
bool flag = false;50

51
for (i=0;i<myds.Tables["用户表"].Rows.Count; i++)52

{53
if (textBox1.Text=="" || textBox2.Text =="")54

{55
MessageBox.Show("用户密码不能为空!","警告");56
textBox1.Text="";57
textBox2.Text="";58
textBox1.Focus();59
flag=true;60
break;61
}62
else if(textBox1.Text !=myds.Tables["用户表"].Rows[i][0].ToString().Trim() || 63
textBox2.Text !=myds.Tables["用户表"].Rows[i][3].ToString().Trim())64

{65
flag=false;66
}67
else if(textBox1.Text == myds.Tables["用户表"].Rows[i][0].ToString().Trim() && 68
textBox2.Text == myds.Tables["用户表"].Rows[i][3].ToString().Trim())69

{70
//此处可以加登陆成功后其它的语句71
MessageBox.Show("登陆成功!");72
flag=true;73
this.Close();74
break;75
}76
}77

78
if (flag==false)79

{80
MessageBox.Show("输入有误!");81
textBox1.Text="";82
textBox2.Text="";83
textBox1.Focus();84
}85

86
myCon.Close();87
88
}89
catch (OleDbException OleDbe)90

{91
MessageBox.Show(OleDbe.Message,"连接失败"); 92
}93
}94
}95
}
浙公网安备 33010602011771号