Problema Timeout SQL

[supermac]

Pardon è vero, MS SQL

[djciko]

prova ad usare questa (storica) classe:


uso: databaseWrapper.ExecInsertUpdateDelete("UPDATE tab SET campo=0", "server=10.10.10....");

    public class databaseWrapper
    {


        private static SqlConnection internal_SQLCONN;
        private static SqlCommand internal_SQLCOMMAND;
        private static SqlDataAdapter internal_SQLADAPTER;


        public static int ExecInsertUpdateDelete(string SQL, string ConnString)
        {
            try
            {
                internal_SQLCONN = new System.Data.SqlClient.SqlConnection(ConnString);
                internal_SQLCONN.Open();
            }
            catch (SqlException ex)
            {
                //ex.Message;
                return -1;
            }
            catch (Exception ex)
            {
                //ex.Message;
                return -1;
            }




            internal_SQLCOMMAND = new SqlCommand(SQL, internal_SQLCONN);


            int affected = 0;
            try
            {
                affected = internal_SQLCOMMAND.ExecuteNonQuery();
            }
            catch (SqlException ex)
            {
                //ex.InnerException;
                return -1;
            }
            catch (Exception ex)
            {
                //ex.InnerException;
                return -1;
            }
            finally
            {
                if (internal_SQLCONN != null && internal_SQLCONN.State == ConnectionState.Open)
                {
                    try
                    {
                        if (internal_SQLCOMMAND != null)
                            internal_SQLCOMMAND.Dispose();


                        // Chiude la connessione
                        internal_SQLCONN.Close();
                    }
                    catch (SqlException ex)
                    {
                        //
                    }
                    catch (Exception ex)
                    {
                        //
                    }
                }
            }


            return affected;
        }
    }