29/11/2011
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Security;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Drawing;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Integrated Security=True;Connect Timeout=30;User Instance=True") ;
con.Open();
SqlCommand cmd = new SqlCommand("select pw from identification where nom='" + TextBox1.Text + "', con");
SqlDataReader dr = cmd.ExecuteReader();
if (!dr.Read())
{
Label1.Text="Verifier votre Nom D'utilisateur";
this.Label1.ForeColor = Color.Red;
}
else
{
if (dr[0].ToString() == TextBox2.Text)
Response.Redirect("login-success.aspx");
else
Label1.Text="Verifier votre Mot de passe";
this.Label1.ForeColor = Color.Red;
}
con.Close();
}
}
