Hello to all , I am new at this coding...
My files explains everything . Just want to see the values at the right of the graph like AA - BB... I couldn't change it according coming from db. Just writes there "genelpuani"
my code :
My files explains everything . Just want to see the values at the right of the graph like AA - BB... I couldn't change it according coming from db. Just writes there "genelpuani"
my code :
| private void chart1_NeedDataSource(object sender, EventArgs e) |
| { |
| Telerik.Reporting.Processing.ReportItemBase itemBase = (Telerik.Reporting.Processing.ReportItemBase)sender; |
| int hastaID = int.Parse(itemBase.DataObject["HastaID"].ToString()); |
| int formid = int.Parse(itemBase.DataObject["formid"].ToString()); |
| Telerik.Reporting.Processing.Chart procChart = (Telerik.Reporting.Processing.Chart)sender; |
| string sql = @"SELECT kat.KategoriName as kategoriismi, genelpuan.Puan as genelpuani |
| FROM GenelPuanlama AS genelpuan INNER JOIN |
| Kategoriler AS kat ON genelpuan.KategoriID = kat.KategoriID WHERE (genelpuan.FormID='" + formid.ToString() + "') AND (genelpuan.HastaID ='" + hastaID.ToString() + "')"; |
| string connectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database.mdf;Integrated Security=True;User Instance=True"; |
| SqlDataAdapter adapter = new SqlDataAdapter(sql, connectionString); |
| DataTable datatable = new DataTable(); |
| adapter.Fill(datatable); |
| procChart.DataSource = datatable; |
| //chart1.IntelligentLabelsEnabled = true; |
| //chart1.PlotArea.XAxis.DataLabelsColumn = "kategoriismi"; |
| //chart1.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = 300; |
| chart1.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Color = System.Drawing.Color.DarkBlue; |
| chart1.PlotArea.Appearance.Dimensions.Margins.Bottom = Telerik.Reporting.Charting.Styles.Unit.Percentage(30); |
| } |