مشکل این کد کجاست

مشکلش کجاست

کد:

---


protected void Page_Load(object sender, EventArgs e)
{
 
 
    string connectionstring = "provider=Microsoft.Jet.OLeDB.4.0;Data Source=" + Server.MapPath("dbsite.mdb") + ";password='aaa2iran'";
 
 
 
    OleDbConnection conn = new OleDbConnection(connectionstring);
    string query = "select min(id)as mini and maxi(id) as max from tbl_jayeze";
    OleDbCommand cm = new OleDbCommand(query, conn);
    conn.Open();
    OleDbDataReader dr = cm.ExecuteReader();
    if (dr.Read())
    {
        int a1 = Convert.ToInt32(dr["mini"]);
        int a2 = Convert.ToInt32(dr["maxi"]);
        Timer tm = new Timer();
        tm.Interval = 60;
        tm.AutoReset = false;
        tm.Start();
        if(tm.Elapsed)
        {
        Random rand = new Random();
        int a = rand.Next(a1, a2);
        Label1.Text = a.ToString();
        }

    }
   
 
 
}

---

select min(id)as mini and maxi(id) as max from tbl_jayeze

احتمالا باید اینجوری بشه

select min(id)as mini and max(id) as maxi from tbl_jayeze

کد:

---

select min(id)as mini and maxi(id) as max from tbl_jayeze

---

باید به صورت زیر باشه

کد:

---

select min(id)as mini ,maxi(id) as max from tbl_jayeze

---

بجای and از کاما "," استفاده کن