Beispiel #1
0
        public static bool ExecuteNonQuery(MySqlCommand cmd)
        {
            //SqlConnection conn = new SqlConnection(connectionString);
            MySqlConnection conn = Db.GetConnection();

            try
            {
                if (conn.State == ConnectionState.Closed)
                {
                    Db.Connection.Open();
                }

                cmd.Connection = conn;
                result         = cmd.ExecuteNonQuery();
                if (result == 1)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                }

                conn.Dispose();
            }
        }