Regarding #1 This will not help in this situation.
On Wed, Jun 2, 2010 at 6:56 PM, crazy <[email protected]> wrote: > 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 >
