Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- OracleConnection conn = new OracleConnection(CONNECTION_STRING);
- conn.Open();
- OracleCommand cmd = new OracleCommand();
- cmd.Connection = conn;
- cmd.CommandText = "SELECT IAWAPP.TO_TSWDCIM.CON_IDR, IAWAPP.TO_TSWDCIM.STA_DTE, IAWAPP.TO_TSWDCIM.SCA_LOC, IAWAPP.TO_TSWDCIM.STA_DTE, IAWAPP.TO_TSWDCIM.DOC_IMG_BIN, IAWAPP.TO_TSWDCIM.BTC_DIS, IAWAPP.TRIAGE_CASE.BUSINESS_OUR_REF FROM IAWAPP.TO_TSWDCIM, IAWAPP.TRIAGE_CASE WHERE IAWAPP.TO_TSWDCIM.CON_IDR = IAWAPP.TRIAGE_CASE.ORIGINAL_CONTACT_ID AND IAWAPP.TO_TSWDCIM.STA_DTE > sysdate -1 AND IAWAPP.TO_TSWDCIM.IMG_SRC = SCAN AND ORDER IAWAPP.TO_TSWDCIM.STA_DTE";
- cmd.CommandType = CommandType.Text;
- dataGridView1.AutoGenerateColumns = true;
- DataSet ds = new DataSet();
- OracleDataAdapter adapter = new OracleDataAdapter();
- adapter.SelectCommand = cmd;
- adapter.Fill(ds);
- dataGridView1.DataSource = ds.Tables[0];
- conn.Dispose();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement