comment je peut s'identifier avec session dans asp.net

Question

protected void Button1_Click1(object sender, EventArgs e)
{ //login page et la validation de user et password dans BD:

        string r = "";
        SqlConnection cn = new SqlConnection("Data Source=DESKTOP-F59JVLO;Initial Catalog=GestionCommerciale;Integrated Security=True");
        cn.Open();
        SqlCommand cmd = new SqlCommand("select concat(Nom,' ',Prenom)as utilisateur, Mot_Passe  from Gestionnaire where CONCAT(Nom,' ',Prenom)=@a and Mot_Passe=@b ", cn);
        cmd.Parameters.AddWithValue("@a",TextBox1.Text);
        cmd.Parameters.AddWithValue("@b",TextBox2.Text);
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            r = dr[0].ToString();
        }
        dr.Close();
        cn.Close();
        if (TextBox1.Text != null)
        {
            Session["log"] = TextBox1.Text;
            Response.Redirect("MiseAjourClient.aspx?login=" + TextBox1.Text);
        }
        else
        {
            Response.Write("le nom de l'utilisateur ou Mot de passe incorrect!");
        }
    }

Answer 1

Hi @HIND BENKOUCH ,
According to your description and codes,I'm guessing that your problem is you can't use session when the user login.
In your codes,I have a problem.You shouldn't check if the textbox is null. You should check if the "r" is null after read the data.

Best regards
Yijing Sun

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our  documentation  to enable e-mail notifications if you want to receive the related email notification for this thread.