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();  
                    //查詢并顯示數(shù)據(jù)  
                    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);  
                    }  
                    //關(guān)閉連接  
                    odrReader.Close();  
                    odcConnection.Close();  
                    success = true;  
                    return dt;  
                }  
                catch  
                {  
                    success = false;  
                    return dt;  
                }  
            }  
      
      
        }  
    }  

標(biāo)簽：

版權(quán)申明：本站文章部分自網(wǎng)絡(luò)，如有侵權(quán)，請(qǐng)聯(lián)系：west999com@outlook.com
特別注意：本站所有轉(zhuǎn)載文章言論不代表本站觀點(diǎn)！
本站所提供的圖片等素材，版權(quán)歸原作者所有，如需使用，請(qǐng)與原作者聯(lián)系。