how to sum multiple sql statements in C#? RSS

• • Reply
  

  jylland

  Member

  44 Points

  48 Posts

  how to sum multiple sql statements in C#?

  Dec 04, 2012 09:54 PM|LINK

  hi
  
  I have a problem
  
  I want to have a total sum of the detail sum

  one.SelectCommand = "SELECT SUM as ....
  two.SelectCommand = "SELECT SUM as ....
  
  I want label.text =  (one + two)
  
  But how can I put number two into this statement ?
  
  DataView dvSql = (DataView)one.Select(DataSourceSelectArguments.Empty);
  
  foreach (DataRowView drvSql in dvSql)
          {

              Label.Text = Convert.ToDecimal(drvSql["one"]).ToString("F2");

          }

         

  
  

  • Edited by jylland on Dec 11, 2012 03:34 PM
  • Edited by jylland on Dec 11, 2012 03:42 PM
  • Edited by jylland on Dec 11, 2012 06:16 PM
• • Reply
  

  sen338

  Member

  498 Points

  118 Posts

  Re: how to sum multiple sql statements in C#?

  Dec 04, 2012 10:47 PM|LINK

  int i =0;

  DataView dvSql = (DataView)one.Select(DataSourceSelectArguments.Empty); foreach (DataRowView drvSql in dvSql)         {

             i = i + Convert.ToDecimal(drvSql["one"]).ToString("F2");

   i =  i +  Convert.ToDecimal(drvSql["two"]).ToString("F2");

          }

   Label.Text = i.ToString()

  Please mark the replies as answers if they help or unmark if not.
  
  • Edited by jylland on Dec 05, 2012 04:59 PM
  • Edited by jylland on Dec 11, 2012 03:19 PM
  • Edited by sen338 on Dec 11, 2012 03:34 PM
  • Edited by sen338 on Dec 11, 2012 03:42 PM
  • Edited by sen338 on Dec 11, 2012 06:16 PM
• • Reply
  

  jylland

  Member

  44 Points

  48 Posts

  Re: how to sum multiple sql statements in C#?

  Dec 11, 2012 03:33 PM|LINK

  this way

   

  One.SelectCommand="Select sum() as....................";

  DataView dvSql = (DataView)one.Select(DataSourceSelectArguments.Empty);
  foreach (DataRowView drvSql in dvSql)

  {

   int i =0;
   i = i + Convert.ToDecimal(drvSql["one"]);
   Label.Text = i.ToString()

  }

  • Edited by jylland on Dec 11, 2012 03:33 PM
  • Edited by jylland on Dec 11, 2012 03:34 PM
  • Edited by jylland on Dec 11, 2012 03:38 PM
  • Edited by jylland on Dec 11, 2012 03:42 PM
  • Edited by jylland on Dec 11, 2012 04:22 PM
  • Edited by jylland on Dec 11, 2012 06:16 PM
• • Reply
  

  jylland

  Member

  44 Points

  48 Posts

  Re: how to sum multiple sql statements in C#?

  Dec 11, 2012 03:55 PM|LINK

  why can I not this here ???
  
  I get this error for the DataView dvSql2: Embedded statement cannot be a declaration og labeled statement
  
  My code

  One.SelectCommand="Select sum() as....................";
  Two.Selectcommand="Select sum() as....................";

  DataView dvSql = (DataView)one.Select(DataSourceSelectArguments.Empty); foreach (DataRowView drvSql in dvSql)
  
  DataView dvSql2 = (DataView)two.Select(DataSourceSelectArguments.Empty); foreach(DataRowView drvSql2 in dvSql2)

  {

  int i = 0;

  i = i + Convert.ToDecimal(drvSql["column"]);

  i =  i +  Convert.ToDecimal(drvSql2["column"]);

  Label.Text = i.ToString()

  }

  • Edited by jylland on Dec 11, 2012 03:55 PM
  • Edited by jylland on Dec 11, 2012 04:12 PM
  • Edited by jylland on Dec 11, 2012 04:12 PM
  • Edited by jylland on Dec 11, 2012 04:21 PM
  • Edited by jylland on Dec 11, 2012 04:23 PM
  • Edited by jylland on Dec 11, 2012 04:24 PM
  • Edited by jylland on Dec 11, 2012 04:26 PM
  • Edited by jylland on Dec 11, 2012 04:26 PM
  • Edited by jylland on Dec 11, 2012 05:26 PM
  • Edited by jylland on Dec 11, 2012 05:57 PM
  • Edited by jylland on Dec 11, 2012 06:16 PM