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.
#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??