Hello,

Is anyone else having an issue when using the a mysqldatadapter.

Even doing something as simple as the code below creates a conneciton

am done with it. This means that everytime a new user connects to my webpage a new conneciton is made untill the mysql max connections is reached.

MySqlConnection connection = new MySqlConnection(constr);

MySqlCommand myCommand = new MySqlCommand(sqlCommand); myCommand.CommandType = CommandType.Text;

myCommand.Connection=connection; MySqlDataAdapter dataAdapter = new MySqlDataAdapter(myCommand); DataTable myDataTable = new DataTable();

try { connection.Open(); dataAdapter.Fill(myDataTable); connection.Close(); connection.Dispose(); dataAdapter.Dispose(); }

Neither the close nor the dispose method makes the connection to the database close?

HELP!!