Home 类库下载 C# class library C# Access database operations

C# Access database operations

Nov 10, 2016 am 09:14 AM

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;  
            }  
        }  
   
   
    }  
}
Copy after login

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
1 months ago By 尊渡假赌尊渡假赌尊渡假赌
Two Point Museum: All Exhibits And Where To Find Them
1 months ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)