C# Access数据库操纵的示例代码引见【C#.Net教程】,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数据库操纵的示例代码引见的内容，更多相关内容请关注ki4网（www.ki4.cn）！