how to tag user id in my member table

Question

1.00/5 (1 vote)

See more:

Hello!!

I have two table in my database. one is memberinfor table & another is userinfo table.

In Memberinfor table i have 5 column (member_id,member_name,user_id,branch,status)
In userinfo table i have 5 columns (User_id,User_name,password,mailid,Branch)

I also have a log in page & through this page i can logged in in my web project.
I can create new members through add member page & this member information also insert in my memberinfo table.

Now if any user logged in (through username & password) & create any new member then how to tag this user id in my memberinfo table??? please help me with code & example...

Posted 15-Apr-13 18:43pm

prodipjsr

Add a Solution

Comments

PrashantSonewane 16-Apr-13 0:51am

Have you tried something? Can you give code block you have tried and tell us whats not working?

prodipjsr 16-Apr-13 0:55am

No, actually, i have no idea about this..can u give me any idea??

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)

Praveen Kumar Chauhan (PRK) · Answer 1 · 2013-04-15T19:57:00

Solution 2

on your login page when you are validating user authentication, save userid in Session and use that id through out project for manipulating data and info on pages

Posted 15-Apr-13 19:57pm

Praveen Kumar Chauhan (PRK)

Comments

prodipjsr 16-Apr-13 2:11am

please give little example with code..i have create session in my log in page..

[no name] 16-Apr-13 2:57am

session.add("userid","1") for adding; than session["userid"] will return value, use that value to insert in memebrinfo table where ever u are using insert method on pages in project,

prodipjsr 16-Apr-13 3:26am

Thanx for ur idea..it is work,,but i want to some different...

I have add the code in login.aspx page:
if (result >= 1)
{
Session["userName"] = txtUserName.Text.ToString().Trim();
Response.Redirect("Default.aspx");
}
else
lblMsg.Text = "Incorrect Username or Password";

===============
And i also add this code to my members pare.
string userid = Session["userName"].ToString();
myCommand.Parameters.Add("@userid", System.Data.SqlDbType.VarChar, 10).Value = userid;

In these code i can insert user name in my memberinfo table..but i want to insert only user_code, not user_name..how i do this??

[no name] 16-Apr-13 3:41am

how ur getting result in ur code, create a session["userid"] = result it will work if ur retriving userid from database

prodipjsr 16-Apr-13 3:57am

can i use this code?
session["userid"]= "select User_id from userinfo where user_name=session["Username"]";

i am not sure..can i use it or some thing others??

[no name] 16-Apr-13 4:14am

no man u have to retrieve using sqlcommand, and than put is session
projects download projects from here and see how it is working

prodipjsr · Answer 2 · 2013-04-15T19:48:00

Solution 1

Hello sir,

please give me the idea how can i do this========

Posted 15-Apr-13 19:48pm

prodipjsr

Comments

Sergey Alexandrovich Kryukov 6-May-13 2:10am

Not an answer, should be removed.
—SA