C#读取access2007数据库表中记录

liuyeede 2009-03-30 05:31:15

第一次用Access数据库，大家帮忙。
我的链接字符串是：

        <add key="DbProviderName" value="System.Data.OleDb"/>

        <add key="TaxInvoiceConn" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Tax.accdb;Persist Security Info=True"/>

        public static DataSet GetAllTaxPlayer()

        {

            DbHelper helper=new DbHelper();

            DataSet ds=new DataSet();

            string sqlStr = "Select TaxID,TaxName,Name,IsImpose,Tax,TradeID,Scope,DistrictID,ManagerID,Phone,Mobile From TaxPlayer";



            DbCommand dbCom = helper.GetSqlStringCommond(sqlStr);

            try

            {

                ds = helper.ExecuteDataSet(dbCom);

            }

            catch (ApplicationException ex)

            {

                MessageBox.Show(ex.Message);

            }

            finally

            {

                

            }

            return ds;

           

        }

       private static string dbProviderName = ConfigurationSettings.AppSettings["DbProviderName"];

        //private static string dbp = "Provider=System.Data.OleDb";

        private static string dbConnectionString = ConfigurationManager.AppSettings["TaxInvoiceConn"];



        private DbConnection connection;

        public DbHelper()

        {

            this.connection = CreateConnection(DbHelper.dbConnectionString);

        }





       public static DbConnection CreateConnection(string connectionString)

        {

            DbProviderFactory dbfactory = DbProviderFactories.GetFactory(DbHelper.dbProviderName);

            DbConnection dbconn = dbfactory.CreateConnection();

            dbconn.ConnectionString = connectionString;

            return dbconn;

        }



       public DbCommand GetSqlStringCommond(string sqlQuery)

        {

            DbCommand dbCommand = connection.CreateCommand();

            dbCommand.CommandText = sqlQuery;

            dbCommand.CommandType = CommandType.Text;

            return dbCommand;

        }



       public DataSet ExecuteDataSet(DbCommand cmd)

        {

            DbProviderFactory dbfactory = DbProviderFactories.GetFactory(DbHelper.dbProviderName);

            DbDataAdapter dbDataAdapter = dbfactory.CreateDataAdapter();

            dbDataAdapter.SelectCommand = cmd;

            DataSet ds = new DataSet();

            dbDataAdapter.Fill(ds);

            return ds;

        }