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
| public Afficher(FAQ.MyData data)
{
InitializeComponent();
MySqlDataReader wReader = null;
int idTable = 12;
// Instancier lobjet Command
MySqlCommand cmd = new MySqlCommand ( "SELECT * FROM faq WHERE erreur = '" + data.erreur + "'", Home.wConnexion );
MySqlParameter _param = new MySqlParameter();
_param.ParameterName = "'" + data.erreur + "'";
_param.Value = idTable;
// Lecture des résultats
cmd.Parameters.Add(_param);
wReader = cmd.ExecuteReader();
// Remplir le textbox
while (wReader.Read())
{
string wItem = wReader["erreur"].ToString();
string wItems = wReader["descriptif"].ToString();
string wItem1 = wReader["type"].ToString();
textBox1.Text = (wItem);
textBox2.Text = (wItems);
comboBox1.Text = (wItem1);
}
} |
Partager