How to connect PostgreSQL database using C#

Question

I have a POSTGRESQL database i have created,now i want to connect it to a c# application. Any idea will be appreciated.

narayan singh · Answer

http://www.sqlines.com/postgresql/npgsql_dotnet

Laxmidhar Sahoo · Answer

Install from nugate Ngsql https: //www.nuget.org/packages/Npgsql/ web config https: //www.npgsql.org/doc/installation.html using Npgsql; namespace PostgreSQLTEst { public partial class Form1 : Form { private DataSet ds = new DataSet(); private DataTable dt = new DataTable(); public Form1() { InitializeComponent(); } private void llOpenConnAndSelect_LinkClicked( object sender, LinkLabelLinkClickedEventArgs e) { try { // PostgeSQL-style connection string string connstring = String.Format( "Server={0};Port={1};" + "User Id={2};Password={3};Database={4};" , tbHost.Text, tbPort.Text, tbUser.Text, tbPass.Text, tbDataBaseName.Text ); // Making connection with Npgsql provider NpgsqlConnection conn = new NpgsqlConnection(connstring); conn.Open(); // quite complex sql statement string sql = "SELECT * FROM simple_table" ; // data adapter making request from our connection NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, conn); // i always reset DataSet before i do // something with it.... i don't know why :-) ds.Reset(); // filling DataSet with result from NpgsqlDataAdapter da.Fill(ds); // since it C# DataSet can handle multiple tables, we will select first dt = ds.Tables[0]; // connect grid to DataTable dataGridView1.DataSource = dt; // since we only showing the result we don't need connection anymore conn.Close(); } catch (Exception msg) { // something went wrong, and you wanna know why MessageBox.Show(msg.ToString()); throw ; } } } } Can go for another examples https: //www.c-sharpcorner.com/UploadFile/john_charles/using-postgresql-from-microsoft-net/ Thanks and regards

Rajkiran Swain · Answer

https://www.codeproject.com/Articles/30989/Using-PostgreSQL-in-your-C-NET-application-An-intr

How to connect PostgreSQL database using C#

Answers (3)