login page:
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\codem\Documents\Visual Studio 2012\WebSites\WebSite12\App_Data\Database.mdf;Integrated Security=True");
string s="select * from login where mobile='"+txtMobile.Text+"'and password='"+txtPassword.Text+"'";
SqlCommand cmd = new SqlCommand(s,con);
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count>0)
{
Session["a"] = "gmail";
Response.Redirect("home.aspx");
}
else
{
Response.Write("fail");
}
con.Close();
}
Home page.aspx
protected void Page_Load(object sender, EventArgs e)
{
if (Session["a"] != null)
{
}
else
{
Response.Redirect("home.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Session.Remove("a");
Response.Redirect("login.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\codem\Documents\Visual Studio 2012\WebSites\WebSite12\App_Data\Database.mdf;Integrated Security=True");
string s="select * from login where mobile='"+txtMobile.Text+"'and password='"+txtPassword.Text+"'";
SqlCommand cmd = new SqlCommand(s,con);
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count>0)
{
Session["a"] = "gmail";
Response.Redirect("home.aspx");
}
else
{
Response.Write("fail");
}
con.Close();
}
Home page.aspx
protected void Page_Load(object sender, EventArgs e)
{
if (Session["a"] != null)
{
}
else
{
Response.Redirect("home.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Session.Remove("a");
Response.Redirect("login.aspx");
}