please i got these example on your site but the solution is using session which throws errors if session expies. i want to
remove section from login, i dont want to fetch username with session
string userName;
protected void ValidateUser(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("Validate_User"))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Email", LoginINNOVATION.UserName);
cmd.Parameters.AddWithValue("@Password", (LoginINNOVATION.Password));
cmd.Connection = con;
con.Open();
userName = Convert.ToString(cmd.ExecuteScalar());
con.Close();
}
if (!string.IsNullOrEmpty(userName) && userName != "-1" && userName != "-2")
{
FormsAuthentication.RedirectFromLoginPage(LoginINNOVATION.UserName, LoginINNOVATION.RememberMeSet);
Session["userName"] = userName;
}
else
{
switch (Convert.ToInt32(userName))
{
case -1:
LoginINNOVATION.FailureText = "Username or password not correct.";
break;
case -2:
LoginINNOVATION.FailureText = "Account has not been activated.";
break;
}
}
}
}
}
landing page
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (this.Page.User.Identity.IsAuthenticated)
{
this.GetUserDetail();
}
}
}
private void GetUserDetail()
{
string str = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
string getADPOST = "GetUSERPRO";
using (SqlConnection con = new SqlConnection(str))
{
con.Open();
using (SqlCommand cmd = new SqlCommand(getADPOST, con))
{
cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@Id", this.Page.User.Identity.IsAuthenticated);
cmd.Parameters.AddWithValue("@UserName", Session["userName"]);
// cmd.Parameters.AddWithValue("@UserName", username);
cmd.Parameters.AddWithValue("@FriendUserName", Session["userName"]);
cmd.Parameters.AddWithValue("@Name", Session["userName"]);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable ds = new DataTable();
da.Fill(ds);
// System.Web.HttpContext.Current.Session["UserName"] = dt.Rows[0]["ImageName"];
// System.Web.HttpContext.Current.Session["UserName"] = dt.Rows[0]["Name"];
userprofile.DataSource = ds;
userprofile.DataBind();
{
{
}
}
}
}
}