1.添加工具类MDBHelp.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace CPKFLandCheck.src.utils
{public class MDBHelp{private string _fileName;private string _connectionString;private OleDbConnection _odcConnection;/// /// 构建函数/// /// MDB文件&＃xff08;含完整路径&＃xff09;public MDBHelp(string fileName){this._fileName &＃61; fileName;this._connectionString &＃61; &＃64;"Provider&＃61;Microsoft.Jet.OLEDB.4.0;Data Source&＃61;" &＃43; fileName &＃43; ";";}public MDBHelp(){string fileName &＃61; "src//db//db.mdb";this._fileName &＃61; fileName;this._connectionString &＃61; &＃64;"Provider&＃61;Microsoft.Jet.OLEDB.4.0;Data Source&＃61;" &＃43; fileName &＃43; ";";}/// /// 建立连接&＃xff08;打开数据库文件&＃xff09;/// public void Open(){try{// 建立连接this._odcConnection &＃61; new OleDbConnection(this._connectionString);// 打开连接this._odcConnection.Open();}catch (Exception){throw new Exception("尝试打开 " &＃43; this._fileName &＃43; " 失败, 请确认文件是否存在&＃xff01;");}}/// /// 断开连接&＃xff08;关闭据库文件&＃xff09;/// public void Close(){this._odcConnection.Close();}/// /// 根据sql命令返回一个DataSet/// /// sql命令/// 以DataTable形式返回数据public DataSet GetDataSet(string sql){Open();//打开连接DataSet ds &＃61; new DataSet();try{OleDbDataAdapter adapter &＃61; new OleDbDataAdapter(sql, this._odcConnection);adapter.Fill(ds);}catch (Exception ex){throw new Exception("sql语句&＃xff1a; " &＃43; sql &＃43; " 执行失败&＃xff01;");}Close();//关闭连接return ds;}}
}
2.工具类的使用
MDBHelp mdbHelp &＃61; new MDBHelp();var db &＃61; mdbHelp.GetDataSet("select ERROR_CODE,ERROR_REQUIRE from CPKF_ERROR where ERROR_REQUIRE_CONTENT is null order by ID");foreach (DataTable dt in db.Tables){foreach (DataRow dr in dt.Rows) //遍历所有的行{String ErrorCode &＃61; dr.ItemArray[0].ToString();String ErrorRequire &＃61; dr.ItemArray[1].ToString();var node &＃61; new TreeNode(ErrorCode &＃43; " " &＃43; ErrorRequire);treeView.Nodes.Add(node);}}
京公网安备 11010802041100号