using System; using System.Data; using System.Configuration; using System.Web; using System.Data.OleDb; /// <summary> /// DataAccess 的摘要说明 /// </summary> public class AccessHelper { protected OleDbConnection connection = new OleDbConnection(); protected OleDbCommand cmd = new OleDbCommand(); public string _fileName; public AccessHelper(string fileName) { _fileName = fileName; openConnection(); } /// <summary> /// Open Db /// </summary> private void openConnection() { if (connection.State == ConnectionState.Closed) { //ACCESS2007 connection.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + _fileName; //Access2003 //connection.ConnectionString = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + _fileName; cmd.Connection = connection; connection.Open(); } } /// <summary> /// Close Db /// </summary> private void closeConnection() { if (connection.State == ConnectionState.Open) { connection.Close(); connection.Dispose(); cmd.Dispose(); } } /// <summary> /// 执行sql语句 /// </summary> /// <param name="sqlstr">SQL语句</param> public void excuteSql(string sqlstr) { try { openConnection(); cmd.CommandType = CommandType.Text; cmd.CommandText = sqlstr; cmd.ExecuteNonQuery(); } catch (Exception) { } finally { closeConnection(); } } /// <summary> /// Return dataset /// </summary> /// <param name="sqlstr"></param> /// <returns></returns> public DataSet getDataSet(string sqlstr) { DataSet ds = new DataSet(); OleDbDataAdapter da = new OleDbDataAdapter(); try { openConnection(); cmd.CommandType = CommandType.Text; cmd.CommandText = sqlstr; da.SelectCommand = cmd; da.Fill(ds); } catch (Exception e) { throw new Exception(e.Message); } finally { closeConnection(); } return ds; } /// <summary> /// Return datatable /// </summary> /// <param name="sqlstr"></param> /// <returns></returns> public DataTable getDataTable(string sqlstr) { DataTable dt = new DataTable(); OleDbDataAdapter da = new OleDbDataAdapter(); try { openConnection(); cmd.CommandType = CommandType.Text; cmd.CommandText = sqlstr; da.SelectCommand = cmd; da.Fill(dt); } catch (Exception e) { throw new Exception(e.Message); } finally { closeConnection(); } return dt; } } public void MigAppliction() { private AccessHelper accessHelper; accessHelper = new AccessHelper(@filename);//the access file path string cmd = "SELECT * FROM [Application]"; DataTable table = accessHelper.getDataTable(cmd); foreach (DataRow row in table.Rows) { int id = Convert.ToInt32(row["ID"]); string Name = Convert.ToString(row["Name"]).Trim(); string Version = Convert.ToString(row["Version"]); string DesignSpec=Convert.ToString(row["DesignSpec"]); } }