Devart Forums

I would like to know if anyone has some links or even some advice as to where to start if I want to connect my Windows form application to a postgresql database please?

I have already set up the database and also managed to use the dotconnect control, pgConnection, to connect to that database.

I now want to use the data in the db and for instance use it in a textbox, label, and combobox. How do I populate those controls with the data in the db?

I then also want to be able to update the db.

I am a little new to VS and postgre, so not quite sure how to do this.

Please take note that I have installed the postgre and VS dot connect controls which I am using in VS to work with the db.

Thanks in advance.

Please see the ADO.NET overview at MSDN for general information on how to retrieve, use and update database data in .NET Framework:
http://msdn.microsoft.com/en-us/library/e80y5yhx.aspx

dotConnect for PostgreSQL implements ADO.NET approach of working with databases for PostgreSQL. For detailed information on using dotConnect for PostgreSQL components, please refer to our documentation:
http://www.devart.com/dotconnect/postgresql/docs/
It is also available in the installation package of dotConnect for PostgreSQL and can be downloaded as a single .chm file from
http://www.devart.com/dotconnect/postgr ... gresql.chm

You probably will be interested in the whole Tutorials section and 'General Concepts in Database Application Development' and 'Using DataSet Wizard' topics.

Feel free to contact us if something is unclear.