C# (CSharp) up7.db.biz.database DbHelper.GetProviderの例

コード例 #1

ファイル: DbHelper.cs プロジェクト: 1269085759/up7-asp.net

        public DataTable ExecuteDataTable(DbCommand cmd)
        {
            DbProviderFactory dbfactory     = DbProviderFactories.GetFactory(DbHelper.GetProvider());
            DbDataAdapter     dbDataAdapter = dbfactory.CreateDataAdapter();

            dbDataAdapter.SelectCommand = cmd;
            DataTable dataTable = new DataTable();

            dbDataAdapter.Fill(dataTable);
            return(dataTable);
        }

コード例 #2

ファイル: DbHelper.cs プロジェクト: 1269085759/up7-asp.net

        public DataTable ExecuteDataTable(DbCommand cmd, Trans t)
        {
            cmd.Connection  = t.DbConnection;
            cmd.Transaction = t.DbTrans;
            DbProviderFactory dbfactory     = DbProviderFactories.GetFactory(DbHelper.GetProvider());
            DbDataAdapter     dbDataAdapter = dbfactory.CreateDataAdapter();

            dbDataAdapter.SelectCommand = cmd;
            DataTable dataTable = new DataTable();

            dbDataAdapter.Fill(dataTable); return(dataTable);
        }