典型代码-.net连接access(控制台)

最新推荐文章于 2022-07-20 16:12:52 发布

IT技术与企业应用结合的爱好者

最新推荐文章于 2022-07-20 16:12:52 发布

阅读量322

点赞数

分类专栏： C# 文章标签： C# .net

本文链接：https://blog.csdn.net/liheao/article/details/50621700

版权

C# 专栏收录该内容

70 篇文章 0 订阅

订阅专栏

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;

namespace ConsoleApplication5
{
    class Program
    {
        static void Main(string[] args)
        {

            OleDbDataAdapter dataAdapter = new OleDbDataAdapter();
            OleDbConnection accConnection = new OleDbConnection();
            OleDbCommand accCommand = new OleDbCommand();
            DataSet ds = new DataSet();
            string connString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                           "Data Source=C:\\DataBase\\xxx.mdb";
            string cmdString = "SELECT * FROM info";

            accConnection = new OleDbConnection(connString);
            accConnection.Open();
            accCommand.Connection = accConnection;
            accCommand.CommandType = CommandType.Text;
            accCommand.CommandText = cmdString;
            dataAdapter.SelectCommand = accCommand;
            dataAdapter.Fill(ds, "xxx");
            var logininfo = (from li in ds.Tables["xxx"].AsEnumerable() select li );
            foreach (var fRow in logininfo)
            {
                Console.WriteLine("no: {0} name: {1}",
   fRow.Field<string>("no"), fRow.Field<string>("name"));
            }
            accConnection.Close();
        }
    }
}