private void Page_Load(object sender, System.EventArgs e) { if (Page.IsPostBack==false) { DataSet dataSet = GetDataSet(); if (dataSet!=null) { //Setup Chart SmoothLineChart chart = new SmoothLineChart(); chart.Line.Color=Color.CornflowerBlue; chart.DataSource=dataSet.Tables[0].DefaultView; chart.DataXValueField="title_id"; chart.DataYValueField="price"; chart.DataBind(); ChartCtl.Charts.Add(chart); ChartCtl.XAxisFont.StringFormat.FormatFlags = StringFormatFlags.DirectionVertical; ChartCtl.RedrawChart(); } } } private DataSet GetDataSet() { SqlConnection connection = new SqlConnection( ConfigurationSettings.AppSettings["ConnectionString"]) ; SqlDataAdapter adapter = new SqlDataAdapter("select title_id, price from titles", connection); DataSet dataSet = new DataSet(); connection.Open(); try { adapter.Fill(dataSet); } finally { if (connection !=null) connection.Close(); } return dataSet; }