Populating tree view in vb.net from Postgres Database

The vb.net code for populating tree view from the SQL Server Database is given in following link: http://support.microsoft.com/kb/320755

I tried the code given in the above link to solve my problem but I 开发者_运维百科was unable to change the code of SQL Sever for Postgres Database.

I want to do the same thing using vb.net and database Postgres.

You failed to tell us what exactly is not working for your, but my guess is the non-standard SQL that is used in that example.

Remove the "bracket quoting" from the SQL Statements, and it should run fine on PostgreSQL

Select * from [Order Details] is invalid SQL for PostgreSQL (and every other DBMS except SQL Server)

Change the table's name to e.g. order_details and then you can run SELECT * FROM order_details leaving out the square brackets

And of course, the connection string needs to be changed as well (but I cannot help you there as I don't know VisualBasic)