Guest User

Untitled

a guest
Jun 21st, 2012
59
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.         string sqlorder = "select call_status_desc,call_status_antal from XXX_orders_campaign_stat where exportid = " + TextBoxExportID.Text + " and call_Status_desc in ('order') group by call_status_desc,call_status_antal";
  2.         string sqlno = "select call_status_desc,call_status_antal from XXX_orders_campaign_stat where exportid = " + TextBoxExportID.Text + " and call_Status_desc in ('Nej Tack (Glöm inte kommentar!)') group by call_status_desc,call_status_antal";
  3.  
  4.         dbObject.openDB();
  5.         int sumPaket = 0;
  6.         OdbcDataReader myReader_order = dbObject.getDataReader(sqlorder);
  7.         OdbcDataReader myReader_no = dbObject.getDataReader(sqlno);
  8.  
  9.  
  10.  
  11.         while ((myReader_order.Read()) && (myReader_no.Read()))
  12.         {
  13.             //Kontakter
  14.             LiteralStat.Text = LiteralStat.Text + "<tr><td>" + "Kontakter" + "</td>";
  15.             LiteralStat.Text = LiteralStat.Text + "<td>" + int.Parse(myReader_order["call_status_antal"].ToString()) + int.Parse(myReader_no["call_status_antal"].ToString()) + "</td></tr>";
RAW Paste Data