Persistencia.Conexao.executeNoQuery C# (CSharp) Method

executeNoQuery() public method

public executeNoQuery ( String SQL ) : int
SQL String
return int
        public int executeNoQuery(String SQL)
        {
            SqlCommand cmd = cn.CreateCommand();
            cmd.CommandText = SQL;
            return cmd.ExecuteNonQuery();
        }

Usage Example

 public void alterar(String idCategoria, String nomeCategoria)
 {
     String SQL = "UPDATE Categoria SET nomeCategoria = '" + nomeCategoria + "' WHERE idCategoria = " + idCategoria;
     Conexao oConexao = new Conexao("SQLServer");
     oConexao.executeNoQuery(SQL);
     oConexao.fechaConexao();
 }
All Usage Examples Of Persistencia.Conexao::executeNoQuery