using System;
using System.Collections.Generic;
using
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace 叶影电脑维护系统
{
    public partial class Login : Form
    {
        public Login()
        {
            InitializeComponent();
        }

        public bool blCanLogin;
        OleDbConnection connection1 = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0;" + "Data Source = d:\\ysf.mdb");

        private void button1_Click(object sender, EventArgs e)
        {
            blCanLogin = false;
            string sql = "select username,password from admin";
            DataRow myRow;
            connection1.Open();            
            OleDbDataAdapter adp = new OleDbDataAdapter(sql, connection1);
            DataSet ds = new DataSet();
            adp.Fill(ds,"user");
            if (textBox1.Text.Trim() != "")
            {
                if (textBox2.Text.Trim() != "")
                {
                    for (int i = 0; i < ds.Tables["user"].Rows.Count; i++)
                    {
                        myRow = ds.Tables["user"].Rows[i];
                        if (myRow[0].ToString().Trim() == textBox1.Text.ToString().Trim() && myRow[1].ToString().Trim() == textBox2.Text.ToString().Trim())
                        {
                            blCanLogin = true;
                            MainForm mainForm = new MainForm();
                           // mainForm.myname = this.textBox1.Text.Trim();
                           return;

                        }
                        connection1.Close();
                    }
                    MessageBox.Show("你输入的用户名或密码不正确！");
                    connection1.Close();
                    return;
                }
                else
                    MessageBox.Show("密码不能为空");
                connection1.Close();
                return;
            }
            MessageBox.Show("用户名不能为空");
            connection1.Close();
        }


        private void button2_Click(object sender, EventArgs e)
        {
            blCanLogin = false;
            this.Close();
        }

        
        
    }
}


我在D盘下有了ysf.mdb 这个数据库了。也有相应的表及字段！！！

[[italic] 本帖最后由 ysf0181 于 2008-1-24 22:27 编辑 [/italic]]