Session id redirect issue

i have login form,in which i am loggin from User Name and password ,at the befhalf of user name and password i am retreiving user id in session,but when page is redirect then just first ID of table is being retreived every time.

below is c# code

using (SqlCommand cmd = new SqlCommand("Validate_User"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Username", username.Text.Trim());
cmd.Parameters.AddWithValue("@Password", password.Text.Trim());
cmd.Connection = con;
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
// lblmsg.Text = "Login Successful";
Session["S_ID"] = dt.Rows[0]["S_ID"].ToString();
Response.Redirect("issue_std_Books.aspx");
}
else
{
// lblmsg.Text = "Invalid UserName/Password";
}
con.Close();
con.Dispose();
}
}

SQl store procedure

ALTER PROCEDURE [dbo].[Validate_User]
@Username NVARCHAR(20),
@Password NVARCHAR(20)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @UserId INT
SELECT @UserId = S_ID
FROM tbl_Student WHERE [S_Name] = @Username AND t_pwd = @Password
IF @UserId IS NOT NULL
BEGIN
SELECT S_ID FROM tbl_Student
END
end

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg6y ago
Accepted answer
Okay. Then store particular value in session and access it. But as per your code Session["S_ID"] = dt.Rows[0]["S_ID"].ToString(); it will only access the zero index. Take care of that. Thanks.
+1
Akhter HUssain6y ago
i do not want to store multiple value,i just want to pass relevent user id t
0
Salman Beg6y ago
Hi. Every time it is retriving first id of table because you are using index of 0 in the line number 16 of your c# code. If you need multiple values then store in array or list and assign those values to session. In your next page get those values from session. Thanks.
0