Database.Database.ExecuteNonQuery C# (CSharp) Method

ExecuteNonQuery() public method

public ExecuteNonQuery ( string sql_query, SQLiteParameter parameters ) : string
sql_query string
parameters SQLiteParameter
return string
        public string ExecuteNonQuery(string sql_query, SQLiteParameter[] parameters)
        {
            string res = string.Empty;

            if (_connection.State == ConnectionState.Open)
            {
                CloseConnection();
            }

            _connection.Open();
            _command = _connection.CreateCommand();
            _command.CommandText = sql_query;

            if (parameters != null)
            {
                _command.Parameters.AddRange(parameters);
            }

            try
            {
                _command.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine("ERROR! " + ex.Message + "\r\n" + ex.StackTrace);
                res = CreateExceptionMessage(ex);
            }
            
            _connection.Close();

            return res;
        }