MySqlDataAdapter failed to retrieve data on the first load

Question

I use MySQL Connector for ASP.NET to retrieve data from my MySQL server. Everything seems to work fine, but just at the first asynchronous postback of my page, MySQLDataAdapter does not fill my DataSet. After a complete refresh the data is succesfully loaded by asynchronous postback.

I try to assign a bigger value to the command timeout, but it does not seem seem to work.

This does not happen locally, only on the production server.

I have checked that the fill does not work by displaying the request string and also by on each async postback (displaying the count() of my DS.table[0].rows).

This is really the fill method not working.

        try
        {
            using (MySqlConnection conn = new MySqlConnection(_connexionString))
            {
                string requete = "";
                DataSet DS = new DataSet();

                requete = "SELECT * from MYTABLE";

                using (MySqlDataAdapter MSDA = new MySqlDataAdapter(requete, conn))
                {
                    DS.Clear();
                    MSDA.Fill(DS);
                }
                conn.Close();
                conn.Dispose();
            }
        }
        catch (MySqlException ex)
        {
            l_error.Text = ex.ToString();
        }

Answer 1

Try putting code into Page_Init event too.

Answer 2

did you checked Page.isPostBack property ? may be you are not checking isPostback, properly. it would be helpful,if you share your entire method.

 if(!Page.IsPostBack)
{
   //load your datasets and data - adapters.
}

Answer 3

After few investigation in code, i found that it not work, in fact an value of request was empty ... so no data return by mysql server, there was session key which was expire... thx all for your help !