Clase Conexion

// Main.cs

//

// Copyright (C) 2009 [José Antonio Martínez Torres]

//

// This program is free software; you can redistribute it and/or modify

// it under the terms of the GNU General Public License as published by

// the Free Software Foundation; either version 2 of the License, or

// (at your option) any later version.

//

// This program is distributed in the hope that it will be useful,

// but WITHOUT ANY WARRANTY; without even the implied warranty of

// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

// GNU General Public License for more details.

//

// You should have received a copy of the GNU General Public License

// along with this program; if not, write to the Free Software

// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA

//

//

using System;

using Npgsql;//

namespace conexion

{

class Postgre

{

public NpgsqlConnection dbcon;

public void conectar()

{

string con = "Server=127.0.0.1;"+

"Port=5432;"+

"User Id=tu_usuario;"+

"Password=tu_password;"+

"Database=ejercicio;";

dbcon = new NpgsqlConnection(con);

dbcon.Open();

}

public void ejectuar(string query)

{

NpgsqlCommand command = dbcon.CreateCommand();

command.CommandText = query;

command.ExecuteReader();

}

public void desconectar()

{

dbcon.Close();

}

public static void Main(string[] args)

{

try{

Postgre conexion;

conexion = new Postgre();

conexion.conectar();

Console.WriteLine("Conexión exitosa");

string query = "INSERT INTO usuarios VALUES ('C01','Juan','Perez');";

conexion.ejectuar(query);

Console.WriteLine("Se ingreso el dato satisfactoriamente");

Console.WriteLine("Visita http://www.antoniomtz.org");

}

catch(NpgsqlException error)

{

string mensaje = error.Message;

Console.WriteLine(mensaje);

}

}

}

}

...