i try to do some different charts with asp.net and really data to show in my company for try to buy the soft for our intranet. I did a pie 3d and all work ok but now i have a big problem because i need a stacked chart, i make my code help me with source on internet. I have a similar source that a code that run ok but my code not run correctly i receive the message "no data to display"..please i need help thanks...this is my source
clsMain obj = new clsMain();
DataTable objDt = obj.GetEstadistica_EstadosTipoPedido();
#region GeneraGrafico
StringBuilder xmlData = new StringBuilder();
xmlData.Append("<chart caption='Sales' numberPrefix='$' formatNumberScale='0'>");
#region Crea el eje de tipos de pedido
xmlData.Append("<tipos>");
DataTable dtTiposPedido = objDt.DefaultView.ToTable(true, "tipopedido");
foreach (DataRow Row in dtTiposPedido.Rows)
{
xmlData+= "<tipopedido name='" + Row["tipopedido"].ToString().Trim() + "' />";
}
xmlData.Append("</tipos>");
#endregion
#region Crea el eje de estados
DataTable dtEstados = objDt.DefaultView.ToTable(true, "estadodesc");
DataView objDv = objDt.DefaultView;
foreach (DataRow Row in dtEstados.Rows)
{
xmlData.Append("<dataset seriesName='" + Row["estadodesc"].ToString().Trim() + "'>");
foreach (DataRow Row2 in dtTiposPedido.Rows )
{
objDv.RowFilter = "tipopedido='" + Row2["tipopedido"].ToString().Trim() + "' and estadodesc='" + Row["estadodesc"].ToString().Trim() + "'";
if (objDv.Count > 0)
xmlData.AppendFormat("<set value='{0}' />", objDv[0]["cantidad"].ToString());
else
xmlData.AppendFormat("<set value='{0}' />", "1");
}
xmlData.Append("</dataset>");
}
#endregion
xmlData.Append("</chart>");
Literal1.Text = FusionCharts.RenderChart("Charts/StackedColumn3D.swf", "", xmlData.ToString(), "EstadosTipoPedido", "600", "300", false, true);