[DotNetDevelopment] Re: C# and ORACLE 10g

[Hossam Tebry]

Here it is the button click event handler
 private void button1_Click(object sender, EventArgs e)
        {
            this.oracleSelectCommand3.CommandText = "alter session set
nls_date_format = \"dd/mm/yyyy\"; SELECT CMPWRD, TOTAL_BOOKED,
NO_SHOW, GRP_NOSH, STNDBY_OUT, UPGD_INTO, UPGD_OUTOF, DNBDG, ORGNWRD,
DSTNWRD FROM "+
                "(SELECT case CMPWRD WHEN 'F ' THEN 'a' WHEN 'C ' THEN
'b' WHEN 'Y ' THEN 'c' ELSE cmpwrd END AS cmporder, cmpwrd,"+
                " SUM(UTL_RAW.CAST_TO_BINARY_INTEGER(substr(show, 1,
2))) AS \"TOTAL_BOOKED\", "+
                "SUM(UTL_RAW.CAST_TO_BINARY_INTEGER(substr(DPTDATA, 1,
2))) AS \"NO_SHOW\","+
                " SUM(UTL_RAW.CAST_TO_BINARY_INTEGER(substr(DPTDATA,
3, 2))) AS \"GRP_NOSH\","+
                " SUM(UTL_RAW.CAST_TO_BINARY_INTEGER(substr(DPTDATA,
7, 2))) AS \"STNDBY_OUT\", "+
                "SUM(UTL_RAW.CAST_TO_BINARY_INTEGER(substr(DPTDATA,
11, 2))) AS \"UPGD_INTO\", "+
                "SUM(UTL_RAW.CAST_TO_BINARY_INTEGER(substr(DPTDATA,
13, 2))) AS \"UPGD_OUTOF\","+
                " SUM(UTL_RAW.CAST_TO_BINARY_INTEGER(substr(DPTDATA,
19, 2))) AS \"DNBDG\", ORGNWRD, DSTNWRD"+
                " FROM MSLIVE_BKGSEGCLS WHERE (CRRWRD = 'MS ') AND
(ORGNWRD = '" + textBox1.Text + "  " + "') AND (DSTNWRD = '" +
textBox2.Text + "  " + "') AND (DPTDATE BETWEEN '" +
monthCalendar1.SelectionStart.ToShortDateString() + "' AND
'"+monthCalendar2.SelectionStart.ToShortDateString() +"') "+
                "GROUP BY cmpwrd, ORGNWRD, DSTNWRD ORDER BY
cmporder);";

            DataSet ds = new DataSet();

            oracleDataAdapter3.ContinueUpdateOnError = true;
            this.oracleDataAdapter3.Fill(ds);
            this.dataGridView2.DataSource = ds;
        }