or
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); |
} |
Private Sub locationIDGroupHeader_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles locationIDGroupHeader.ItemDataBound |
Dim section As Telerik.Reporting.Processing.GroupSection = DirectCast(sender, Telerik.Reporting.Processing.GroupSection) |
Dim row As System.Data.DataRow = DirectCast(section.DataObject.RawData, System.Data.DataRow) |