Community discussion forum

Total Sum Value of columns as header row by "LabourID" in gridview

• • Reply

  4 months ago

  by kcns

  Khin Chan Nyein Su

  Rangoon, Myanmar

  Joined 5 months ago

  The GridView columns are as follow:

  The result must be: .................................................................................................................................................. LabourID | Name | Event Name| Working Date | Normal(Hr) | Amt(N) | .... | Total ..................|.............|........................|..........................|.......................|...............|........|............ 009 |ET | All | All | 5 | 35.0 | ... |95.0 --->Sum of each column by laborID ..................|.............|........................|..........................|.......................|...............|........|............ | | Meeting | 10 Jul 09 | 2 | 20.0 | ... |60.0 ..................|.............|........................|..........................|.......................|...............|........|............ | | Seminar | 13 Jul 09 | 3 | 15.0 | ... | 35.0 ..................|.............|........................|..........................|.......................|...............|........|............ 002 |Sue | All | All | 6 | 18.0 | ... |40.0
  ..................|.............|........................|..........................|.......................|...............|........|............ | | Promotion | 23 Jul 09 | 6 | 18.0 | ... |40.0 ..................|.............|........................|..........................|.......................|...............|........|............

  I'm writing the code as follow:

   void GetDataTable(DataTable tempDT)
      {
          DataTable dt_FromDB = tempDT;
          DataTable dt_Grid = Grid_Table;
   //       DataRow adr = new DataRow();
  
          decimal nHour=0;
          decimal nRate=0;
          decimal eHour=0;
          decimal eRate=0;
          decimal hHour=0;
          decimal hRate=0;
          decimal wHour=0;
          decimal wRate=0;
          decimal allow=0;
          decimal total=0;
  
          string labourNRIC = "";
          string checkLabourNRIC = "";
  
  
          foreach (DataRow dr_FromDB in dt_FromDB.Rows)
          {
              //string NRIC=dr_FromDB["NRIC"].ToString();
              //while(dt_FromDB.Select("NRIC="+NRIC))
              //{
              if(dr_FromDB["NRIC"].ToString()==labourNRIC || labourNRIC=="")
              {
                  nHour += Convert.ToDecimal(dr_FromDB["NormalHour"].ToString());
                  nRate += Convert.ToDecimal(dr_FromDB["NormalRate"].ToString());
                  eHour += Convert.ToDecimal(dr_FromDB["ExtraHour"].ToString());
                  eRate += Convert.ToDecimal(dr_FromDB["ExtraRate"].ToString());
                  hHour += Convert.ToDecimal(dr_FromDB["HolidayHour"].ToString());
                  hRate += Convert.ToDecimal(dr_FromDB["HolidayRate"].ToString());
                  wHour += Convert.ToDecimal(dr_FromDB["WeekEndHour"].ToString());
                  wRate += Convert.ToDecimal(dr_FromDB["WeekEndRate"].ToString());
                  allow += Convert.ToDecimal(dr_FromDB["Allowance"].ToString());
                  total += Convert.ToDecimal(dr_FromDB["Total"].ToString());
              }
  
              if (dr_FromDB["NRIC"].ToString() != checkLabourNRIC)
              {
                  labourNRIC = dr_FromDB["NRIC"].ToString();
  
                  DataRow dr_Grid = dt_Grid.NewRow();
                  dr_Grid["NRIC"] = dr_FromDB["NRIC"].ToString();
                  dr_Grid["LabourName"] = dr_FromDB["LabourName"].ToString();
                  dr_Grid["EventNameOrDutyRoster"] = "All";
                  dr_Grid["WorkingDate"] = "All";
                  dr_Grid["NormalHour"] = nHour;
                  dr_Grid["NormalRate"] = nRate;
                  dr_Grid["ExtraHour"] = eHour;
                  dr_Grid["ExtraRate"] = eRate;
                  dr_Grid["HolidayHour"] = hHour;
                  dr_Grid["HolidayRate"] = hRate;
                  dr_Grid["WeekEndHour"] = wHour;
                  dr_Grid["WeekEndRate"] = wRate;
                  dr_Grid["Allowance"] = allow;
                  dr_Grid["Total"] = total;
                  dt_Grid.Rows.Add(dr_Grid);
                  ViewState["Grid"] = dt_Grid;
              }
  
              if (dr_FromDB["NRIC"].ToString() == labourNRIC)
              {
                  DataRow dr_Grid = dt_Grid.NewRow();
                  dr_Grid["EventNameOrDutyRoster"] = dr_FromDB["EventNameOrDutyRoster"].ToString();
                  dr_Grid["WorkingDate"] = dr_FromDB["WorkingDate"].ToString();
                  dr_Grid["NormalHour"] = dr_FromDB["NormalHour"].ToString();
                  dr_Grid["NormalRate"] = dr_FromDB["NormalRate"].ToString();
                  dr_Grid["ExtraHour"] = dr_FromDB["ExtraHour"].ToString();
                  dr_Grid["ExtraRate"] = dr_FromDB["ExtraRate"].ToString();
                  dr_Grid["HolidayHour"] = dr_FromDB["HolidayHour"].ToString();
                  dr_Grid["HolidayRate"] = dr_FromDB["HolidayRate"].ToString();
                  dr_Grid["WeekEndHour"] = dr_FromDB["WeekEndHour"].ToString();
                  dr_Grid["WeekEndRate"] = dr_FromDB["WeekEndRate"].ToString();
                  dr_Grid["Allowance"] = dr_FromDB["Allowance"].ToString();
                  dr_Grid["Total"] = dr_FromDB["Total"].ToString();
                  dr_Grid["Type"] = dr_FromDB["Type"].ToString();
                  dt_Grid.Rows.Add(dr_Grid);
                  ViewState["Grid"] = dt_Grid;
  
                  checkLabourNRIC = labourNRIC;
              }
  
          }
  

  How shall I continue this code? Thanks for your help.

  Post was edited on 22/07/2009 03:49:31 Report abuse