Loading

tables/postgresql

slzr6a

I am working on an application that will allow me to create tables of variable sizes and insert data into them and then upload them to a postgresql database. The tables have no relation to each other. I need to also be able to get the data from the database and edit it. Is c# a good language to use for this solution? What are some suggestions to help me get going? I have tried some things and it seems that nothing does what I need them to do so I would just like a new idea or direction.

2 Replies

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

slzr6a22y ago
.net does not come with the accessablility to a postgresql database, but there is a dll that gives this functionality for c#. It contains the command, adapter, connection. I am not having any trouble with the database connection. I think I need some suggestions for the interface. Is a datagrid the best thing to use? It seems to be a bit buggy when you dont lock it down from users editing it directly. Thanks for any help.
Adam Erstelle22y ago
Although I do not know what a postgresql database is, first you would have to find out if the .net framework has a provider that would allow you to access the database (wether it be C#, C++ or VB.net) If .net is able to communicate with the database, you could use any of the languages above to code your application. Key .net objects in your application will be a Connection object, command object (both are specific to your data provider) and a Dataset (not specific to your data provider).