save userid in session in asp.net

Question

0.00/5 (No votes)

See more:

there is a userid in user table and it is primary key and i want to save this userid in session ..
when user upload documnet his/her userid save in documnet table in document table there is userid column ..

how i done this ?/

this is the image of dcoument table it shows me 0 userid

http://i43.tinypic.com/300a82b.png[^]

and here is the code of login.aspx.cs

C#

protected void Btn_Login_Click(object sender, EventArgs e)
       {
          try
           {
            int users = aa.SignIn(txt_username.Value, txt_pass.Value);
               int user_id;
               if (Session["UserID"] != null)
               {
                   user_id = Convert.ToInt32(Session["UserID"].ToString());
               }
                  if (users == 1)
                   {
                       Session["Login2"] = txt_username.Value;

                       Session["UserTypeID"] = users;

                       Response.Redirect("AdminOp.aspx");
                   }
                   else if (users == 2)
                   {
                       //Session["UserID"] = aa.SignIn(txt_username.Value, txt_pass.Value);


                       Session["Login2"] = txt_username.Value;

                       Session["UserTypeID"] = users;

                       Response.Redirect("upload.aspx");
                   }
               }
           catch
           {
               Label8.Text = "Incorrect User Name or Password";
           }
       }
   }
   }

plzz help

Posted 6-Oct-13 4:51am

Diya Ayesa

Add a Solution

Comments

Diya Ayesa 6-Oct-13 10:51am

i want to show which user id upload document

Azee 6-Oct-13 11:56am

Hey there, user is just being logged in in your Btn_login_Click, then how are you getting an ID from the Session: user_id = Convert.ToInt32(Session["UserID"].ToString());?

Diya Ayesa 6-Oct-13 11:59am

i add in upload.aspx.cs code in load page ............if (Session["UserID"] != null)
{
//Store the value into a variable
int userId = Convert.ToInt32(Session["UserID"]); //you could also use Convert.ToInt32(Session["UserID"]);
}

Azee 6-Oct-13 12:02pm

If you can get the userid from Session on Upload.aspx, then what is the problem now?

Diya Ayesa 6-Oct-13 12:31pm

when i upload document and then i check my document table it show me userid 0 ..check image which i posted

Azee 6-Oct-13 12:34pm

Please add code of upload operation in your question.

Diya Ayesa 6-Oct-13 12:36pm

here is the code of upload.....if (FileUploadControl.PostedFile != null && FileUploadControl.PostedFile.ContentLength > 0)
{
if
(FileUploadControl.FileContent.Length < 100000)
{
string filename = Path.GetFileName(FileUploadControl.PostedFile.FileName);
string folder = Server.MapPath("~/Docfiles/");
Directory.CreateDirectory(folder);
FileUploadControl.PostedFile.SaveAs(Path.Combine(folder, filename));
try
{
cc.upload1(Txt_docde.Value, txt_dname.Value, FileUploadControl.FileName, Convert.ToInt32(Docdrop.SelectedValue), Convert.ToInt32(DropDownList2.SelectedValue), Convert.ToString(Session["Login2"]),Convert.ToInt32(Session["UserID"]));
StatusLabel.ForeColor = System.Drawing.Color.Green;
StatusLabel.Text = "Success";
}
catch
{
StatusLabel.ForeColor = System.Drawing.Color.Red;
StatusLabel.Text = "Failed";

}
}
else
{
StatusLabel.ForeColor = System.Drawing.Color.Red;
StatusLabel.Text = "File Size to big";
}

Azee 6-Oct-13 13:00pm

In all your code, there isn't one line that SAVES UserID in Session, Do have any code where you are doing this:

Session["UserID"] = SomeValue?

Diya Ayesa 6-Oct-13 13:02pm

i done this i page loadddd of login.aspx.cs and upload.aspx.cs

Diya Ayesa 6-Oct-13 13:03pm

look this...if (!Page.IsPostBack)
{
DMSLIB.DocTypee dtt = new DMSLIB.DocTypee();
Docdrop.DataSource = dtt.getfile();
Docdrop.DataValueField = "DocTypeID";
Docdrop.DataTextField = "DocType";
Docdrop.DataBind();

DMSLIB.DepType DEP = new DMSLIB.DepType();
DropDownList2.DataSource = DEP.getdep();
DropDownList2.DataValueField = "DepID";
DropDownList2.DataTextField = "DepType";
DropDownList2.DataBind();

if (Session["UserID"] != null)
{
//Store the value into a variable
int userId = Convert.ToInt32(Session["UserID"]); //you could also use Convert.ToInt32(Session["UserID"]);
}

Azee 6-Oct-13 13:08pm

This code:
if (Session["UserID"] != null)
{
//Store the value into a variable
int userId = Convert.ToInt32(Session["UserID"]); //you could also use Convert.ToInt32(Session["UserID"]);
}
gets UserID from Session.
You need to save UserID to session before you can get from it.

Diya Ayesa 6-Oct-13 13:04pm

can u tell me..

Azee 6-Oct-13 13:06pm

Where? I don't see it
The UserID is supposed to be the ID of the user who logged in, so according to my understanding, you should get UserID when you verify User Name and Password, and according to your code, this line should return the UserID of the verified User:
int users = aa.SignIn(txt_username.Value, txt_pass.Value);, isn't it?

manvendra patel 6-Oct-13 13:20pm

plz write
if (Session["userid"] != null)//bbefore postback
{
int userId = Convert.ToInt32(Session["UserID"]);

if (!IsPostBack)
{

}
}
else
{
respone.redirect("login.aspx");
}

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

manvendra patel · Answer 1 · 2013-10-06T05:04:00

Solution 1

plz Create UserId field in document table same as user table .and when u add file than insert userid within Document table (userid in field).and userid you will takes as input from session variable which keeps userid. thankyou

Posted 6-Oct-13 5:04am

manvendra patel

Comments

Diya Ayesa 6-Oct-13 11:35am

i also add userid field in document table and in usertable and i also insert userid in sp..this is sp ..

ALTER procedure [dbo].[upload5]
@DocDesciption nvarchar(50),
@DocName nvarchar(50),
@Uploadfile nvarchar(50),
@DocTypeID int,
@DepID int,

@UploadedBy nvarchar(50),
@UserID int
as
insert into DocumentInfo(DocDesciption,DocName,UploadedDate,Uploadfile,DocTypeID,DepID,UploadedBy,UserID )
values(@DocDesciption,@DocName,GETDATE(),@Uploadfile,@DocTypeID,@DepID,@UploadedBy,@UserID )

manvendra patel · Answer 2 · 2013-10-06T07:26:00

Solution 2

plz write
if (Session["userid"] != null)//before postback
{
int userId = Convert.ToInt32(Session["UserID"]);//before postback

if (!IsPostBack)
{

}
}
else
{
respone.redirect("login.aspx");
}

Posted 6-Oct-13 7:26am

manvendra patel