edit/view postgresql table in C# wpf app

Question

I need to create a means of viewing and editing a postgresql table through C# WPF style app. Is it possible to do this in a DataGrid control? So far I found a class in the .NET framework called SqlDataAdapter, which can return a query result in a DataSet object, and update the data in db appropriately if the DataSet is altered. But I think this is only for Microsoft Sequel Server. Would this work for PostgreSql? And would it be possible to bind the DataSet to a Datagrid?

Thanks, Alex

swasheck · Accepted Answer · 2012-08-31 14:47:22Z

2

npgsql is what I have always used. It uses the same interfaces so instead of a SqlDataAdapter you'll have an NpgsqlDataAdapter that functions the same way. From there, you can populate your DataTable or DataSource and bind that to your DataGrid.

answered Aug 31, 2012 at 14:47

swasheck

4,7232 gold badges32 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alex Over a year ago

Thanks, I have been using Npgsql and did not think to look there. Can the DataTable and DataSource objects be bound to a DataGrid in WPF? I found examples of this, but they were for System.Windows.Forms based controls.

swasheck Over a year ago

link 1 link 2

Collectives™ on Stack Overflow

edit/view postgresql table in C# wpf app

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related