C# Access資料庫操作的範例程式碼介紹

C# Access資料庫操作的範例程式碼介紹

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.OleDb;namespace AccessPractice{    public static class AccessHelper    {        public static bool Execute(string path,string sql)         {            try            {                string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";";                OleDbConnection odcConnection = new OleDbConnection(strConn);                //2、開啟串連                odcConnection.Open();                //建立SQL查詢                OleDbCommand odCommand = odcConnection.CreateCommand();                //3、輸入查詢語句                odCommand.CommandText = sql;                odCommand.ExecuteNonQuery();                odcConnection.Close();                return true;            }            catch(Exception ex)            {                return false;            }        }        public static DataTable ReadAllData(string tableName, string mdbPath,int topN, ref bool success)        {            DataTable dt = new DataTable();            try            {                //1、建立串連                string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbPath + ";";                OleDbConnection odcConnection = new OleDbConnection(strConn);                //2、開啟串連                odcConnection.Open();                //建立SQL查詢                OleDbCommand odCommand = odcConnection.CreateCommand();                //3、輸入查詢語句                odCommand.CommandText = "select * from " + tableName;                //建立讀取                OleDbDataReader odrReader = odCommand.ExecuteReader();                //查詢並顯示資料                int size = odrReader.FieldCount;                for (int i = 0; i < size; i++)                {                    DataColumn dc;                    dc = new DataColumn(odrReader.GetName(i));                    dt.Columns.Add(dc);                }                DataRow dr;                int count = 0;                while (odrReader.Read())                {                    if (++count == topN)                     {                        break;                    }                    dr = dt.NewRow();                    for (int i = 0; i < size; i++)                    {                        dr[odrReader.GetName(i)] = odrReader[odrReader.GetName(i)].ToString();                    }                    dt.Rows.Add(dr);                }                //關閉串連                odrReader.Close();                odcConnection.Close();                success = true;                return dt;            }            catch            {                success = false;                return dt;            }        }    }}

以上就是C# Access資料庫操作的範例程式碼介紹的內容，更多相關內容請關注topic.alibabacloud.com（www.php.cn）！

