c# 连接access2007且查询

最新推荐文章于 2019-07-05 18:00:30 发布

原创最新推荐文章于 2019-07-05 18:00:30 发布 · 4.1k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#access #c# #dataset #string #security #class

本文介绍如何使用C#连接并从Access2007数据库中读取数据。通过具体的代码示例展示了如何建立数据库连接、执行SQL查询以及获取查询结果。

和连接sql2005差不多,只需要该连接字符串即可. using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.OleDb; using System.Data.SqlClient; namespace TestAccess { class Program { static void Main(string[] args) { #region Access 2007 Console.WriteLine("Access 2007"); string strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;"; strConnection += @"Data Source=C:/Documents and Settings/v-changl/My Documents/Database1.accdb;"; strConnection += "Persist Security Info=False"; using (OleDbConnection objConnection = new OleDbConnection(strConnection)) { objConnection.Open(); OleDbDataAdapter myCommandd = new OleDbDataAdapter("select * from Couse", objConnection); DataSet ds = new DataSet(); myCommandd.Fill(ds, "couse"); DataTable dt = ds.Tables["couse"]; Console.WriteLine(dt.Columns[0].ToString()); Console.WriteLine(dt.Columns[1].ToString()); Console.WriteLine(dt.Columns[2].ToString()); objConnection.Close(); } #endregion } } }