1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| c.cmd = c.cn.CreateCommand();
c.cmd.CommandText = "select PPR, CIN, Nom, Prenom , DateNaissance , EtabliLe from Agent where PPR = " + Session["Code"] ;
if (c.cn.State == ConnectionState.Closed)
{
c.cn.Open();
}
SqlDataReader dr = c.cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
TextBox_PPR.Text = dr[0].ToString();
TextBox_CIN.Text = dr[1].ToString();
TextBox_nom.Text = dr[2].ToString();
TextBox_prenom.Text = dr[3].ToString();
TextBox_dn.Text = dr[4].ToString();
TextBox_Etablile.Text = dr[5].ToString(); |
Partager