连接到ACCESS数据库的登陆界面

注意 ACCESS数据库文件放在    **\bin\Debug 目录下

 

 1using System;
 2using System.Collections.Generic;
 3using System.ComponentModel;
 4using System.Data;
 5using System.Drawing;
 6using System.Linq;
 7using System.Text;
 8using System.Windows.Forms;
 9using System.Data.OleDb;
10
11namespace 信息管理系统
12{
13    public partial class FrmDenglu : Form
14    {
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            try
31            {
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}