Comment appeller une variable locale d'une instance dans une autre classe?
Bonjour,
Mon 1er fichier : connection_BDD.cs
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
| using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Security.Cryptography.X509Certificates;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
namespace firipo2
{
public class Connection_BDD
{
public void FFconnection_BDD()
{
MySqlConnection connexion = new MySqlConnection("database=test;server=localhost;user id=root;pwd=");
try
{
connexion.Open();
}
catch (MySqlException co)
{
MessageBox.Show(co.ToString());
MessageBox.Show("Non Connecte");
}
}
}
} |
Mon 2eme fichier : Form1.cs
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89
| using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
namespace firipo2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
Connection_BDD connection_BDD = new Connection_BDD();
connection_BDD.FFconnection_BDD();
string insertQuery = "INSERT INTO employes(CAISSE,PRODUIT) VALUES (1,'Coca')";
MySqlCommand command = new MySqlCommand(insertQuery, connexion);
try
{
if (command.ExecuteNonQuery() == 1)
{
// MessageBox.Show("Data Inserted");
}
else
{
MessageBox.Show("Data Not Inserted");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
connexion.Close();
}
private void button2_Click(object sender, EventArgs e)
{
MySqlConnection connexion = new MySqlConnection("database=test;server=localhost;user id=root;pwd=");
try
{
connexion.Open();
// MessageBox.Show("Connecte");
}
catch (MySqlException co)
{
MessageBox.Show(co.ToString());
MessageBox.Show("Non Connecte");
}
string insertQuery = "INSERT INTO employes(CAISSE,PRODUIT) VALUES (1,'Sprite')";
MySqlCommand command = new MySqlCommand(insertQuery, connexion);
try
{
if (command.ExecuteNonQuery() == 1)
{
// MessageBox.Show("Data Inserted");
}
else
{
MessageBox.Show("Data Not Inserted");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
connexion.Close();
MessageBox.Show("Non Connecte");
}
}
} |
La variable local de connection_BDD.cs (connexion), n'est pas reconnu dans Form1.cs.
Pouvez-vous m'aider?