How Can I Perform This Function In Asp.Net C#

Question

0.00/5 (No votes)

See more:

i want that when user is log-in with the Id and password he should be directed to the page of the user same like facebook. where the user log-in with the user id and password and his profile get opened.
i know about the simple login like

Quote:
SqlDataAdapter myadp = new SqlDataAdapter();
myadp.SelectCommand = new SqlCommand();
myadp.SelectCommand.Connection = con;
con.Open();
myadp.SelectCommand.CommandText = "select * from shantanu where Id=@un and password=@ps";
myadp.SelectCommand.Parameters.AddWithValue("@un", TextBox1.Text);
myadp.SelectCommand.Parameters.AddWithValue("@ps", TextBox2.Text);
SqlDataReader mydr;
mydr = myadp.SelectCommand.ExecuteReader();

Quote:
con.Close();

but i want to display the data associated with it on the next page.
kindly help me.

Posted 7-Feb-14 23:52pm

Shantanu sinha

Add a Solution

Comments

[no name] 8-Feb-14 5:57am

" data associated with it" means what kind of data..??

5 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)

OriginalGriff · Answer 1 · 2014-02-07T23:56:00

Solution 1

So store it - either in Cookies or the Session, and read the values back on the next page. You can then display them perfectly happily.

Posted 7-Feb-14 23:56pm

OriginalGriff

Comments

Shantanu sinha 8-Feb-14 8:07am

any example or link for the same.

Snehasish_Nandy · Answer 2 · 2014-02-08T00:02:00

Solution 2

This will give you more idea about what OriginalGriff suggested

send-data-from-one-page-to-another-in-c-sharp-asp-net[^]

Posted 8-Feb-14 0:02am

Snehasish_Nandy

Comments

Shantanu sinha 8-Feb-14 8:06am

any example or link for the same.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 3 · 2014-02-08T01:00:00

Solution 3

After login is successful redirect to Home Page.
Just run another query to get all the Profile details from the table taking the UserName as a condition.
Then show these information on Home Page.

Store any value on Session, which you want to access across all the pages of the Application.

Posted 8-Feb-14 1:00am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Shantanu sinha 8-Feb-14 8:06am

any example or link for the same.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 8-Feb-14 9:02am

Okay, refer the below and explore.

1. http://www.aspdotnet-suresh.com/2012/11/aspnet-session-state-example-in-c-vbnet.html
2. http://www.codeproject.com/Questions/159329/how-to-use-sessions-in-asp-net-using-c-sharp-code
3. http://msdn.microsoft.com/en-us/library/ms178581(v=vs.100).aspx

abhijitmalkar · Answer 4 · 2014-02-08T01:25:00

Solution 4

-- You can store mydr in a session like

Session["mydr"]=mydr;

--- By using above this you can access from any page
--- But you have to do unboxing like

mydr=(SqlDataReader) Session["mydr"];

Posted 8-Feb-14 1:25am

abhijitmalkar

Comments

Shantanu sinha 8-Feb-14 8:06am

any example or link for the same.

NitishBharadwaj · Answer 5 · 2014-02-08T01:30:00

Solution 5

You can use session to share and save data like that
session[username]= "nitish"

Posted 8-Feb-14 1:30am

NitishBharadwaj

Comments

Shantanu sinha 8-Feb-14 8:06am

any example or link for the same.