Click here to Skip to main content
15,883,705 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi Guys!!
I'm beginner in Visual C++, so I want your help.
I wrote simple application, which need database (PostgreSQL). The source code in c++ is ok,
(I hope so :)). In this application is DataViewGird which should connect to database and show me rows and column, but after compilation (without bugs) and running there is grey area without any tables.
I think, problem is in database. Of coruse I have added drivers for SQL to my project and directives in using namespaces. Below, I will show you my code and printscreen from pgAdminIII,where I create my database and there added four colums.


C++
#pragma endregion
		private: NpgsqlConnection^ connection;
		private: NpgsqlCommand^ selectcomm;

private: System::Void Form1_Load(System::Object^  sender, System::EventArgs^  e) 
			 {
 connection = gcnew NpgsqlConnection("server=127.0.0.1; Port=5030; UserId=postgres;  Database=utwory");

                odswiez();
			 }
private: System::Void odswiez()
			 {
		selectcomm = gcnew NpgsqlCommand("select * from plyty", connection);
				 DataSet^ ds = gcnew DataSet("Dane o plytach");
				 NpgsqlDataAdapter^ adapter = gcnew   NpgsqlDataAdapter(selectcomm);
				 adapter ->Fill(ds);
				 bindingSource1->DataSource=ds->Tables[0];
				 dataGridView1->DataSource=bindingSource1;
			 }


I don't know what is wrong...
Do you have any tutorials for this or ideas how create database properly??
Posted
Comments
[no name] 29-Apr-13 19:48pm    
The very first thing that you should try..... is opening the connection to your database.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900