public static void ExecuteNonSelect()

in Source/Website/Data_Layer/DataAccessHandler.cs [57:86]


        public static void ExecuteNonSelect(string query, SqlParameter[] parameters = null)
        {
            try
            {
                var connectionString = GetConnectionString();

                using (SqlConnection con = new SqlConnection(connectionString))
                using (SqlCommand command = new SqlCommand(query, con))
                {
                    if (parameters != null)
                    {
                        command.Parameters.AddRange(parameters);
                    }

                    using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command))
                    {
                        if (con.State == ConnectionState.Closed)
                        {
                            con.Open();
                        }

                        command.ExecuteNonQuery();
                    }
                }
            }
            catch (Exception e)
            {
                throw e;
            }
        }