Hi, Honestly saying, what is your exact problem. 1. You can set time out in connection string (its not gud idea) 2. Set command time out for the execution of this below mentioned block 3. optimize your query for SELECT operation. Rgds Vipin
On Wed, Jun 2, 2010 at 12:43 AM, Sammael <[email protected]> wrote: > Hello! > My application uses this code to create datatables: > > > private static DataTable GetAdapterData(DbDataAdapter dataAdapter) { > DataTable dataTable = new DataTable(); > try {dataAdapter.Fill(dataTable);} > catch {} > return dataTable; > > > Some reports are create on DataTables generated by this code, but in a > procidure, I create 2 different Datatables. One of then, I got this > MySqlTimeout Except. I Already tried to create only the "broken" datatable > but I still have the same problem. > I already tested the query in MySql Browser and it works just fine. > > PS: Sorry for my crappy english XD > > -- > Bayushi Sanjiro (バユシ サンジロ) > Scorpion Clan * Loyal * Unique * Samurai * Poison Master * Courtier * > Imperial Historian > ♠ Your secrets are safe with me... > -- "People who never make mistakes, never do anything." dEv
