DataAdapter won't disconnect?

[Bryan Luisana]

Hello,

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

Even doing something as simple as this creates a conneciton that sleeps after I am done with it. This means that everytime a new user connects to my webpage a new conneciton is made untill 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();
dataAdapter.Dispose();
}

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

HELP!!