Bonjour, jai un porblème avec un programme qui fonctionner correctement sur un autre ordinateur, mais je l'ai importer sur cet ordinateur et depuis j'ai beaucoup d'erreurs du a Mysql, alors je me suis dit que peut etre il manqué une référence ou autres, mais je ne vois pas laquelle, voici le rapport d'erreurs :
Error 3 error C2653: 'MySql' : is not a class or namespace name i:\fini\dll test unitaite\bdd\bdd\Form1.h 2
Error 4 error C2871: 'MySqlClient' : a namespace with this name does not exist i:\fini\dll test unitaite\bdd\bdd\Form1.h 2
Error 5 error C2143: syntax error : missing ';' before '^' i:\fini\dll test unitaite\bdd\bdd\Form1.h 29
Error 6 error C4430: missing type specifier - int assumed. Note: C++ does not support default-int i:\fini\dll test unitaite\bdd\bdd\Form1.h 29
Error 7 error C4430: missing type specifier - int assumed. Note: C++ does not support default-int i:\fini\dll test unitaite\bdd\bdd\Form1.h 29
Error 8 error C2653: 'MySql' : is not a class or namespace name i:\fini\dll test unitaite\bdd\bdd\Form1.h 62
Error 9 error C2143: syntax error : missing ';' before '^' i:\fini\dll test unitaite\bdd\bdd\Form1.h 62
Error 10 error C4430: missing type specifier - int assumed. Note: C++ does not support default-int i:\fini\dll test unitaite\bdd\bdd\Form1.h 62
Error 11 error C4430: missing type specifier - int assumed. Note: C++ does not support default-int i:\fini\dll test unitaite\bdd\bdd\Form1.h 62
Error 12 error C2653: 'MySql' : is not a class or namespace name i:\fini\dll test unitaite\bdd\bdd\Form1.h 63
Error 13 error C2143: syntax error : missing ';' before '^' i:\fini\dll test unitaite\bdd\bdd\Form1.h 63
Error 14 error C4430: missing type specifier - int assumed. Note: C++ does not support default-int i:\fini\dll test unitaite\bdd\bdd\Form1.h 63
Error 15 error C4430: missing type specifier - int assumed. Note: C++ does not support default-int i:\fini\dll test unitaite\bdd\bdd\Form1.h 63
Error 16 error C2653: 'MySql' : is not a class or namespace name i:\fini\dll test unitaite\bdd\bdd\Form1.h 64
Error 17 error C2143: syntax error : missing ';' before '^' i:\fini\dll test unitaite\bdd\bdd\Form1.h 64
Error 18 error C4430: missing type specifier - int assumed. Note: C++ does not support default-int i:\fini\dll test unitaite\bdd\bdd\Form1.h 64
Error 19 error C4430: missing type specifier - int assumed. Note: C++ does not support default-int i:\fini\dll test unitaite\bdd\bdd\Form1.h 64
Error 20 error C2039: 'mySqlCommand1' : is not a member of 'BDD::Form1' i:\fini\dll test unitaite\bdd\bdd\Form1.h 131
Error 21 error C2653: 'MySql' : is not a class or namespace name i:\fini\dll test unitaite\bdd\bdd\Form1.h 131
Error 22 error C2061: syntax error : identifier 'MySqlCommand' i:\fini\dll test unitaite\bdd\bdd\Form1.h 131
Error 23 error C2039: 'mySqlDataAdapter1' : is not a member of 'BDD::Form1' i:\fini\dll test unitaite\bdd\bdd\Form1.h 132
Error 24 error C2653: 'MySql' : is not a class or namespace name i:\fini\dll test unitaite\bdd\bdd\Form1.h 132
Error 25 error C2061: syntax error : identifier 'MySqlDataAdapter' i:\fini\dll test unitaite\bdd\bdd\Form1.h 132
Error 26 error C2039: 'mySqlConnection1' : is not a member of 'BDD::Form1' i:\fini\dll test unitaite\bdd\bdd\Form1.h 133
Error 27 error C2653: 'MySql' : is not a class or namespace name i:\fini\dll test unitaite\bdd\bdd\Form1.h 133
Error 28 error C2061: syntax error : identifier 'MySqlConnection' i:\fini\dll test unitaite\bdd\bdd\Form1.h 133
Error 29 error C2039: 'mySqlCommand1' : is not a member of 'BDD::Form1' i:\fini\dll test unitaite\bdd\bdd\Form1.h 191
Error 30 error C2227: left of '->Connection' must point to class/struct/union/generic type i:\fini\dll test unitaite\bdd\bdd\Form1.h 191
Error 31 error C2039: 'mySqlCommand1' : is not a member of 'BDD::Form1' i:\fini\dll test unitaite\bdd\bdd\Form1.h 192
Error 32 error C2227: left of '->Transaction' must point to class/struct/union/generic type i:\fini\dll test unitaite\bdd\bdd\Form1.h 192
Error 33 error C2039: 'mySqlDataAdapter1' : is not a member of 'BDD::Form1' i:\fini\dll test unitaite\bdd\bdd\Form1.h 196
Error 34 error C2227: left of '->DeleteCommand' must point to class/struct/union/generic type i:\fini\dll test unitaite\bdd\bdd\Form1.h 196
Error 35 error C2039: 'mySqlDataAdapter1' : is not a member of 'BDD::Form1' i:\fini\dll test unitaite\bdd\bdd\Form1.h 197
Error 36 error C2227: left of '->InsertCommand' must point to class/struct/union/generic type i:\fini\dll test unitaite\bdd\bdd\Form1.h 197
Error 37 error C2039: 'mySqlDataAdapter1' : is not a member of 'BDD::Form1' i:\fini\dll test unitaite\bdd\bdd\Form1.h 198
Error 38 error C2227: left of '->SelectCommand' must point to class/struct/union/generic type i:\fini\dll test unitaite\bdd\bdd\Form1.h 198
Error 39 error C2039: 'mySqlDataAdapter1' : is not a member of 'BDD::Form1' i:\fini\dll test unitaite\bdd\bdd\Form1.h 199
Error 40 error C2227: left of '->UpdateCommand' must point to class/struct/union/generic type i:\fini\dll test unitaite\bdd\bdd\Form1.h 199
Error 41 error C2039: 'mySqlConnection1' : is not a member of 'BDD::Form1' i:\fini\dll test unitaite\bdd\bdd\Form1.h 203
Error 42 error C2227: left of '->ConnectionString' must point to class/struct/union/generic type i:\fini\dll test unitaite\bdd\bdd\Form1.h 203
Error 43 error C2227: left of '->ConnectionString' must point to class/struct/union/generic type i:\fini\dll test unitaite\bdd\bdd\Form1.h 635
Error 44 error C2227: left of '->Open' must point to class/struct/union/generic type i:\fini\dll test unitaite\bdd\bdd\Form1.h 636
Error 45 error C2653: 'MySql' : is not a class or namespace name i:\fini\dll test unitaite\bdd\bdd\Form1.h 767
Error 46 error C2061: syntax error : identifier 'MySqlCommand' i:\fini\dll test unitaite\bdd\bdd\Form1.h 767
Error 47 error C2227: left of '->ExecuteNonQuery' must point to class/struct/union/generic type i:\fini\dll test unitaite\bdd\bdd\Form1.h 768
Error 48 error C2227: left of '->Close' must point to class/struct/union/generic type i:\fini\dll test unitaite\bdd\bdd\Form1.h 834
Error 49 error C2653: 'MySql' : is not a class or namespace name i:\fini\dll test unitaite\bdd\bdd\Form1.h 913
Error 50 error C2061: syntax error : identifier 'MySqlCommand' i:\fini\dll test unitaite\bdd\bdd\Form1.h 913
Error 51 error C2227: left of '->ExecuteNonQuery' must point to class/struct/union/generic type i:\fini\dll test unitaite\bdd\bdd\Form1.h 914
Error 52 error C2653: 'MySql' : is not a class or namespace name i:\fini\dll test unitaite\bdd\bdd\Form1.h 955
Error 53 error C2061: syntax error : identifier 'MySqlCommand' i:\fini\dll test unitaite\bdd\bdd\Form1.h 955
Error 54 error C2227: left of '->ExecuteNonQuery' must point to class/struct/union/generic type i:\fini\dll test unitaite\bdd\bdd\Form1.h 956
Error 55 error C2061: syntax error : identifier 'MySqlCommand' i:\fini\dll test unitaite\bdd\bdd\Form1.h 1034
Error 56 error C2065: 'MyReader' : undeclared identifier i:\fini\dll test unitaite\bdd\bdd\Form1.h 1035
Error 57 error C2227: left of '->ExecuteReader' must point to class/struct/union/generic type i:\fini\dll test unitaite\bdd\bdd\Form1.h 1035
Error 58 error C2065: 'MyReader' : undeclared identifier i:\fini\dll test unitaite\bdd\bdd\Form1.h 1036
Error 59 error C2227: left of '->Read' must point to class/struct/union/generic type i:\fini\dll test unitaite\bdd\bdd\Form1.h 1036
Error 60 error C1903: unable to recover from previous error(s); stopping compilation i:\fini\dll test unitaite\bdd\bdd\Form1.h 1036
et voici mon code (c'est un windows form sous visual studio 2010) :
#pragma once
using namespace MySql::Data::MySqlClient;
namespace BDD {
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
/// </summary>
public ref class Form1 : public System::Windows::Forms::Form
{
public:
Form1(void)
{
InitializeComponent();
//
//TODO: ajoutez ici le code du constructeur
//
}
String^ sql;
MySqlDataReader ^MyReader;
private: System::Windows::Forms::ListBox^ listBox1;
private: System::Windows::Forms::Button^ button10;
private: System::Windows::Forms::TextBox^ textBox19;
private: System::Windows::Forms::Button^ button11;
private: System::Windows::Forms::Button^ button12;
public:
public:
array<String ^, 2>^ tableau;
protected:
/// <summary>
/// Nettoyage des ressources utilisées.
/// </summary>
~Form1()
{
if (components)
{
delete components;
}
}
private: System::Windows::Forms::Button^ button1;
protected:
protected:
private: MySql::Data::MySqlClient::MySqlCommand^ mySqlCommand1;
private: MySql::Data::MySqlClient::MySqlDataAdapter^ mySqlDataAdapter1;
private: MySql::Data::MySqlClient::MySqlConnection^ mySqlConnection1;
private: System::Windows::Forms::Button^ button2;
private: System::Windows::Forms::Button^ button3;
private: System::Windows::Forms::Button^ button4;
private: System::Windows::Forms::TextBox^ textBox1;
private: System::Windows::Forms::TextBox^ textBox2;
private: System::Windows::Forms::TextBox^ textBox3;
private: System::Windows::Forms::TextBox^ textBox4;
private: System::Windows::Forms::TextBox^ textBox5;
private: System::Windows::Forms::Label^ label1;
private: System::Windows::Forms::Label^ label2;
private: System::Windows::Forms::Label^ label3;
private: System::Windows::Forms::Label^ label4;
private: System::Windows::Forms::Label^ label5;
private: System::Windows::Forms::Button^ button5;
private: System::Windows::Forms::TextBox^ textBox6;
private: System::Windows::Forms::TextBox^ textBox7;
private: System::Windows::Forms::TextBox^ textBox8;
private: System::Windows::Forms::TextBox^ textBox9;
private: System::Windows::Forms::TextBox^ textBox10;
private: System::Windows::Forms::Label^ label6;
private: System::Windows::Forms::Label^ label7;
private: System::Windows::Forms::Label^ label8;
private: System::Windows::Forms::Label^ label9;
private: System::Windows::Forms::Label^ label10;
private: System::Windows::Forms::Button^ button6;
private: System::Windows::Forms::TextBox^ textBox11;
private: System::Windows::Forms::TextBox^ textBox12;
private: System::Windows::Forms::TextBox^ textBox13;
private: System::Windows::Forms::TextBox^ textBox14;
private: System::Windows::Forms::TextBox^ textBox15;
private: System::Windows::Forms::TextBox^ textBox16;
private: System::Windows::Forms::TextBox^ textBox17;
private: System::Windows::Forms::Label^ label13;
private: System::Windows::Forms::Button^ button7;
private: System::Windows::Forms::Button^ button8;
private: System::Windows::Forms::TextBox^ textBox18;
private: System::Windows::Forms::Label^ label19;
private: System::Windows::Forms::Button^ button9;
protected:
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)
{
this->button1 = (gcnew System::Windows::Forms::Button());
this->mySqlCommand1 = (gcnew MySql::Data::MySqlClient::MySqlCommand());
this->mySqlDataAdapter1 = (gcnew MySql::Data::MySqlClient::MySqlDataAdapter());
this->mySqlConnection1 = (gcnew MySql::Data::MySqlClient::MySqlConnection());
this->button2 = (gcnew System::Windows::Forms::Button());
this->button3 = (gcnew System::Windows::Forms::Button());
this->button4 = (gcnew System::Windows::Forms::Button());
this->textBox1 = (gcnew System::Windows::Forms::TextBox());
this->textBox2 = (gcnew System::Windows::Forms::TextBox());
this->textBox3 = (gcnew System::Windows::Forms::TextBox());
this->textBox4 = (gcnew System::Windows::Forms::TextBox());
this->textBox5 = (gcnew System::Windows::Forms::TextBox());
this->label1 = (gcnew System::Windows::Forms::Label());
this->label2 = (gcnew System::Windows::Forms::Label());
this->label3 = (gcnew System::Windows::Forms::Label());
this->label4 = (gcnew System::Windows::Forms::Label());
this->label5 = (gcnew System::Windows::Forms::Label());
this->button5 = (gcnew System::Windows::Forms::Button());
this->textBox6 = (gcnew System::Windows::Forms::TextBox());
this->textBox7 = (gcnew System::Windows::Forms::TextBox());
this->textBox8 = (gcnew System::Windows::Forms::TextBox());
this->textBox9 = (gcnew System::Windows::Forms::TextBox());
this->textBox10 = (gcnew System::Windows::Forms::TextBox());
this->label6 = (gcnew System::Windows::Forms::Label());
this->label7 = (gcnew System::Windows::Forms::Label());
this->label8 = (gcnew System::Windows::Forms::Label());
this->label9 = (gcnew System::Windows::Forms::Label());
this->label10 = (gcnew System::Windows::Forms::Label());
this->button6 = (gcnew System::Windows::Forms::Button());
this->textBox11 = (gcnew System::Windows::Forms::TextBox());
this->textBox12 = (gcnew System::Windows::Forms::TextBox());
this->textBox13 = (gcnew System::Windows::Forms::TextBox());
this->textBox14 = (gcnew System::Windows::Forms::TextBox());
this->textBox15 = (gcnew System::Windows::Forms::TextBox());
this->textBox16 = (gcnew System::Windows::Forms::TextBox());
this->textBox17 = (gcnew System::Windows::Forms::TextBox());
this->label13 = (gcnew System::Windows::Forms::Label());
this->button7 = (gcnew System::Windows::Forms::Button());
this->button8 = (gcnew System::Windows::Forms::Button());
this->textBox18 = (gcnew System::Windows::Forms::TextBox());
this->label19 = (gcnew System::Windows::Forms::Label());
this->button9 = (gcnew System::Windows::Forms::Button());
this->listBox1 = (gcnew System::Windows::Forms::ListBox());
this->button10 = (gcnew System::Windows::Forms::Button());
this->textBox19 = (gcnew System::Windows::Forms::TextBox());
this->button11 = (gcnew System::Windows::Forms::Button());
this->button12 = (gcnew System::Windows::Forms::Button());
this->SuspendLayout();
//
// button1
//
this->button1->Location = System::Drawing::Point(12, 12);
this->button1->Name = L"button1";
this->button1->Size = System::Drawing::Size(92, 23);
this->button1->TabIndex = 0;
this->button1->Text = L"connexion";
this->button1->UseVisualStyleBackColor = true;
this->button1->Click += gcnew System::EventHandler(this, &Form1::button1_Click);
//
// mySqlCommand1
//
this->mySqlCommand1->Connection = nullptr;
this->mySqlCommand1->Transaction = nullptr;
//
// mySqlDataAdapter1
//
this->mySqlDataAdapter1->DeleteCommand = nullptr;
this->mySqlDataAdapter1->InsertCommand = nullptr;
this->mySqlDataAdapter1->SelectCommand = nullptr;
this->mySqlDataAdapter1->UpdateCommand = nullptr;
//
// mySqlConnection1
//
this->mySqlConnection1->ConnectionString = L"server=127.0.0.1;User Id=root;database=entrepot";
//
// button2
//
this->button2->Location = System::Drawing::Point(154, 150);
this->button2->Name = L"button2";
this->button2->Size = System::Drawing::Size(105, 20);
this->button2->TabIndex = 1;
this->button2->Text = L"Ajouter un client";
this->button2->UseVisualStyleBackColor = true;
this->button2->Click += gcnew System::EventHandler(this, &Form1::button2_Click);
//
// button3
//
this->button3->Location = System::Drawing::Point(528, 14);
this->button3->Name = L"button3";
this->button3->Size = System::Drawing::Size(28, 23);
this->button3->TabIndex = 2;
this->button3->Text = L"ok";
this->button3->UseVisualStyleBackColor = true;
this->button3->Click += gcnew System::EventHandler(this, &Form1::button3_Click);
//
// button4
//
this->button4->Location = System::Drawing::Point(152, 73);
this->button4->Name = L"button4";
this->button4->Size = System::Drawing::Size(107, 21);
this->button4->TabIndex = 3;
this->button4->Text = L"modifier un client";
this->button4->UseVisualStyleBackColor = true;
this->button4->Click += gcnew System::EventHandler(this, &Form1::button4_Click);
//
// textBox1
//
this->textBox1->Location = System::Drawing::Point(360, 77);
this->textBox1->Name = L"textBox1";
this->textBox1->Size = System::Drawing::Size(92, 20);
this->textBox1->TabIndex = 4;
//
// textBox2
//
this->textBox2->Location = System::Drawing::Point(54, 74);
this->textBox2->Name = L"textBox2";
this->textBox2->Size = System::Drawing::Size(92, 20);
this->textBox2->TabIndex = 5;
//
// textBox3
//
this->textBox3->Location = System::Drawing::Point(54, 98);
this->textBox3->Name = L"textBox3";
this->textBox3->Size = System::Drawing::Size(92, 20);
this->textBox3->TabIndex = 6;
//
// textBox4
//
this->textBox4->Location = System::Drawing::Point(55, 124);
this->textBox4->Name = L"textBox4";
this->textBox4->Size = System::Drawing::Size(92, 20);
this->textBox4->TabIndex = 7;
//
// textBox5
//
this->textBox5->Location = System::Drawing::Point(55, 150);
this->textBox5->Name = L"textBox5";
this->textBox5->Size = System::Drawing::Size(92, 20);
this->textBox5->TabIndex = 8;
//
// label1
//
this->label1->AutoSize = true;
this->label1->Location = System::Drawing::Point(17, 74);
this->label1->Name = L"label1";
this->label1->Size = System::Drawing::Size(16, 13);
this->label1->TabIndex = 9;
this->label1->Text = L"Ip";
this->label1->Click += gcnew System::EventHandler(this, &Form1::label1_Click);
//
// label2
//
this->label2->AutoSize = true;
this->label2->Location = System::Drawing::Point(15, 101);
this->label2->Name = L"label2";
this->label2->Size = System::Drawing::Size(29, 13);
this->label2->TabIndex = 10;
this->label2->Text = L"Nom";
this->label2->Click += gcnew System::EventHandler(this, &Form1::label2_Click);
//
// label3
//
this->label3->AutoSize = true;
this->label3->Location = System::Drawing::Point(15, 129);
this->label3->Name = L"label3";
this->label3->Size = System::Drawing::Size(30, 13);
this->label3->TabIndex = 11;
this->label3->Text = L"Pass";
//
// label4
//
this->label4->AutoSize = true;
this->label4->Location = System::Drawing::Point(15, 152);
this->label4->Name = L"label4";
this->label4->Size = System::Drawing::Size(31, 13);
this->label4->TabIndex = 12;
this->label4->Text = L"Base";
//
// label5
//
this->label5->AutoSize = true;
this->label5->Location = System::Drawing::Point(349, 256);
this->label5->Name = L"label5";
this->label5->Size = System::Drawing::Size(0, 13);
this->label5->TabIndex = 13;
//
// button5
//
this->button5->Location = System::Drawing::Point(12, 41);
this->button5->Name = L"button5";
this->button5->Size = System::Drawing::Size(92, 23);
this->button5->TabIndex = 14;
this->button5->Text = L"deconnexion";
this->button5->UseVisualStyleBackColor = true;
this->button5->Click += gcnew System::EventHandler(this, &Form1::button5_Click);
//
// textBox6
//
this->textBox6->Location = System::Drawing::Point(533, 106);
this->textBox6->Name = L"textBox6";
this->textBox6->Size = System::Drawing::Size(92, 20);
this->textBox6->TabIndex = 15;
//
// textBox7
//
this->textBox7->Location = System::Drawing::Point(533, 73);
this->textBox7->Name = L"textBox7";
this->textBox7->Size = System::Drawing::Size(92, 20);
this->textBox7->TabIndex = 16;
//
// textBox8
//
this->textBox8->Location = System::Drawing::Point(360, 131);
this->textBox8->Name = L"textBox8";
this->textBox8->Size = System::Drawing::Size(92, 20);
this->textBox8->TabIndex = 17;
this->textBox8->TextChanged += gcnew System::EventHandler(this, &Form1::textBox8_TextChanged);
//
// textBox9
//
this->textBox9->Location = System::Drawing::Point(360, 102);
this->textBox9->Name = L"textBox9";
this->textBox9->Size = System::Drawing::Size(92, 20);
this->textBox9->TabIndex = 18;
//
// textBox10
//
this->textBox10->Location = System::Drawing::Point(360, 77);
this->textBox10->Name = L"textBox10";
this->textBox10->Size = System::Drawing::Size(92, 20);
this->textBox10->TabIndex = 19;
//
// label6
//
this->label6->AutoSize = true;
this->label6->Location = System::Drawing::Point(325, 80);
this->label6->Name = L"label6";
this->label6->Size = System::Drawing::Size(29, 13);
this->label6->TabIndex = 20;
this->label6->Text = L"Nom";
//
// label7
//
this->label7->AutoSize = true;
this->label7->Location = System::Drawing::Point(460, 109);
this->label7->Name = L"label7";
this->label7->Size = System::Drawing::Size(71, 13);
this->label7->TabIndex = 21;
this->label7->Text = L"Mot de passe";
//
// label8
//
this->label8->AutoSize = true;
this->label8->Location = System::Drawing::Point(469, 80);
this->label8->Name = L"label8";
this->label8->Size = System::Drawing::Size(58, 13);
this->label8->TabIndex = 22;
this->label8->Text = L"Telephone";
//
// label9
//
this->label9->AutoSize = true;
this->label9->Location = System::Drawing::Point(313, 134);
this->label9->Name = L"label9";
this->label9->Size = System::Drawing::Size(45, 13);
this->label9->TabIndex = 23;
this->label9->Text = L"Adresse";
//
// label10
//
this->label10->AutoSize = true;
this->label10->Location = System::Drawing::Point(315, 105);
this->label10->Name = L"label10";
this->label10->Size = System::Drawing::Size(43, 13);
this->label10->TabIndex = 24;
this->label10->Text = L"Prenom";
//
// button6
//
this->button6->Location = System::Drawing::Point(577, 161);
this->button6->Name = L"button6";
this->button6->Size = System::Drawing::Size(48, 23);
this->button6->TabIndex = 25;
this->button6->Text = L"Valider";
this->button6->UseVisualStyleBackColor = true;
this->button6->Click += gcnew System::EventHandler(this, &Form1::button6_Click);
//
// textBox11
//
this->textBox11->Location = System::Drawing::Point(533, 135);
this->textBox11->Name = L"textBox11";
this->textBox11->Size = System::Drawing::Size(92, 20);
this->textBox11->TabIndex = 26;
//
// textBox12
//
this->textBox12->Location = System::Drawing::Point(475, 14);
this->textBox12->Name = L"textBox12";
this->textBox12->Size = System::Drawing::Size(22, 20);
this->textBox12->TabIndex = 29;
//
// textBox13
//
this->textBox13->Location = System::Drawing::Point(533, 135);
this->textBox13->Name = L"textBox13";
this->textBox13->Size = System::Drawing::Size(92, 20);
this->textBox13->TabIndex = 30;
//
// textBox14
//
this->textBox14->Location = System::Drawing::Point(360, 131);
this->textBox14->Name = L"textBox14";
this->textBox14->Size = System::Drawing::Size(92, 20);
this->textBox14->TabIndex = 31;
//
// textBox15
//
this->textBox15->Location = System::Drawing::Point(533, 106);
this->textBox15->Name = L"textBox15";
this->textBox15->Size = System::Drawing::Size(92, 20);
this->textBox15->TabIndex = 32;
//
// textBox16
//
this->textBox16->Location = System::Drawing::Point(360, 102);
this->textBox16->Name = L"textBox16";
this->textBox16->Size = System::Drawing::Size(92, 20);
this->textBox16->TabIndex = 33;
//
// textBox17
//
this->textBox17->Location = System::Drawing::Point(533, 73);
this->textBox17->Name = L"textBox17";
this->textBox17->Size = System::Drawing::Size(92, 20);
this->textBox17->TabIndex = 34;
//
// label13
//
this->label13->AutoSize = true;
this->label13->Location = System::Drawing::Point(493, 138);
this->label13->Name = L"label13";
this->label13->Size = System::Drawing::Size(34, 13);
this->label13->TabIndex = 40;
this->label13->Text = L"Droits";
//
// button7
//
this->button7->Location = System::Drawing::Point(577, 161);
this->button7->Name = L"button7";
this->button7->Size = System::Drawing::Size(48, 23);
this->button7->TabIndex = 41;
this->button7->Text = L"Valider";
this->button7->UseVisualStyleBackColor = true;
this->button7->Click += gcnew System::EventHandler(this, &Form1::button7_Click);
//
// button8
//
this->button8->Location = System::Drawing::Point(152, 98);
this->button8->Name = L"button8";
this->button8->Size = System::Drawing::Size(107, 20);
this->button8->TabIndex = 42;
this->button8->Text = L"supprimer un client";
this->button8->UseVisualStyleBackColor = true;
this->button8->Click += gcnew System::EventHandler(this, &Form1::button8_Click);
//
// textBox18
//
this->textBox18->Location = System::Drawing::Point(475, 14);
this->textBox18->Name = L"textBox18";
this->textBox18->Size = System::Drawing::Size(22, 20);
this->textBox18->TabIndex = 43;
this->textBox18->TextChanged += gcnew System::EventHandler(this, &Form1::textBox18_TextChanged);
//
// label19
//
this->label19->AutoSize = true;
this->label19->Location = System::Drawing::Point(413, 17);
this->label19->Name = L"label19";
this->label19->Size = System::Drawing::Size(56, 13);
this->label19->TabIndex = 44;
this->label19->Text = L"Entrer l\'id :";
//
// button9
//
this->button9->Location = System::Drawing::Point(528, 14);
this->button9->Name = L"button9";
this->button9->Size = System::Drawing::Size(28, 23);
this->button9->TabIndex = 45;
this->button9->Text = L"ok";
this->button9->UseVisualStyleBackColor = true;
this->button9->Click += gcnew System::EventHandler(this, &Form1::button9_Click);
//
// listBox1
//
this->listBox1->FormattingEnabled = true;
this->listBox1->Location = System::Drawing::Point(407, 60);
this->listBox1->Name = L"listBox1";
this->listBox1->Size = System::Drawing::Size(149, 95);
this->listBox1->TabIndex = 46;
this->listBox1->SelectedIndexChanged += gcnew System::EventHandler(this, &Form1::listBox1_SelectedIndexChanged);
//
// button10
//
this->button10->Location = System::Drawing::Point(528, 14);
this->button10->Name = L"button10";
this->button10->Size = System::Drawing::Size(28, 23);
this->button10->TabIndex = 49;
this->button10->Text = L"ok";
this->button10->UseVisualStyleBackColor = true;
this->button10->Click += gcnew System::EventHandler(this, &Form1::button10_Click);
//
// textBox19
//
this->textBox19->Location = System::Drawing::Point(475, 14);
this->textBox19->Name = L"textBox19";
this->textBox19->Size = System::Drawing::Size(22, 20);
this->textBox19->TabIndex = 50;
//
// button11
//
this->button11->Location = System::Drawing::Point(153, 124);
this->button11->Name = L"button11";
this->button11->Size = System::Drawing::Size(106, 20);
this->button11->TabIndex = 51;
this->button11->Text = L"Voir commande";
this->button11->UseVisualStyleBackColor = true;
this->button11->Click += gcnew System::EventHandler(this, &Form1::button11_Click);
//
// button12
//
this->button12->Location = System::Drawing::Point(120, 12);
this->button12->Name = L"button12";
this->button12->Size = System::Drawing::Size(107, 23);
this->button12->TabIndex = 52;
this->button12->Text = L"annuler";
this->button12->UseVisualStyleBackColor = true;
this->button12->Click += gcnew System::EventHandler(this, &Form1::button12_Click);
//
// Form1
//
this->AutoScaleDimensions = System::Drawing::SizeF(6, 13);
this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;
this->ClientSize = System::Drawing::Size(634, 194);
this->Controls->Add(this->button12);
this->Controls->Add(this->button11);
this->Controls->Add(this->textBox19);
this->Controls->Add(this->button10);
this->Controls->Add(this->listBox1);
this->Controls->Add(this->button9);
this->Controls->Add(this->label19);
this->Controls->Add(this->textBox18);
this->Controls->Add(this->button8);
this->Controls->Add(this->button7);
this->Controls->Add(this->label13);
this->Controls->Add(this->textBox17);
this->Controls->Add(this->textBox16);
this->Controls->Add(this->textBox15);
this->Controls->Add(this->textBox14);
this->Controls->Add(this->textBox13);
this->Controls->Add(this->textBox12);
this->Controls->Add(this->textBox11);
this->Controls->Add(this->button6);
this->Controls->Add(this->label10);
this->Controls->Add(this->label9);
this->Controls->Add(this->label8);
this->Controls->Add(this->label7);
this->Controls->Add(this->label6);
this->Controls->Add(this->textBox10);
this->Controls->Add(this->textBox9);
this->Controls->Add(this->textBox8);
this->Controls->Add(this->textBox7);
this->Controls->Add(this->textBox6);
this->Controls->Add(this->button5);
this->Controls->Add(this->label5);
this->Controls->Add(this->label4);
this->Controls->Add(this->label3);
this->Controls->Add(this->label2);
this->Controls->Add(this->label1);
this->Controls->Add(this->textBox5);
this->Controls->Add(this->textBox4);
this->Controls->Add(this->textBox3);
this->Controls->Add(this->textBox2);
this->Controls->Add(this->textBox1);
this->Controls->Add(this->button4);
this->Controls->Add(this->button3);
this->Controls->Add(this->button2);
this->Controls->Add(this->button1);
this->Name = L"Form1";
this->Text = L"Form1";
this->Load += gcnew System::EventHandler(this, &Form1::Form1_Load);
this->ResumeLayout(false);
this->PerformLayout();
}
#pragma endregion
private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e)
{
String ^ip = textBox2->Text;
String ^nom= textBox3->Text;
String ^pass= textBox4->Text;
String ^base = textBox5->Text;
try
{
mySqlConnection1->ConnectionString = L"server='"+ip+"';User Id='"+nom+"';password='"+pass+"';database='"+base+"'";
mySqlConnection1->Open();
this->button1->Enabled=false;
this->button5->Enabled=true;
this->button2->Enabled=true;
this->button3->Enabled=true;
this->button4->Enabled=true;
this->button8->Enabled=true;
this->textBox1->Enabled=true;
this->textBox2->Visible=false;
this->textBox3->Visible=false;
this->textBox4->Visible=false;
this->textBox5->Visible=false;
this->label1->Visible=false;
this->label2->Visible=false;
this->label3->Visible=false;
this->label4->Visible=false;
this->button11->Enabled=true;
this->button12->Enabled=true;
label5->Text = "Connexion réussie";
}
catch (Exception^ e)
{
label5->Text = "Connexion échouée";
}
}
private: System::Void Form1_Load(System::Object^ sender, System::EventArgs^ e)
{
listBox1->Text="";
this->textBox2->Text="127.0.0.1";
this->textBox3->Text="bastien";
this->textBox4->Text="bastien";
this->textBox5->Text="entrepot";
this->button2->Enabled=false;
this->button3->Enabled=false;
this->button4->Enabled=false;
this->button8->Enabled=false;
this->textBox1->Enabled=false;
this->button5->Enabled=false;
this->button12->Enabled=false;
this->textBox6->Visible=false;
this->textBox7->Visible=false;
this->textBox8->Visible=false;
this->textBox9->Visible=false;
this->textBox10->Visible=false;
this->textBox11->Visible=false;
this->label6->Visible=false;
this->label7->Visible=false;
this->label8->Visible=false;
this->label9->Visible=false;
this->label10->Visible=false;
this->label19->Visible=false;
this->textBox12->Visible=false;
this->button6->Visible=false;
this->label13->Visible=false;
this->label19->Visible=false;
this->textBox1->Visible=false;
this->textBox13->Visible=false;
this->textBox14->Visible=false;
this->textBox15->Visible=false;
this->textBox16->Visible=false;
this->textBox17->Visible=false;
this->textBox18->Visible=false;
this->button10->Visible=false;
this->button7->Visible=false;
this->button3->Visible=false;
this->listBox1->Visible=false;
this->button9->Visible=false;
this->textBox19->Visible=false;
this->button11->Enabled=false;
}
private: System::Void button2_Click(System::Object^ sender, System::EventArgs^ e)
{
this->listBox1->Visible=false;
this->button9->Visible=false;
this->textBox19->Visible=false;
this->textBox12->Visible=false;
this->button3->Visible=false;
this->label6->Visible=true;
this->label7->Visible=true;
this->label8->Visible=true;
this->label9->Visible=true;
this->label10->Visible=true;
this->label13->Visible=true;
this->label19->Visible=false;
this->textBox6->Visible=true;
this->textBox7->Visible=true;
this->textBox8->Visible=true;
this->textBox9->Visible=true;
this->textBox10->Visible=true;
this->textBox11->Visible=true;
this->button6->Visible=true;
this->textBox1->Visible=false;
this->textBox13->Visible=false;
this->textBox14->Visible=false;
this->textBox15->Visible=false;
this->textBox16->Visible=false;
this->textBox17->Visible=false;
this->textBox18->Visible=false;
this->button7->Visible=false;
this->button10->Visible=false;
}
private: System::Void button3_Click(System::Object^ sender, System::EventArgs^ e)
{
String ^Uti_id = textBox12->Text;
try
{
sql= "DELETE FROM `entrepot`.`ent_utilisateur` WHERE `ent_utilisateur`.`Uti_id` = '"+Uti_id+"'";
mySqlCommand1 = gcnew MySql::Data::MySqlClient::MySqlCommand(sql,mySqlConnection1);
mySqlCommand1->ExecuteNonQuery();
label5->Text = "Suppréssion réussie";
textBox12->Text="";
}
catch (Exception ^e)
{
label5->Text = "Suppréssion échouée";
}
}
private: System::Void button4_Click(System::Object^ sender, System::EventArgs^ e)
{
this->label13->Visible=true;
this->label19->Visible=true;
this->listBox1->Visible=false;
this->button9->Visible=false;
this->textBox19->Visible=false;
this->textBox12->Visible=false;
this->button3->Visible=false;
this->textBox1->Visible=true;
this->textBox13->Visible=true;
this->textBox14->Visible=true;
this->textBox15->Visible=true;
this->textBox16->Visible=true;
this->textBox17->Visible=true;
this->textBox18->Visible=true;
this->button7->Visible=true;
this->button10->Visible=true;
this->textBox1->Text="";
this->textBox13->Text="";
this->textBox14->Text="";
this->textBox15->Text="";
this->textBox16->Text="";
this->textBox17->Text="";
this->textBox18->Text="";
this->label6->Visible=true;
this->label7->Visible=true;
this->label8->Visible=true;
this->label9->Visible=true;
this->label10->Visible=true;
this->textBox6->Visible=false;
this->textBox7->Visible=false;
this->textBox8->Visible=false;
this->textBox9->Visible=false;
this->textBox10->Visible=false;
this->textBox11->Visible=false;
}
private: System::Void label1_Click(System::Object^ sender, System::EventArgs^ e) {
}
private: System::Void label2_Click(System::Object^ sender, System::EventArgs^ e) {
}
private: System::Void button5_Click(System::Object^ sender, System::EventArgs^ e)
{
mySqlConnection1->Close();
this->button5->Enabled=false;
this->button1->Enabled=true;
this->button12->Enabled=false;
this->button2->Enabled=false;
this->button3->Enabled=false;
this->button4->Enabled=false;
this->button8->Enabled=false;
this->textBox1->Enabled=false;
this->textBox6->Visible=false;
this->textBox7->Visible=false;
this->textBox8->Visible=false;
this->textBox9->Visible=false;
this->textBox10->Visible=false;
this->textBox11->Visible=false;
this->label6->Visible=false;
this->label7->Visible=false;
this->label8->Visible=false;
this->label9->Visible=false;
this->label10->Visible=false;
this->label19->Visible=false;
this->textBox12->Visible=false;
this->button6->Visible=false;
this->label13->Visible=false;
this->label19->Visible=false;
this->textBox1->Visible=false;
this->textBox13->Visible=false;
this->textBox14->Visible=false;
this->textBox15->Visible=false;
this->textBox16->Visible=false;
this->textBox17->Visible=false;
this->textBox18->Visible=false;
this->button10->Visible=false;
this->button7->Visible=false;
this->button3->Visible=false;
this->listBox1->Visible=false;
this->button9->Visible=false;
this->textBox19->Visible=false;
this->button11->Enabled=false;
this->textBox2->Text="";
this->textBox3->Text="";
this->textBox4->Text="";
this->textBox5->Text="";
this->textBox2->Visible=true;
this->textBox3->Visible=true;
this->textBox4->Visible=true;
this->textBox5->Visible=true;
this->label1->Visible=true;
this->label2->Visible=true;
this->label3->Visible=true;
this->label4->Visible=true;
label5->Text = "Deconnexion réussie";
}
private: System::Void button6_Click(System::Object^ sender, System::EventArgs^ e)
{
String ^Uti_Nom = textBox10->Text;
String ^Uti_Prenom=textBox9->Text;
String ^Uti_Adresse=textBox8->Text;
String ^Uti_Telephone=textBox7->Text;
String ^Uti_Mdp=textBox6->Text;
String ^Uti_Droits=textBox11->Text;
try
{
sql= "INSERT INTO `entrepot`.`ent_utilisateur` (`Uti_Nom`, `Uti_Prenom`, `Uti_Adresse`, `Uti_Telephone`, `Uti_Mdp`, `Uti_Droits`) VALUES ('"+Uti_Nom+"','"+Uti_Prenom+"','"+Uti_Adresse+"','"+Uti_Telephone+"','"+Uti_Mdp+"', '"+Uti_Droits+"');";
mySqlCommand1 = gcnew MySql::Data::MySqlClient::MySqlCommand(sql,mySqlConnection1);
mySqlCommand1->ExecuteNonQuery();
label5->Text = "Insertion réussie";
}
catch (Exception ^e)
{
label5->Text = "Insertion échouée";
}
this->textBox6->Visible=false;
this->textBox7->Visible=false;
this->textBox8->Visible=false;
this->textBox9->Visible=false;
this->textBox10->Visible=false;
this->textBox11->Visible=false;
this->button6->Visible=false;
this->label6->Visible=false;
this->label7->Visible=false;
this->label8->Visible=false;
this->label9->Visible=false;
this->label10->Visible=false;
this->label13->Visible=false;
}
private: System::Void textBox8_TextChanged(System::Object^ sender, System::EventArgs^ e) {
}
private: System::Void label12_Click(System::Object^ sender, System::EventArgs^ e)
{
}
private: System::Void button7_Click(System::Object^ sender, System::EventArgs^ e)
{
String ^Uti_id=textBox18->Text;
String ^Uti_Nom=textBox1->Text;
String ^Uti_Prenom=textBox16->Text;
String ^Uti_Adresse=textBox14->Text;
String ^Uti_Telephone=textBox17->Text;
String ^Uti_Mdp=textBox15->Text;
String ^Uti_Droits=textBox13->Text;
try
{
sql= "UPDATE `entrepot`.`ent_utilisateur` SET `Uti_Nom` = '"+Uti_Nom+"', `Uti_Prenom` = '"+Uti_Prenom+"', `Uti_Adresse`= '"+Uti_Adresse+"', `Uti_Telephone`='"+Uti_Telephone+"', `Uti_Mdp`='"+Uti_Mdp+"', `Uti_Droits`='"+Uti_Droits+"' WHERE `ent_utilisateur`.`Uti_id` ='"+Uti_id+"';";
mySqlCommand1 = gcnew MySql::Data::MySqlClient::MySqlCommand(sql,mySqlConnection1);
mySqlCommand1->ExecuteNonQuery();
label5->Text = "Modification réussie";
}
catch (Exception ^e)
{
label5->Text = "Modification réussie";
}
this->textBox1->Visible=false;
this->textBox13->Visible=false;
this->textBox14->Visible=false;
this->textBox15->Visible=false;
this->textBox16->Visible=false;
this->textBox17->Visible=false;
this->textBox18->Visible=false;
this->textBox19->Visible=false;
this->button8->Visible=false;
this->button10->Visible=false;
this->button8->Visible=false;
this->label6->Visible=false;
this->label7->Visible=false;
this->label8->Visible=false;
this->label9->Visible=false;
this->label10->Visible=false;
this->label13->Visible=false;
this->label19->Visible=false;
}
private: System::Void button8_Click(System::Object^ sender, System::EventArgs^ e)
{
this->listBox1->Visible=false;
this->button9->Visible=false;
this->textBox19->Visible=false;
this->label19->Visible=true;
this->textBox12->Visible=true;
this->button3->Visible=true;
this->textBox1->Visible=false;
this->textBox13->Visible=false;
this->textBox14->Visible=false;
this->textBox15->Visible=false;
this->textBox16->Visible=false;
this->textBox17->Visible=false;
this->textBox18->Visible=false;
this->button7->Visible=false;
this->button10->Visible=false;
this->textBox6->Visible=false;
this->textBox7->Visible=false;
this->textBox8->Visible=false;
this->textBox9->Visible=false;
this->textBox10->Visible=false;
this->textBox11->Visible=false;
this->label6->Visible=false;
this->label7->Visible=false;
this->label8->Visible=false;
this->label9->Visible=false;
this->label10->Visible=false;
this->label13->Visible=false;
label5->Text = "Suppression réussie";
}
private: System::Void label19_Click(System::Object^ sender, System::EventArgs^ e) {
}
private: System::Void textBox18_TextChanged(System::Object^ sender, System::EventArgs^ e) {
}
private: System::Void button9_Click(System::Object^ sender, System::EventArgs^ e)
{
listBox1->Items->Clear();
String ^Com_id = textBox19->Text;
int num=0;
sql= "SELECT COUNT(`Com_id`) FROM `ent_commandes` WHERE `Com_id` = '"+Com_id+"'";
mySqlCommand1 = gcnew MySqlCommand(sql, mySqlConnection1);
MyReader = mySqlCommand1->ExecuteReader();
while (MyReader->Read())
{
num= MyReader->GetInt32(0);
}
MyReader->Close();
num = Convert::ToInt32(Com_id);
array<String ^, 2>^ tableau = gcnew array<String ^, 2>(num,6);
int i=0;
sql = "SELECT `Com_id`,`Com_Date`, `Cam_id`, `Uti_id`, `Traj_id`, `HumTem_id` FROM `ent_commandes` WHERE `Com_id`='"+Com_id+"'" ;
mySqlCommand1 = gcnew MySqlCommand(sql, mySqlConnection1);
MyReader = mySqlCommand1->ExecuteReader();
while (MyReader->Read())
{
tableau[i, 0]= "id :" + MyReader->GetString(0);
tableau[i, 1]= "date :" + MyReader->GetString(1);
tableau[i, 2]= "n° du camion :" + MyReader->GetString(2);
tableau[i, 3]= "n° de l'utilisateur :" + MyReader->GetString(3);
tableau[i, 4]= "n° du trajet :" + MyReader->GetString(4);
tableau[i, 5]= "n° du relevé :" + MyReader->GetString(5);
i++;
}
MyReader->Close();
for(i = 0 ; i<6 ;i++)
listBox1->Items->Add(String::Format(tableau[0,i]));
}
private: System::Void button10_Click(System::Object^ sender, System::EventArgs^ e)
{
String ^Uti_id = textBox18->Text;
int num=0;
sql= "SELECT COUNT(`Uti_id`) FROM `ent_utilisateur` WHERE `Uti_id` = '"+Uti_id+"'";
mySqlCommand1 = gcnew MySqlCommand(sql, mySqlConnection1);
MyReader = mySqlCommand1->ExecuteReader();
while (MyReader->Read())
{
num= MyReader->GetInt32(0);
}
MyReader->Close();
num = Convert::ToInt32(Uti_id);
array<String ^, 2>^ tableau = gcnew array<String ^, 2>(num,6);
int i=0;
sql = "SELECT `Uti_id`,`Uti_Nom`, `Uti_Mdp`, `Uti_Prenom`, `Uti_Adresse`, `Uti_Telephone`, `Uti_Droits` FROM `ent_utilisateur` WHERE `Uti_id`='"+Uti_id+"'" ;
mySqlCommand1 = gcnew MySqlCommand(sql, mySqlConnection1);
MyReader = mySqlCommand1->ExecuteReader();
while (MyReader->Read())
{
tableau[i, 0]= MyReader->GetString(0);
tableau[i, 1]= MyReader->GetString(1);
tableau[i, 2]= MyReader->GetString(2);
tableau[i, 3]= MyReader->GetString(3);
tableau[i, 4]= MyReader->GetString(4);
tableau[i, 5]= MyReader->GetString(5);
i++;
}
MyReader->Close();
for(i = 0 ; i<6 ;i++)
{
textBox1->Text = tableau[0,i];
textBox16->Text = tableau[0,i];
textBox14->Text = tableau[0,i];
textBox17->Text = tableau[0,i];
textBox15->Text = tableau[0,i];
textBox13->Text = tableau[0,i];}
}
private: System::Void listBox1_SelectedIndexChanged(System::Object^ sender, System::EventArgs^ e) {
}
private: System::Void button11_Click(System::Object^ sender, System::EventArgs^ e)
{
this->textBox12->Visible=false;
this->button3->Visible=false;
this->listBox1->Visible=true;
this->button9->Visible=true;
this->textBox19->Visible=true;
this->textBox1->Visible=false;
this->textBox13->Visible=false;
this->textBox14->Visible=false;
this->textBox15->Visible=false;
this->textBox16->Visible=false;
this->textBox17->Visible=false;
this->textBox18->Visible=false;
this->button7->Visible=false;
this->button10->Visible=false;
this->textBox6->Visible=false;
this->textBox7->Visible=false;
this->textBox8->Visible=false;
this->textBox9->Visible=false;
this->textBox10->Visible=false;
this->textBox11->Visible=false;
this->label6->Visible=false;
this->label7->Visible=false;
this->label8->Visible=false;
this->label9->Visible=false;
this->label10->Visible=false;
this->label13->Visible=false;
}
private: System::Void button12_Click(System::Object^ sender, System::EventArgs^ e)
{
this->textBox6->Visible=false;
this->textBox7->Visible=false;
this->textBox8->Visible=false;
this->textBox9->Visible=false;
this->textBox10->Visible=false;
this->textBox11->Visible=false;
this->label6->Visible=false;
this->label7->Visible=false;
this->label8->Visible=false;
this->label9->Visible=false;
this->label10->Visible=false;
this->label19->Visible=false;
this->textBox12->Visible=false;
this->button6->Visible=false;
this->label13->Visible=false;
this->label19->Visible=false;
this->textBox1->Visible=false;
this->textBox13->Visible=false;
this->textBox14->Visible=false;
this->textBox15->Visible=false;
this->textBox16->Visible=false;
this->textBox17->Visible=false;
this->textBox18->Visible=false;
this->button10->Visible=false;
this->button7->Visible=false;
this->button3->Visible=false;
this->listBox1->Visible=false;
this->button9->Visible=false;
this->textBox19->Visible=false;
}
};
}
voila j'attends votre aide, merci à vous