[How to bind Data to Pie Chart]

Thank you , It is working

[separate a slice from a pie]

Hi ,

  how to separate a slice from pie on click of that slice

 

Thanks

Radhi

[How to bind Data to Pie Chart]

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

[How to bind Data to Pie Chart]

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"

 

[How to bind Data to Pie Chart]

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