C#连接Access数据库

最新推荐文章于 2025-12-15 11:06:12 发布

原创最新推荐文章于 2025-12-15 11:06:12 发布 · 3.2k 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#access #c# #login #dataset #database #textbox

本文提供了一个使用C#连接Access数据库的具体示例，并展示了如何通过两种不同方法实现数据查询及显示。第一种方法尝试直接连接并填充数据集但未成功；第二种方法通过详细步骤实现了连接、查询并将结果展示在DataGridView中。

部署运行你感兴趣的模型镜像

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

namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            //Method 1: C# Connnect Access DataBase; *** Don't Success ***
            /* string strconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=D:/test.mdb";
            string strSQL = "SELECT * FROM login";
            System.Data.OleDb.OleDbConnection myConn = new OleDbConnection(strconn);
            System.Data.OleDb.OleDbDataAdapter myAper = new OleDbDataAdapter(strSQL,myConn);
            System.Data.DataSet myset = new DataSet();
            myAper.Fill (myset,"login");
            this.dataGridView1.DataSource = myset.Tables["login"];
            */

            //Method 2: C# Connect Access DataBase;
            System.Data.OleDb.OleDbConnection dbconn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data source=D:/test.mdb");
            //dbconn.Open();
            System.Data.OleDb.OleDbCommand myCmd = new OleDbCommand("select 用户名 from login", dbconn);
            System.Data.OleDb.OleDbDataAdapter myAdapter = new OleDbDataAdapter(myCmd);
            System.Data.DataSet myDataSet = new DataSet();
            //myAd.Fill (myDs,"login");
            try
            {
                dbconn.Open();
                myAdapter.Fill(myDataSet,"login");
            }
            catch(OleDbException)
            {
                //错误处理
            }
            finally
            {
                if (dbconn.State == ConnectionState.Open)
                    dbconn.Close();
            }
            this.dataGridView1.DataSource = myDataSet.Tables["login"];
            //this.dataGridViewComboBoxEditingControl1.DataSource = myDataSet.Tables["login"];

        }
    }
}

[OleDbDataReader 的运用]

            OleDbConnection dbconn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data source=D:/test.mdb");
            OleDbCommand myCmd = new OleDbCommand("select * from login where 用户名='" + textBox1.Text + "'", dbconn);
            dbconn.Open();
            OleDbDataReader reader;
            reader = myCmd.ExecuteReader();
            if (reader.Read())
            {
                MessageBox.Show(reader["密码"].ToString());
            }
            else
            {
                MessageBox.Show("没有这个用户！");
            }

您可能感兴趣的与本文相关的镜像