#region 连接本地数据库
private OleDbConnection con; /// <summary> /// 打开数据库连接 /// </summary> /// <param name="DBpath">数据库路径(包括数据库名)</param> private void Open(String DBpath) { if (con == null) con = new OleDbConnection(@" Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =C:\Users\yuleyi\Desktop\LocalConfig.mdb"); if (con.State == ConnectionState.Closed) con.Open(); }
/// <summary> /// 创建一个命令对象并返回该对象 /// </summary> /// <param name="sqlStr">数据库语句</param> /// <param name="file">数据库所在路径</param> /// <returns>OleDbCommand</returns> private OleDbCommand CreateCommand(string sqlStr, string file) { Open(file); OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = sqlStr; cmd.Connection = con; return cmd; }
/// <summary> /// 执行数据库查询 /// </summary> /// <param name="sqlStr">查询语句</param> /// <param name="tableName">填充数据集表格的名称</param> /// <param name="file">数据库所在路径</param> /// <returns>查询的数据集</returns> public DataSet GetDataSet(string sqlStr, string file) { DataSet ds = new DataSet(); OleDbCommand cmd = CreateCommand(sqlStr, file); OleDbDataAdapter dataAdapter = new OleDbDataAdapter(cmd); dataAdapter.Fill(ds); cmd.Dispose(); dataAdapter.Dispose(); return ds; }
|