Conexão C# com PostGreSQL
06/04/2010
0
Sávio Costa
Posts
07/04/2010
Paulo Freire
using Npgsql; // faça referencia a Npgsql.dll
NpgsqlConnection conn = new NpgsqlConnection(ConfigurationManager.ConnectionString["Conexao"].ConnectionString);
try
{
conn.Open();
string SQL = "SELECT NOME, EMAIL, TELELEFONE1 FROM CORINTIANOS";
NpgsqlADataAdapter da = new NpgsqlDataAdapter(SQL, conn);
DataSet ds = new DataSet();
da.Fill(ds, "Membros");
GridViewMembros.DataSource = ds.Table["Membros"].DefaultView;
GridViewMembros.DataBind();
}
finally
{
conn.Close();
}
07/04/2010
Paulo Freire
07/04/2010
Netasper
Clique aqui para fazer login e interagir na Comunidade :)