Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DataTable tempTable = new DataTable();
- tempTable.Columns.Add(new DataColumn("VendorName", Type.GetType("System.String")));
- tempTable.Columns.Add(new DataColumn("TotalCost", Type.GetType("System.Double")));
- tempTable.Columns.Add(new DataColumn("ProjectYear", Type.GetType("System.Int32")));
- tempTable.Columns.Add(new DataColumn("Q1Cost", Type.GetType("System.Double")));
- tempTable.Columns.Add(new DataColumn("Q2Cost", Type.GetType("System.Double")));
- tempTable.Columns.Add(new DataColumn("Q3Cost", Type.GetType("System.Double")));
- tempTable.Columns.Add(new DataColumn("Q4Cost", Type.GetType("System.Double")));
- DataRow dRow = tempTable.NewRow();
- foreach (DataRow row in bCase.TblHwSwOtherForecast.Rows)
- {
- if (dRow["VendorName"] == null)
- {
- dRow["VendorName"] = row["VendorName"];
- dRow["TotalCost"] = row["TotalCost"];
- dRow["ProjectYear"] = row["ProjectYear"];
- }
- else
- {
- switch (row["Quarter"].ToString())
- {
- case "1":
- dRow["Q1Cost"] = row["Cost"];
- break;
- case "2":
- dRow["Q2Cost"] = row["Cost"];
- break;
- case "3":
- dRow["Q3Cost"] = row["Cost"];
- break;
- case "4":
- dRow["Q4Cost"] = row["Cost"];
- tempTable.Rows.Add(dRow);
- dRow["VendorName"] = null;
- break;
- }
- }
Add Comment
Please, Sign In to add comment