guys I get this error: -

ExecuteReader requires an open and available Connection. The connection's current state is Open, Fetching.

when I try to access my database with this code: -

private void GridDataFiller(object sender, EventArgs e)
{
    string strSmokingFilter = Smoking.SelectedItem.Text.ToString();
    string strAreaFilter = ddlAreas.SelectedItem.Text.ToString();
    string strFurnished;



  lblDescription.Visible = false;
  String strConnect = "Provider = Microsoft.Jet.OleDb.4.0; data source = \\\\premfs3\\sites\\premium8\\adnanarab66\\databas e\\House.mdb;";
  OleDbConnection objConnection = new OleDbConnection(strConnect);

  String strShowDetails = "SELECT * FROM Houses WHERE RentingPrice = ? AND HouseHold = ? AND Smoking = ?";

  OleDbCommand objCommand = new OleDbCommand(strShowDetails, objConnection);

  //objCommand.Connection = objConnection;
  //objCommand.CommandType = CommandType.Text;
  //objCommand.CommandText = strShowDetails;

  objCommand.Parameters.Add("RentingPrice", OleDbType.VarChar, 32, "RentingPrice");
  objCommand.Parameters.Add("HouseHold", OleDbType.VarChar, 32, "HouseHold");
  objCommand.Parameters.Add("Smoking", OleDbType.VarChar, 32, "Smoking");
  //objCommand.Parameters.Add("Furnished", OleDbType.VarChar, 32, "Furnished");

  objCommand.Parameters["RentingPrice"].Value = Payment.Text;
  objCommand.Parameters["HouseHold"].Value = strAreaFilter;
  objCommand.Parameters["Smoking"].Value = strSmokingFilter;

  OleDbDataReader objDataReader = null;
  //objCommand.Parameters["Furnished"].Value = //strFurnished;
  try
  {
      if(objConnection.State != ConnectionState.Open)
    {
    objConnection.Open();
    }
    //else if(objConnection.State == ConnectionState.Open)
    //{
    //objConnection.Close();
    //}
    //objConnection.Open();
      objDataReader = objCommand.ExecuteReader();
          if(objDataReader.HasRows)
          {
              dgHouse.Visible = true;
              dgHouse.DataSource = objCommand.ExecuteReader();
              dgHouse.DataBind();
          }
          else
          {
          Response.Write("This is doing my head in!");
          }
    }
      catch(Exception ex)
      {
    Response.Write(ex.Message);
      Response.End();
      }
      finally
      {
    objDataReader.Close();
    objConnection.Close();
    }
  }

any ideas??

Adz - The World is not enough

__________________
Adz - Learning The J2EE Ways.

Hi there,

A DataReader will block the Connection as long as it is open. This means you cannot execute any other statement over the connection. Your code tries to execute the reader twice:
First you assign the result of the ExecuteReader method to the objDataReader, and then a few lines later, you use ExecuteReader again to fill the datasource. You should assign objDataReader to the DataSource property instead:   This way, you only have one reader open at the time.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Say Goodbye Hollywood by Eminem (Track 8 from the album: The Eminem Show)

nice one man,

ok let me try this again!

Easy

Adz - The World is not enough