this cod can draw candlestick chart ! i did pay 3$ to andrestand it !! :-)
DataSet ds = new DataSet();
chart1 = new Chart();
SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=xxxx;Initial Catalog=xxxx;Integrated Security=True";
con.Open();
string sql = "Select * from xxxx ";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter sa = new SqlDataAdapter();
sa.SelectCommand = cmd;
sa.Fill(ds);
con.Close();
chart1.Series["Daily"].ChartType = SeriesChartType.Candlestick;
chart1.DataSource = sa;
chart1.Series["Daily"].XValueMember = "Date";
chart1.Series["Daily"].YValueMembers = "ghbishtarin, ghkamtarin, ghopen, ghclose";
chart1.DataBind();
chart1.Series["Daily"].BorderColor = System.Drawing.Color.Black;
chart1.Series["Daily"].Color = System.Drawing.Color.Black;
chart1.Series["Daily"].CustomProperties = "PriceDownColor=Green, PriceUpColor=Red";
chart1.Series["Daily"].XValueType = ChartValueType.Date;
chart1.ChartAreas[0].AxisX.MajorGrid.LineWidth = 0;
chart1.ChartAreas[0].AxisY.MajorGrid.LineWidth = 0;
chart1.ChartAreas[0].AxisY.Minimum = 0;
chart1.ChartAreas[0].AxisY.Maximum = 210;
chart1.DataManipulator.IsStartFromFirst = true;