public string retourMarraine(string condition)
{
string identifiant = "";
try
{
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand())
{
cmd.CommandText = "SELECT_MARRAINE";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@noms", 100, DbType.String, condition));
IDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
if (rd["NomsMarraine"] == DBNull.Value)
{
FrmMariage fr = new FrmMariage();
fr.marraineTxt.ReadOnly = false;
}
else
{
identifiant = rd["NomsMarraine"].ToString();
FrmMariage fr = new FrmMariage();
fr.marraineTxt.ReadOnly = true;
}
}
rd.Close();
rd.Dispose();
cmd.Dispose();
}
}
catch (Exception ex)
{
MessageBox.Show("Une exception est survenue : " + ex.Message);
}
return(identifiant);
}
private void button1_Click(object sender, EventArgs e)
{
FrmMariage fr = new FrmMariage();
fr.ShowDialog();
}
