using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Text.RegularExpressions; using System.Windows.Forms; using System.Data.OleDb; using System.Configuration; using System.IO; using System.Text; namespace OleDBHelper { /// <summary> /// Class1 的摘要说明。 /// </summary> public class Db { public Db() { // // TODO: 在此处添加构造函数逻辑 // } public static string ConnectionString { get { //return "Provider=Sqloledb; User ID=sa; Password=111122; Initial Catalog=TempData; Data Source=192.168.0.219;"; return "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = 案例数据下载.mdb"; } } public static DataView Config; public static DataView Board; public OleDbDataReader GetList(string Sql) { OleDbConnection myConnection = new OleDbConnection(Db.ConnectionString); OleDbCommand myCommand = new OleDbCommand(Sql, myConnection); myConnection.Open(); OleDbDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection); return result; } /* 返回DataView数据集 用法: Eims.Db MyGrid = new Eims.Db(); string Sql="MyString" DataGrid.DataSource=MyGrid.GetGrid(Sql,Tb); DataGrid.DataBind(); */ public DataView GetGrid(string Sql,string Tb) { DataSet DS; OleDbConnection myConnection = new OleDbConnection(Db.ConnectionString); OleDbDataAdapter myCommand = new OleDbDataAdapter(Sql, myConnection); DS = new DataSet(); myCommand.Fill(DS, Tb); DataView result = DS.Tables[Tb].DefaultView; return result; } public DataTable GetTable(string Sql,string Tb) { DataSet DS; OleDbConnection myConnection = new OleDbConnection(Db.ConnectionString); OleDbDataAdapter myCommand = new OleDbDataAdapter(Sql, myConnection); DS = new DataSet(); myCommand.Fill(DS, Tb); DataTable result = DS.Tables[Tb]; return result; } public int ExeSql(string Sql) { OleDbConnection myConnection = new OleDbConnection(Db.ConnectionString); OleDbCommand myCommand=new OleDbCommand(Sql,myConnection); try { myConnection.Open(); myCommand.ExecuteNonQuery(); myCommand.Dispose(); myConnection.Close(); return 1; } catch(Exception ex) { myConnection.Close(); //MessageBox.Show(ex.Message+"/r/n"+Sql); return 0; } } public int GetId(string Sql) { OleDbConnection myConnection = new OleDbConnection(Db.ConnectionString); OleDbCommand myCommand = new OleDbCommand(Sql, myConnection); myConnection.Open(); OleDbDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection); result.Read(); int i=0; try { i = result.GetInt32(0); } catch { } result.Close(); myCommand.Dispose(); myConnection.Close(); return i; } public int GetCount(string Sql) { OleDbConnection myConnection = new OleDbConnection(Db.ConnectionString); OleDbCommand myCommand=new OleDbCommand(Sql,myConnection); myConnection.Open(); OleDbDataReader result = myCommand.ExecuteReader(); int i=0; while(result.Read()) { i=result.GetInt32(0); //i=result.; } result.Close(); myCommand.Dispose(); myConnection.Close(); return i; } } }