How to use session in login page.In my login page i have
2labels(username,password),
2 textboxes and
1button.
the following code is my login page using stored proc.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("Data Source=ATSSERVER\\SQLEXPRESS;Initial Catalog=arun;User ID=sa;Password=mis@12345");
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = new SqlCommand("chkusr",con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter s1 = new SqlParameter("@username", TextBox1.Text);
SqlParameter s2 = new SqlParameter("@password", TextBox2.Text);
cmd.Parameters.Add(s1);
cmd.Parameters.Add(s2);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
Response.Write("Login Success");
}
else
{
Response.Write("Login failed");
}
}
}