Adding multiple series in asp.net chart dynamically (from sql table for each rows) Asp.net

Add Chart Control on design




In Code behind getdata from dataset for each row from table create series dynamically and add to chart series look in code it will be easy


 public void Bindchart()
    {
        DataSet myDataSet2 = getdatafromsql();
        string series="series";

        foreach (DataRow row in myDataSet2.Tables[0].Rows)
        {
            series=series+row.ToString();
            chart1.Series.Add(series);

            for (int colIndex = 1; colIndex < myDataSet2.Tables[0].Columns.Count; colIndex++)
            {

                // for each column (column 1 and onward), add the value as a point

                string columnName1 = myDataSet2.Tables[0].Columns[colIndex].ColumnName.ToString();

                

                int YVal1 = Convert.ToInt32(row[columnName1]);

                string  emp = Convert.ToString(row[0]);
                chart1.Series[series].Points.AddXY(columnName1, YVal1);
                chart1.Series[series].LegendText  = emp;
                 chart1.Series[ser].ToolTip = emp + "= #VALY";


            }
        }
       
    }