public static DataTable GetDataTable(String query,IDbEnvironment environment) { DbCommand dc = environment.CreateCommand(query, CommandType.Text); if (Options.ShouldBindSymbols()) environment.BindFixtureSymbols(dc); DbDataAdapter oap = environment.DbProviderFactory.CreateDataAdapter(); oap.SelectCommand = dc; var ds = new DataSet(); oap.Fill(ds); dc.Dispose(); return ds.Tables[0]; }
public static DataTable GetDataTable(String query, IDbEnvironment environment, int rsNo) { DbCommand dc = environment.CreateCommand(query, CommandType.Text); if (Options.ShouldBindSymbols()) { environment.BindFixtureSymbols(dc); } DbDataAdapter oap = environment.DbProviderFactory.CreateDataAdapter(); oap.SelectCommand = dc; var ds = new DataSet(); oap.Fill(ds); dc.Dispose(); return(ds.Tables[rsNo - 1]); }
private void InspectQuery(Parse table) { DbCommand dc = (DbCommand)environment.CreateCommand(objectName, CommandType.Text); environment.BindFixtureSymbols(Symbols, dc); DbDataAdapter oap = environment.DbProviderFactory.CreateDataAdapter(); oap.SelectCommand = dc; DataSet ds = new DataSet(); oap.Fill(ds); dc.Dispose(); DataTable dtbl = ds.Tables[0]; Parse newRow = getHeaderFromRS(dtbl); table.Parts.More = newRow; foreach (DataRow dr in dtbl.Rows) { newRow.More = getDataRow(dr); newRow = newRow.More; } }