Multi Column Header | Infragistics Forums

Hi Divya Jain,

I followed the sample "MultiColumnHeader".But still i am not able to see the grid data.

I have set AutoGenerateColumns="false".

Below it the snippet:

wdg.ClearDataSource();
wdg.DataSource = BuildData(dt);
wdg.DataMember = dt.TableName;
wdg.DataBind();

private List<PCIData> BuildData(DataTable dt)
{
List<PCIData> data = new List<PCIData>();
PCIData pciData = new PCIData();
foreach (DataRow row in dt.Rows)
{

pciData.ProjectName = row.Field<string>("PROJECTNAME");

string plannedStartDate = string.Empty;
string plannedEnddate = string.Empty;

if (row["PLANSTARTDATE"] == System.DBNull.Value)
{
plannedStartDate = "";
}
else
{
plannedStartDate = Convert.ToDateTime(row["PLANSTARTDATE"]).ToString("dd-MMM-yyyy");
}

if (row["PLANENDDATE"] == System.DBNull.Value)
{
plannedEnddate = "";
}
else
{
plannedEnddate = Convert.ToDateTime(row["PLANENDDATE"]).ToString("dd-MMM-yyyy");
}

pciData.StartDate = plannedStartDate;
pciData.EndDate = plannedEnddate;

if (row.Field<string>("MONTH") == "January")
{
pciData.janMonth = "January";
pciData.janInitial = Convert.ToString(row["PCIINITIAL"]);
pciData.janFinal = Convert.ToString(row["PCIFINAL"]);
pciData.janHQFinal = Convert.ToString(row["HQFINAL"]);

}
else if (row.Field<string>("MONTH") == "February")
{
pciData.febMonth = "February";
pciData.febInitial = Convert.ToString(row["PCIINITIAL"]);
pciData.febFinal = Convert.ToString(row["PCIFINAL"]);
pciData.febHQFinal = Convert.ToString(row["HQFINAL"]);

}
else if (row.Field<string>("MONTH") == "March")
{
pciData.marMonth = "March";
pciData.marInitial = Convert.ToString(row["PCIINITIAL"]);
pciData.marFinal = Convert.ToString(row["PCIFINAL"]);
pciData.marHQFinal = Convert.ToString(row["HQFINAL"]);

}
else if (row.Field<string>("MONTH") == "April")
{
pciData.aprMonth = "April";
pciData.aprInitial = Convert.ToString(row["PCIINITIAL"]);
pciData.aprFinal = Convert.ToString(row["PCIFINAL"]);
pciData.aprHQFinal = Convert.ToString(row["HQFINAL"]);

}
else if (row.Field<string>("MONTH") == "May")
{
pciData.mayMonth = "May";
pciData.mayInitial = Convert.ToString(row["PCIINITIAL"]);
pciData.mayFinal = Convert.ToString(row["PCIFINAL"]);
pciData.mayHQFinal = Convert.ToString(row["HQFINAL"]);

}
else if (row.Field<string>("MONTH") == "June")
{
pciData.juneMonth = "June";
pciData.juneInitial = Convert.ToString(row["PCIINITIAL"]);
pciData.juneFinal = Convert.ToString(row["PCIFINAL"]);
pciData.juneHQFinal = Convert.ToString(row["HQFINAL"]);

}
else if (row.Field<string>("MONTH") == "July")
{
pciData.julyMonth = "July";
pciData.julyInitial = Convert.ToString(row["PCIINITIAL"]);
pciData.julyFinal = Convert.ToString(row["PCIFINAL"]);
pciData.julyHQFinal = Convert.ToString(row["HQFINAL"]);

}

else if (row.Field<string>("MONTH") == "August")
{
pciData.augMonth = "August";
pciData.augInitial = Convert.ToString(row["PCIINITIAL"]);
pciData.augFinal = Convert.ToString(row["PCIFINAL"]);
pciData.augHQFinal = Convert.ToString(row["HQFINAL"]);

}
else if (row.Field<string>("MONTH") == "September")
{
pciData.sepMonth = "September";
pciData.sepInitial = Convert.ToString(row["PCIINITIAL"]);
pciData.sepFinal = Convert.ToString(row["PCIFINAL"]);
pciData.sepHQFinal = Convert.ToString(row["HQFINAL"]);

}
else if (row.Field<string>("MONTH") == "October")
{
pciData.octMonth = "October";
pciData.octInitial = Convert.ToString(row["PCIINITIAL"]);
pciData.octFinal = Convert.ToString(row["PCIFINAL"]);
pciData.octHQFinal = Convert.ToString(row["HQFINAL"]);

}
else if (row.Field<string>("MONTH") == "November")
{
pciData.novMonth = "November";
pciData.novInitial = Convert.ToString(row["PCIINITIAL"]);
pciData.novFinal = Convert.ToString(row["PCIFINAL"]);
pciData.novHQFinal = Convert.ToString(row["HQFINAL"]);

}
else if (row.Field<string>("MONTH") == "December")
{
pciData.decMonth = "December";
pciData.decInitial = Convert.ToString(row["PCIINITIAL"]);
pciData.decFinal = Convert.ToString(row["PCIFINAL"]);
pciData.decHQFinal = Convert.ToString(row["HQFINAL"]);

}

}
data.Add(pciData);
return data;
}