Advertisement
Guest User

Untitled

a guest
Apr 16th, 2014
36
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. OracleConnection conn = new OracleConnection(CONNECTION_STRING);
  2. conn.Open();
  3. OracleCommand cmd = new OracleCommand();
  4. cmd.Connection = conn;
  5. 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";
  6. cmd.CommandType = CommandType.Text;
  7. dataGridView1.AutoGenerateColumns = true;
  8. DataSet ds = new DataSet();
  9. OracleDataAdapter adapter = new OracleDataAdapter();
  10. adapter.SelectCommand = cmd;
  11. adapter.Fill(ds);
  12. dataGridView1.DataSource = ds.Tables[0];
  13. conn.Dispose();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement