From Grid view how to display records using chart in asp.net using C#

See more:

C#

My code as follows;

i show button i written the below code as follows;

sql = "SELECT distinct fa.facname,r.rate,f.bthid,CASE  WHEN r.rate = '1' THEN '100' WHEN r.rate = '2' THEN '75' 	WHEN r.rate = '3' THEN '50' WHEN r.rate = '4' THEN '25' ELSE '0' END AS TranslatedRate FROM bthfac AS f,batch AS b, faculty AS fa,facfeedback AS r where month(b.examdate)= '" + Ddlmonth.Text.ToString() + "' and  year(b.examdate)= '" + DropDownList2.Text.ToString() + "' and  r.bfid=f.bfid and b.bthid=f.bthid and fa.facname = '" + DropDownList3.Text.ToString().Trim() + "'";
            dr = scon.ReadSql(sql);
            GridView3.DataSource = dr;
            GridView3.DataBind();
            GridView3.Visible = true;

in run mode as follows;


Month Dropdownlist1
Year Dropdownlist2
Faculty Dropdownlist3


in run mode i select the month from the dropdwonlist1 and year from the dropdwonlist2 and select the Faculty from the dropwdownlist3.


then i click the show button the records will display in gridview as follows;

in Gridview records as folllows;

Rate Batchid Translated_Rate Name

0 13 0 RK
3 13 50 RK
4 9 25 RK
1 8 100 RK
4 14 25 RK
1 6 100 RK
2 24 75 RK
2 12 75 RK
4 4 25 RK
1 13 100 RK


i want to show the above gridview records using chart using asp.net with c#

in chart i want the output as follows;

in chart in X Asix i want to display the Name from the gridiview
in chart in y Axis i want to display the Rate from the gridview

for that how can i do in asp.net using C#.

note it is web application.

Please help me.

REgards,
Narasiman P.