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

Example #1

File: DbHelper.cs Project: 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);
        }

Example #2

File: DbHelper.cs Project: 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);
        }