List:MySQL and .NET« Previous MessageNext Message »
From:Reggie Burnett Date:February 3 2005 6:16pm
Subject:RE: Dataadapter doesn't disconnect?
View as plain text  
Brian

Are you using connection pooling?

-reggie

> -----Original Message-----
> From: Bryan Luisana [mailto:bluisana@stripped]
> Sent: Wednesday, February 02, 2005 12:47 PM
> To: dotnet@stripped
> Subject: Dataadapter doesn't disconnect?
> 
> Hello,
> 
> Is anyone else having an issue when using the a mysqldatadapter.
> 
> Even doing something as simple as the code below 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 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!!
> 
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe:    http://lists.mysql.com/dotnet?unsub=1

Thread
Dataadapter doesn't disconnect?Bryan Luisana2 Feb
  • Re: Dataadapter doesn't disconnect?Jorge Bastos2 Feb
  • RE: Dataadapter doesn't disconnect?Reggie Burnett3 Feb
Re: Dataadapter doesn't disconnect?Jorge Bastos2 Feb
Re: Dataadapter doesn't disconnect?Jorge Bastos2 Feb
Re: Dataadapter doesn't disconnect?Bryan Luisana2 Feb
  • Re: Dataadapter doesn't disconnect?Jorge Bastos2 Feb