How to bind Data to Pie Chart

[radhi]

Hi,

how can i bind the data from stored procedure(stored procedure is creatred in sqlserver2000) to pie . Iam using chartfx 7 and Visual studio 2005

Thanks

Radhi

[Frank]

The same way you bind any other type of chart. The wizard will guide you through it.

Each numeric column in your resultset will generate a Pie and there will be one slice for each record (row).

[radhi]

Thank you. I am trying to bind the data dynamically and the sored procedure takes a parameter .

here is my sample code:

comm = New SqlCommand()

sqlConn.Open()

comm.CommandText =

"usp_Sandwichsite"

comm.Connection = sqlConn

comm.CommandType = Data.CommandType.StoredProcedure

comm.Parameters.Add("city", Data.SqlDbType.NVarChar).Value = city

comm.Parameters(0).Direction = Data.ParameterDirection.Input

da = New SqlDataAdapter(comm)ds = New Data.DataSet("tabl")

da.Fill(ds)

Chart1.DataSourceSettings.Fields.Add(

New FieldMap("rooms", FieldUsage.XValue))Chart1.DataSourceSettings.Fields.Add(New FieldMap("func", FieldUsage.Value))Chart1.DataSourceSettings.Fields.Add(New FieldMap("maxused", FieldUsage.XValue))

Chart1.DataSourceSettings.DataSource = ds.tables(0).DefaultView

Chart1.DataBind()

when i execute the above code i get "No Data is available"

 

[radhi]

thank you , i found the solution to my problem . I have another question . My stored procedure returns 3 columns(Func, Rooms, Maxused) .

because of this, there are two pie charts that gets displayed  - One func vs rooms and another Maxused Vs Func

Now i want only one pie chart(Func Vs Maxused) and the rooms should be displayed as lablel next to func  .How can I acheive this

Thanks in Advance

Radhi

[Frank]

You must add the values (the column that gives the pie slice its size) as FieldUsage.Value and the labels as FieldUsage.Label.

[radhi]

Thank you , It is working