private void button70_Click(object sender, EventArgs e)
{
SQLOracle.BuildConnectionString("ASPPR", "ASPPR", "BASEEOI", "192.168.1.170", "1521");
MessageBox.Show(SQLOracle.SelectWithOneParam("Select P1 from AS_GOST_25347_82_P_T1 where ID_GOST_82_P_T1 = :ID_GOST_82_P_T1", ":ID_GOST_82_P_T1", "2"));
// dataGridView1.DataSource = SQLOracle.SelectGetDS("SELECT " +
//" ID_GOST_82_P_T1 AS ГОСТ, INTERVAL_RAZMEROV, NAME_TABLE, " +
//" NUMBER_TABLE, P1, P10, " +
//" P11, P12, P13, " +
//" P14, P15, P16, " +
//" P17, P18, P19, " +
//" P2, P20, P21, " +
//" P22, P23, P24, " +
//" P25, P26, P27, " +
//" P28, P29, P3, " +
//" P30, P31, P32, " +
//" P33, P34, P35, " +
//" P36, P37, P38, " +
//" P39, P4, P40, " +
//" P41, P42, P43, " +
//" P44, P45, P46, " +
//" P47, P48, P49, " +
//" P5, P50, P51, " +
//" P52, P53, P54, " +
//" P55, P56, P57, " +
//" P6, P7, P8, " +
//" P9 " +
//" FROM AS_GOST_25347_82_P_T1").Tables[0];
}
private void button71_Click(object sender, EventArgs e)
{
SQLOracle.BuildConnectionString("ASPPR", "ASPPR", "BASEEOI", "192.168.1.170", "1521");
dataGridView1.DataSource = SQLOracle.SelectGetDS(" SELECT " +
" NOM_TABLE, IDSTROKI, NAME_IMAGE, " +
" OBOZN_RAZMER, RAZMFROM, RAZMTO, " +
" OTFROM, OTTO, NAME_TABLE " +
" FROM ASPPR.AS_OST_100022_80_1_4_6_11 ").Tables[0];
}