How to connect PostgreSQL database using C#

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
1. Install from nugate Ngsql
3. https://www.nuget.org/packages/Npgsql/
5. web config
7. https://www.npgsql.org/doc/installation.html
9. using Npgsql;
11. namespace PostgreSQLTEst
12. {
13. public partial class Form1 : Form
14. {
15. private DataSet ds = new DataSet();
16. private DataTable dt = new DataTable();
17. public Form1()
18. {
19. InitializeComponent();
20. }
21. private void llOpenConnAndSelect_LinkClicked(object sender,
22. LinkLabelLinkClickedEventArgs e)
23. {
24. try
25. {
26. // PostgeSQL-style connection string
27. string connstring = String.Format("Server={0};Port={1};" +
28. "User Id={2};Password={3};Database={4};",
29. tbHost.Text, tbPort.Text, tbUser.Text,
30. tbPass.Text, tbDataBaseName.Text );
31. // Making connection with Npgsql provider
32. NpgsqlConnection conn = new NpgsqlConnection(connstring);
33. conn.Open();
34. // quite complex sql statement
35. string sql = "SELECT * FROM simple_table";
36. // data adapter making request from our connection
37. NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, conn);
38. // i always reset DataSet before i do
39. // something with it.... i don't know why :-)
40. ds.Reset();
41. // filling DataSet with result from NpgsqlDataAdapter
42. da.Fill(ds);
43. // since it C# DataSet can handle multiple tables, we will select first
44. dt = ds.Tables[0];
45. // connect grid to DataTable
46. dataGridView1.DataSource = dt;
47. // since we only showing the result we don't need connection anymore
48. conn.Close();
49. }
50. catch (Exception msg)
51. {
52. // something went wrong, and you wanna know why
53. MessageBox.Show(msg.ToString());
54. throw;
55. }
56. }
57. }
58. }
62. Can go for another examples
64. https://www.c-sharpcorner.com/UploadFile/john_charles/using-postgresql-from-microsoft-net/
67. Thanks and regards
0