Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C++/CLI PostgreSQL
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 Smile | :) ). 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.
 

#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 29-Apr-13 12:53pm
Comments
ThePhantomUpvoter at 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)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 485
1 OriginalGriff 310
2 Shweta N Mishra 244
3 Mathew Soji 225
4 BillWoodruff 200
0 OriginalGriff 6,153
1 Sergey Alexandrovich Kryukov 5,758
2 DamithSL 4,958
3 Manas Bhardwaj 4,539
4 Maciej Los 3,735


Advertise | Privacy | Mobile
Web01 | 2.8.1411019.1 | Last Updated 29 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100