jamsss | Bonjour à tous,
je débute en C++ (je viens du C) et je voudrais connecter une base de données Access à une application développée avec visual C++. Pour ça j'ai utilisé un oleDbDataAdapter en suivant la méthode pas à pas de MSDN ici: http://msdn.microsoft.com/fr-fr/li [...] s.71).aspx
Mon problème arrive au moment de cliquer sur le bouton pour charger la bdd, j'obtiens les erreurs suivantes:
error C2653: 'dsArticle1' : n'est pas un nom de classe ni d'espace de noms
error C3861: 'Clear' : identificateur introuvable
error C2653: 'oleDbDataAdapter1' : n'est pas un nom de classe ni d'espace de noms
error C3861: 'Fill' : identificateur introuvable
Voici le code:
Code :
- #pragma once
- #include<iostream>
- namespace GOPharma {
- using namespace System;
- using namespace System::ComponentModel;
- using namespace System::Collections;
- using namespace System::Windows::Forms;
- using namespace System::Data;
- using namespace System::Drawing;
- /// <summary>
- /// Description rÈsumÈe de Form1
- ///
- /// AVERTISSEMENT†: si vous modifiez le nom de cette classe, vous devrez modifier la
- /// propriÈtÈ 'Nom du fichier de ressources' de l'outil de compilation de ressource managÈe
- /// pour tous les fichiers .resx dont dÈpend cette classe. Dans le cas contraire,
- /// les concepteurs ne pourront pas interagir correctement avec les ressources
- /// localisÈes associÈes ‡ ce formulaire.
- /// </summary>
- public ref class Form1 : public System::Windows::Forms::Form
- {
- public:
- Form1(void)
- {
- InitializeComponent();
- //
- //TODO†: ajoutez ici le code du constructeur
- //
- }
- protected:
- /// <summary>
- /// Nettoyage des ressources utilisÈes.
- /// </summary>
- ~Form1()
- {
- if (components)
- {
- delete components;
- }
- }
- private: System::Data::OleDb::OleDbCommand^ oleDbSelectCommand1;
- protected:
- private: System::Data::OleDb::OleDbConnection^ oleDbConnection1;
- private: System::Data::OleDb::OleDbCommand^ oleDbInsertCommand1;
- private: System::Data::OleDb::OleDbCommand^ oleDbUpdateCommand1;
- private: System::Data::OleDb::OleDbCommand^ oleDbDeleteCommand1;
- private: System::Data::OleDb::OleDbDataAdapter^ oleDbDataAdapter1;
- private: GOPharma::DsArticle^ dsArticle1;
- private: System::Windows::Forms::DataGridView^ dataGridView1;
- private: System::Windows::Forms::DataGridViewTextBoxColumn^ rEFARTDataGridViewTextBoxColumn;
- private: System::Windows::Forms::DataGridViewTextBoxColumn^ dOSARTDataGridViewTextBoxColumn;
- private: System::Windows::Forms::DataGridViewTextBoxColumn^ nOMARTDataGridViewTextBoxColumn;
- private: System::Windows::Forms::DataGridViewTextBoxColumn^ pRESARTDataGridViewTextBoxColumn;
- private: System::Windows::Forms::DataGridViewTextBoxColumn^ pRIXARTDataGridViewTextBoxColumn;
- private: System::Windows::Forms::DataGridViewTextBoxColumn^ uNIARTDataGridViewTextBoxColumn;
- private: System::Windows::Forms::Button^ Btnload;
- private:
- /// <summary>
- /// Variable nÈcessaire au concepteur.
- /// </summary>
- System::ComponentModel::Container ^components;
- #pragma region Windows Form Designer generated code
- /// <summary>
- /// MÈthode requise pour la prise en charge du concepteur - ne modifiez pas
- /// le contenu de cette mÈthode avec l'Èditeur de code.
- /// </summary>
- void InitializeComponent(void)
- {
- System::ComponentModel::ComponentResourceManager^ resources = (gcnew System::ComponentModel::ComponentResourceManager(Form1::typeid));
- this->oleDbSelectCommand1 = (gcnew System::Data::OleDb::OleDbCommand());
- this->oleDbInsertCommand1 = (gcnew System::Data::OleDb::OleDbCommand());
- this->oleDbUpdateCommand1 = (gcnew System::Data::OleDb::OleDbCommand());
- this->oleDbDeleteCommand1 = (gcnew System::Data::OleDb::OleDbCommand());
- this->oleDbDataAdapter1 = (gcnew System::Data::OleDb::OleDbDataAdapter());
- this->oleDbConnection1 = (gcnew System::Data::OleDb::OleDbConnection());
- this->dsArticle1 = (gcnew GOPharma::DsArticle());
- this->dataGridView1 = (gcnew System::Windows::Forms::DataGridView());
- this->rEFARTDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
- this->dOSARTDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
- this->nOMARTDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
- this->pRESARTDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
- this->pRIXARTDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
- this->uNIARTDataGridViewTextBoxColumn = (gcnew System::Windows::Forms::DataGridViewTextBoxColumn());
- this->Btnload = (gcnew System::Windows::Forms::Button());
- (cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dsArticle1))->BeginInit();
- (cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dataGridView1))->BeginInit();
- this->SuspendLayout();
- //
- // oleDbSelectCommand1
- //
- this->oleDbSelectCommand1->CommandText = L"SELECT ARTICLE.*\r\nFROM ARTICLE";
- this->oleDbSelectCommand1->Connection = this->oleDbConnection1;
- //
- // oleDbInsertCommand1
- //
- this->oleDbInsertCommand1->CommandText = L"INSERT INTO `ARTICLE` (`REFART`, `DOSART`, `NOMART`, `PRESART`, `PRIXART`, `UNIAR"
- L"T`) VALUES (\?, \?, \?, \?, \?, \?)";
- this->oleDbInsertCommand1->Connection = this->oleDbConnection1;
- this->oleDbInsertCommand1->Parameters->AddRange(gcnew cli::array< System::Data::OleDb::OleDbParameter^ >(6) {(gcnew System::Data::OleDb::OleDbParameter(L"REFART",
- System::Data::OleDb::OleDbType::Integer, 0, L"REFART" )), (gcnew System::Data::OleDb::OleDbParameter(L"DOSART", System::Data::OleDb::OleDbType::VarWChar,
- 0, L"DOSART" )), (gcnew System::Data::OleDb::OleDbParameter(L"NOMART", System::Data::OleDb::OleDbType::VarWChar, 0, L"NOMART" )),
- (gcnew System::Data::OleDb::OleDbParameter(L"PRESART", System::Data::OleDb::OleDbType::VarWChar, 0, L"PRESART" )), (gcnew System::Data::OleDb::OleDbParameter(L"PRIXART",
- System::Data::OleDb::OleDbType::Currency, 0, L"PRIXART" )), (gcnew System::Data::OleDb::OleDbParameter(L"UNIART", System::Data::OleDb::OleDbType::VarWChar,
- 0, L"UNIART" ))});
- //
- // oleDbUpdateCommand1
- //
- this->oleDbUpdateCommand1->CommandText = resources->GetString(L"oleDbUpdateCommand1.CommandText" );
- this->oleDbUpdateCommand1->Connection = this->oleDbConnection1;
- this->oleDbUpdateCommand1->Parameters->AddRange(gcnew cli::array< System::Data::OleDb::OleDbParameter^ >(17) {(gcnew System::Data::OleDb::OleDbParameter(L"REFART",
- System::Data::OleDb::OleDbType::Integer, 0, L"REFART" )), (gcnew System::Data::OleDb::OleDbParameter(L"DOSART", System::Data::OleDb::OleDbType::VarWChar,
- 0, L"DOSART" )), (gcnew System::Data::OleDb::OleDbParameter(L"NOMART", System::Data::OleDb::OleDbType::VarWChar, 0, L"NOMART" )),
- (gcnew System::Data::OleDb::OleDbParameter(L"PRESART", System::Data::OleDb::OleDbType::VarWChar, 0, L"PRESART" )), (gcnew System::Data::OleDb::OleDbParameter(L"PRIXART",
- System::Data::OleDb::OleDbType::Currency, 0, L"PRIXART" )), (gcnew System::Data::OleDb::OleDbParameter(L"UNIART", System::Data::OleDb::OleDbType::VarWChar,
- 0, L"UNIART" )), (gcnew System::Data::OleDb::OleDbParameter(L"Original_REFART", System::Data::OleDb::OleDbType::Integer, 0,
- System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"REFART", System::Data::DataRowVersion::Original,
- nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_DOSART", System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input,
- static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"DOSART", System::Data::DataRowVersion::Original, true, nullptr)),
- (gcnew System::Data::OleDb::OleDbParameter(L"Original_DOSART", System::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input,
- false, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"DOSART", System::Data::DataRowVersion::Original, nullptr)),
- (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_NOMART", System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input,
- static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"NOMART", System::Data::DataRowVersion::Original, true, nullptr)),
- (gcnew System::Data::OleDb::OleDbParameter(L"Original_NOMART", System::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input,
- false, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"NOMART", System::Data::DataRowVersion::Original, nullptr)),
- (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_PRESART", System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input,
- static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"PRESART", System::Data::DataRowVersion::Original, true, nullptr)),
- (gcnew System::Data::OleDb::OleDbParameter(L"Original_PRESART", System::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input,
- false, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"PRESART", System::Data::DataRowVersion::Original, nullptr)),
- (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_PRIXART", System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input,
- static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"PRIXART", System::Data::DataRowVersion::Original, true, nullptr)),
- (gcnew System::Data::OleDb::OleDbParameter(L"Original_PRIXART", System::Data::OleDb::OleDbType::Currency, 0, System::Data::ParameterDirection::Input,
- false, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"PRIXART", System::Data::DataRowVersion::Original, nullptr)),
- (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_UNIART", System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input,
- static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"UNIART", System::Data::DataRowVersion::Original, true, nullptr)),
- (gcnew System::Data::OleDb::OleDbParameter(L"Original_UNIART", System::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input,
- false, static_cast<System::Byte>(0), static_cast<System::Byte>(0), L"UNIART", System::Data::DataRowVersion::Original, nullptr))});
- //
- // oleDbDeleteCommand1
- //
- this->oleDbDeleteCommand1->CommandText = resources->GetString(L"oleDbDeleteCommand1.CommandText" );
- this->oleDbDeleteCommand1->Connection = this->oleDbConnection1;
- this->oleDbDeleteCommand1->Parameters->AddRange(gcnew cli::array< System::Data::OleDb::OleDbParameter^ >(11) {(gcnew System::Data::OleDb::OleDbParameter(L"Original_REFART",
- System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),
- static_cast<System::Byte>(0), L"REFART", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_DOSART",
- System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),
- L"DOSART", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_DOSART",
- System::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),
- static_cast<System::Byte>(0), L"DOSART", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_NOMART",
- System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),
- L"NOMART", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_NOMART",
- System::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),
- static_cast<System::Byte>(0), L"NOMART", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_PRESART",
- System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),
- L"PRESART", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_PRESART",
- System::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),
- static_cast<System::Byte>(0), L"PRESART", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_PRIXART",
- System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),
- L"PRIXART", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_PRIXART",
- System::Data::OleDb::OleDbType::Currency, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),
- static_cast<System::Byte>(0), L"PRIXART", System::Data::DataRowVersion::Original, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"IsNull_UNIART",
- System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, static_cast<System::Byte>(0), static_cast<System::Byte>(0),
- L"UNIART", System::Data::DataRowVersion::Original, true, nullptr)), (gcnew System::Data::OleDb::OleDbParameter(L"Original_UNIART",
- System::Data::OleDb::OleDbType::VarWChar, 0, System::Data::ParameterDirection::Input, false, static_cast<System::Byte>(0),
- static_cast<System::Byte>(0), L"UNIART", System::Data::DataRowVersion::Original, nullptr))});
- //
- // oleDbDataAdapter1
- //
- this->oleDbDataAdapter1->DeleteCommand = this->oleDbDeleteCommand1;
- this->oleDbDataAdapter1->InsertCommand = this->oleDbInsertCommand1;
- this->oleDbDataAdapter1->SelectCommand = this->oleDbSelectCommand1;
- cli::array< System::Data::Common::DataColumnMapping^ >^ __mcTemp__1 = gcnew cli::array< System::Data::Common::DataColumnMapping^ >(6) {(gcnew System::Data::Common::DataColumnMapping(L"REFART",
- L"REFART" )), (gcnew System::Data::Common::DataColumnMapping(L"DOSART", L"DOSART" )), (gcnew System::Data::Common::DataColumnMapping(L"NOMART",
- L"NOMART" )), (gcnew System::Data::Common::DataColumnMapping(L"PRESART", L"PRESART" )), (gcnew System::Data::Common::DataColumnMapping(L"PRIXART",
- L"PRIXART" )), (gcnew System::Data::Common::DataColumnMapping(L"UNIART", L"UNIART" ))};
- this->oleDbDataAdapter1->TableMappings->AddRange(gcnew cli::array< System::Data::Common::DataTableMapping^ >(1) {(gcnew System::Data::Common::DataTableMapping(L"Table",
- L"ARTICLE", __mcTemp__1))});
- this->oleDbDataAdapter1->UpdateCommand = this->oleDbUpdateCommand1;
- //
- // oleDbConnection1
- //
- this->oleDbConnection1->ConnectionString = L"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\"C:\\Documents and Settings\\Christop"
- L"he\\Mes documents\\Programmation\\C++\\GoPharma\\GOPharma.accdb\"";
- //
- // dsArticle1
- //
- this->dsArticle1->DataSetName = L"DsArticle";
- this->dsArticle1->SchemaSerializationMode = System::Data::SchemaSerializationMode::IncludeSchema;
- //
- // dataGridView1
- //
- this->dataGridView1->AutoGenerateColumns = false;
- this->dataGridView1->ColumnHeadersHeightSizeMode = System::Windows::Forms::DataGridViewColumnHeadersHeightSizeMode::AutoSize;
- this->dataGridView1->Columns->AddRange(gcnew cli::array< System::Windows::Forms::DataGridViewColumn^ >(6) {this->rEFARTDataGridViewTextBoxColumn,
- this->dOSARTDataGridViewTextBoxColumn, this->nOMARTDataGridViewTextBoxColumn, this->pRESARTDataGridViewTextBoxColumn, this->pRIXARTDataGridViewTextBoxColumn,
- this->uNIARTDataGridViewTextBoxColumn});
- this->dataGridView1->DataMember = L"ARTICLE";
- this->dataGridView1->DataSource = this->dsArticle1;
- this->dataGridView1->Location = System::Drawing::Point(1, 46);
- this->dataGridView1->Name = L"dataGridView1";
- this->dataGridView1->Size = System::Drawing::Size(526, 150);
- this->dataGridView1->TabIndex = 0;
- //
- // rEFARTDataGridViewTextBoxColumn
- //
- this->rEFARTDataGridViewTextBoxColumn->DataPropertyName = L"REFART";
- this->rEFARTDataGridViewTextBoxColumn->HeaderText = L"REFART";
- this->rEFARTDataGridViewTextBoxColumn->Name = L"rEFARTDataGridViewTextBoxColumn";
- //
- // dOSARTDataGridViewTextBoxColumn
- //
- this->dOSARTDataGridViewTextBoxColumn->DataPropertyName = L"DOSART";
- this->dOSARTDataGridViewTextBoxColumn->HeaderText = L"DOSART";
- this->dOSARTDataGridViewTextBoxColumn->Name = L"dOSARTDataGridViewTextBoxColumn";
- //
- // nOMARTDataGridViewTextBoxColumn
- //
- this->nOMARTDataGridViewTextBoxColumn->DataPropertyName = L"NOMART";
- this->nOMARTDataGridViewTextBoxColumn->HeaderText = L"NOMART";
- this->nOMARTDataGridViewTextBoxColumn->Name = L"nOMARTDataGridViewTextBoxColumn";
- //
- // pRESARTDataGridViewTextBoxColumn
- //
- this->pRESARTDataGridViewTextBoxColumn->DataPropertyName = L"PRESART";
- this->pRESARTDataGridViewTextBoxColumn->HeaderText = L"PRESART";
- this->pRESARTDataGridViewTextBoxColumn->Name = L"pRESARTDataGridViewTextBoxColumn";
- //
- // pRIXARTDataGridViewTextBoxColumn
- //
- this->pRIXARTDataGridViewTextBoxColumn->DataPropertyName = L"PRIXART";
- this->pRIXARTDataGridViewTextBoxColumn->HeaderText = L"PRIXART";
- this->pRIXARTDataGridViewTextBoxColumn->Name = L"pRIXARTDataGridViewTextBoxColumn";
- //
- // uNIARTDataGridViewTextBoxColumn
- //
- this->uNIARTDataGridViewTextBoxColumn->DataPropertyName = L"UNIART";
- this->uNIARTDataGridViewTextBoxColumn->HeaderText = L"UNIART";
- this->uNIARTDataGridViewTextBoxColumn->Name = L"uNIARTDataGridViewTextBoxColumn";
- //
- // Btnload
- //
- this->Btnload->Location = System::Drawing::Point(142, 243);
- this->Btnload->Name = L"Btnload";
- this->Btnload->Size = System::Drawing::Size(75, 23);
- this->Btnload->TabIndex = 1;
- this->Btnload->Text = L"Charger";
- this->Btnload->UseVisualStyleBackColor = true;
- this->Btnload->Click += gcnew System::EventHandler(this, &Form1::Btnload_Click);
- //
- // Form1
- //
- this->AutoScaleDimensions = System::Drawing::SizeF(6, 13);
- this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;
- this->ClientSize = System::Drawing::Size(525, 320);
- this->Controls->Add(this->Btnload);
- this->Controls->Add(this->dataGridView1);
- this->Name = L"Form1";
- this->Text = L"Form1";
- (cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dsArticle1))->EndInit();
- (cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dataGridView1))->EndInit();
- this->ResumeLayout(false);
- }
- #pragma endregion
- private: System::Void Btnload_Click(System::Object^ sender, System::EventArgs^ e)
- {
- dsArticle1::Clear();
- oleDbDataAdapter1::Fill(dsArticle1);
- }
- };
- }
|
Merci beaucoup d'avance pour votre aide avant que je me tape la tête contre les murs
|