How to set x-axis Min and Max value from Database table in MSChart Control ASP.Net

You are retreiving values from database for X and Y axis. So you can find the max and min value of X and Y axis from DataTable.

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("X",typeof(decimal));
        dt.Columns.Add("Y", typeof(decimal));
        dt.Rows.Add(65,10);
        dt.Rows.Add(88,45);
        dt.Rows.Add(45,50);
        dt.Rows.Add(12,78);
        dt.Rows.Add(80,75);
        decimal Xmax = dt.Select().Select(c => Convert.ToDecimal(c["X"])).Max();
        decimal Xmin = dt.Select().Select(c => Convert.ToDecimal(c["X"])).Min();

        decimal Ymax = dt.Select().Select(c => Convert.ToDecimal(c["Y"])).Max();
        decimal Ymin = dt.Select().Select(c => Convert.ToDecimal(c["Y"])).Min();
    }
}

Used below code and is working fine:

string id = Request.QueryString[1].ToString();

string query = "select X,Y from Table where DeletionDate is null order by X";
DataTable dt = GetData(query);

double[] x = new double[dt.Rows.Count];
double[] y = new double[dt.Rows.Count];

for (int i = 0; i < dt.Rows.Count; i++)
{
    x[i] = Convert.ToDouble(dt.Rows[i][0].ToString());
    y[i] = Convert.ToDouble(dt.Rows[i][1].ToString());
}
Chart1.Series[0].Points.DataBindXY(x, y);

double Xmax = dt.Select().Select(c => Convert.ToDouble(c["X"])).Max();
double Xmin = dt.Select().Select(c => Convert.ToDouble(c["X"])).Min();

Chart1.ChartAreas["ChartArea1"].AxisX.Minimum = Xmax;  // for x min value from DB
Chart1.ChartAreas["ChartArea1"].AxisX.Maximum = Xmin;  // for x max value from DB