using Npgsql; using System.Data; using System.Windows.Forms; string connString = ""; string query = "SELECT * FROM tablename"; NpgsqlDataAdapter da = new NpgsqlDataAdapter(query, connString); DataTable dt = new DataTable(); da.Fill(dt); DataGrid dg = new DataGrid(); dg.DataSource = dt;
using Npgsql; using System; using System.Data; string connString = ""; string query = "SELECT * FROM tablename"; NpgsqlDataAdapter da = new NpgsqlDataAdapter(query, connString); DataTable dt = new DataTable(); da.Fill(dt); foreach (DataRow row in dt.Rows) { Console.WriteLine(row["column1"] + " " + row["column2"]); }
Install-Package Npgsql