Guest User

Untitled

a guest
May 22nd, 2018
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.44 KB | None | 0 0
  1. DataTable tempTable = new DataTable();
  2. tempTable.Columns.Add(new DataColumn("VendorName", Type.GetType("System.String")));
  3. tempTable.Columns.Add(new DataColumn("TotalCost", Type.GetType("System.Double")));
  4. tempTable.Columns.Add(new DataColumn("ProjectYear", Type.GetType("System.Int32")));
  5. tempTable.Columns.Add(new DataColumn("Q1Cost", Type.GetType("System.Double")));
  6. tempTable.Columns.Add(new DataColumn("Q2Cost", Type.GetType("System.Double")));
  7. tempTable.Columns.Add(new DataColumn("Q3Cost", Type.GetType("System.Double")));
  8. tempTable.Columns.Add(new DataColumn("Q4Cost", Type.GetType("System.Double")));
  9. DataRow dRow = tempTable.NewRow();
  10.  
  11. foreach (DataRow row in bCase.TblHwSwOtherForecast.Rows)
  12. {
  13.     if (dRow["VendorName"] == null)
  14.     {
  15.         dRow["VendorName"] = row["VendorName"];
  16.         dRow["TotalCost"] = row["TotalCost"];
  17.         dRow["ProjectYear"] = row["ProjectYear"];
  18.     }
  19.     else
  20.     {
  21.         switch (row["Quarter"].ToString())
  22.         {
  23.             case "1":
  24.                 dRow["Q1Cost"] = row["Cost"];
  25.                 break;
  26.  
  27.             case "2":
  28.                 dRow["Q2Cost"] = row["Cost"];
  29.                 break;
  30.  
  31.             case "3":
  32.                 dRow["Q3Cost"] = row["Cost"];
  33.                 break;
  34.  
  35.             case "4":
  36.                 dRow["Q4Cost"] = row["Cost"];
  37.                 tempTable.Rows.Add(dRow);
  38.                 dRow["VendorName"] = null;
  39.                 break;
  40.         }
  41.     }
Add Comment
Please, Sign In to add comment