voila mon code:
protected void Button2_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["supervisionConnectionString2"].ConnectionString);
conn.Open();
string cmdstr = "select DISTINCT ETAT_R,PSEUDO FROM BTS,SOURCE_ENERGIE_AUXILLIAIRE WHERE BTS.ID_SOURCE=SOURCE_ENERGIE_AUXILLIAIRE.ID_SOURCE ";
SqlCommand cmd = new SqlCommand(cmdstr, conn);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(ds);
dt = ds.Tables[0];
string[] x = new string[dt.Rows.Count];
int[] y = new int [dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
x[i] = dt.Rows[i][0].ToString();
y[i] = Convert.ToInt32( dt.Rows[i][1]);
}
Chart1.Series[0].Points.DataBindXY(y, x);
Chart1.Series[0].ChartType = SeriesChartType.StackedBar100;
Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = false;
}