How to get logged user id c#

Total Post:341

Points:2389
C# 
C#
 1544  View(s)
Ratings:
Rate this:

I have created a simple login page but I got problem with getting logged in user ID

public partial class LoginwithEncryption : System.Web.UI.Page
{
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conStr"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand(
            "select * from dbo.UserInfo where Login =@Login and Password=@Password", con);
        cmd.Parameters.AddWithValue("@Login", txtUserName.Text);
        cmd.Parameters.AddWithValue("@Password", txtPWD.Text);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            Response.Redirect("StartPage.aspx");
        }
        else
        {
            ClientScript.RegisterStartupScript(Page.GetType(), "validation",
                "<script language='javascript'>alert('Invalid UserName and Password')</script>");
        }
    }
}

How can I get ID of user after login (I'm able to login) ? I tried few methods but it won't work?

  1. Post:412

    Points:2888
    Re: How to get logged user id c#

    Hi Ankit,

    Based on the info you have provided all you have to do is just extract the row data from the datatable containing the logged in user.

    For example:

     //Extract data
     User objUser = new User();
     objUser.Id = int.parse(dt.Rows[0]["ID"].ToString());
     objUser.Login = dt.Rows[0]["Login"].ToString();
     objUser.Password = dt.Rows[0]["Password"].ToString();
     objUser.Type= int.parse(dt.Rows[0]["Password"].ToString());

      Modified On Apr-03-2018 06:37:27 AM

Answer