by JBrooks
8. November 2010 11:04
I needed to display some parent data with it’s child data on the same row like shown in the image above. I happen to be combining a few tables together into a new table (called dtPlan) and then binding the GridView to that new table. So this was my approach while moving the data into the dtPlan table. dtRampRates is the child table to the data in dtResults.
DataView dvRampRates = new DataView(dtRampRates);
dvRampRates.Sort = "parentId, id";
StringBuilder sb = new StringBuilder();
for (int indexRow = 0; indexRow < dtResults.Rows.Count; indexRow++)
{
DataRow drPlan = dtPlan.NewRow();
drPlan["c0"] = planHour;
drPlan["c1"] = dtResults.Rows[indexRow]["ResourceStatus"].ToString();
drPlan["c2"] = dtResults.Rows[indexRow]["MinEconomicMW"].ToString();
drPlan["c3"] = dtResults.Rows[indexRow]["MaxEconomicMW"].ToString();
dvRampRates.RowFilter = "parentId=" + dtResults.Rows[indexRow]["id"].ToString();
sb.Length = 0;
sb.Append("<table cellspacing='0' class='RampRate'>");
if (indexRow == 0)
sb.Append("<tr><td>Limit</td><td>Up</td><td>Down</td></tr>");
for (int i = 0; i < dvRampRates.Count; i++)
{
sb.Append("<tr><td>");
sb.Append(dvRampRates[i]["breakpointLimit"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(dvRampRates[i]["rampRateUp"].ToString());
sb.Append("</td>");
sb.Append("<td>");
sb.Append(dvRampRates[i]["rampRateDown"].ToString());
sb.Append("</td></tr>");
}
sb.Append("</table>");
drPlan["c4"] = sb.ToString();
dtPlan.Rows.Add(drPlan);
}
gvPlan.DataSource = dtPlan;
gvPlan.DataBind();
The child grid is made in the “for” loop. Normally you would have this loop in the RowDataBound event for the GridView. With that approach it is easy to see how most of the code would be the same.
Subscribe