pie chart is not visible

Subin Thomas

7y1.8k.NET

i have code for a pie chart but ehn i run i cant see the pie chartit showig white box when i drag the pie chart area the code is below plz help me

"Chart1" runat="server" ImageType="Jpeg">
"Series1" ChartType="Pie" IsValueShownAsLabel="True">
"ChartArea1">
"True" LightStyle="Realistic" />

and the code behind is :

SqlConnection con = new SqlConnection(ppd);
SqlCommand cmd = new SqlCommand("Some query, con);
cmd.Parameters.AddWithValue("@userid", output);
Series series = Chart1.Series["Series1"];
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
series.Points.AddXY(rdr["schemeid"].ToString(), rdr["scheme"]);
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

alice yang7y ago
Hi,

Free Spire. XLS(https://www.nuget.org/packages/FreeSpire.XLS/) would make it an easy work. See below code to use the data from database to create a pie chart.
//connect to sql and get the datatable
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection(ppd);
SqlCommand cmd = new SqlCommand("Some query", con);
SqlDataAdapter adapter = new SqlDataAdapter(com);
adapter.Fill(dt);

//create an Excel
Workbook book = new Workbook();
Worksheet sheet1 = book.Worksheets(0);
sheet1.Name = "Pie chart";
sheet1.InsertDataTable(dt, false, 1, 1);
//Add pie chart
Chart chart = sheet1.Charts.Add(ExcelChartType.Pie3D);
chart.ChartType = ExcelChartType.ColumnClustered;
chart.DataRange = sheet1.AllocatedRange;
chart.SeriesDataFromRange = false;
chart.Height = 220;
chart.Width = 450;
chart.Left = 0;
chart.Top = 100;
Spire.Xls.Charts.ChartSerie cs = chart.Series(0);

// Chart Labels resource
cs.CategoryLabels = sheet1.Range(("A1:A" + sheet1.LastRow));
// Chart value resource
cs.Values = sheet1.Range(("B1:B" + sheet1.LastColumn));
// Save file
book.SaveToFile(excelfilePath, ExcelVersion.Version2010);
Salman Beg7y ago
Hi.
First Check are you getting data in SqlDataReader.
Check might be you are getting error.
Put try catch block with debugger and check line by line.
Thanks.
Subin Thomas7y ago
tried Raja not working it is not visible
Raja T7y ago
Hi, can you please refer below links

https://www.c-sharpcorner.com/UploadFile/rahul4_saxena/showing-chart-in-Asp-Net-with-data-base/

https://www.aspsnippets.com/Articles/Populate-Bar-and-Column-Charts-from-database-using-ASPNet-Chart-control.aspx

http://www.dotnetfox.com/articles/bind-Asp-Net-chart-control-from-database-using-C-Sharp-1056.aspx