Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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";
- 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";
- dbObject.openDB();
- int sumPaket = 0;
- OdbcDataReader myReader_order = dbObject.getDataReader(sqlorder);
- OdbcDataReader myReader_no = dbObject.getDataReader(sqlno);
- while ((myReader_order.Read()) && (myReader_no.Read()))
- {
- //Kontakter
- LiteralStat.Text = LiteralStat.Text + "<tr><td>" + "Kontakter" + "</td>";
- LiteralStat.Text = LiteralStat.Text + "<td>" + int.Parse(myReader_order["call_status_antal"].ToString()) + int.Parse(myReader_no["call_status_antal"].ToString()) + "</td></tr>";
Advertisement
Add Comment
Please, Sign In to add comment