How to display the data from database in asp.net

Question

1.00/5 (1 vote)

See more:

Hello Friends,

am working on asp.net, i have two pages in my project.

first page is login page
second page is retrieve data from database based on login dropdown selection.

In first page(Login Page) I have Dropdownlist(departmentList) and Textbox(password)
and a login button.

User will select the department from dropdown and then next he enters the password, and clicks on login button.
When User clicks on login button, In second page I have 3 textboxes to retrieve data from database according to dropdownlist.

In database I have Stored data with in these fields,

Dept_code,Password,Salary,TelephoneNo,ManagerName.(TableName DeptInfo)

Dept_code - IT (This will display in dropdownlist(loginPage) )
Password - This is used for login
Salary - this should display in textbox after login( it must retrieve from DB)
Telephone - this should also display in textbox after login ( it must retrieve from DB)
Manager Name - this should also display in textbox after login ( it must retrieve from DB)

Please can you help me , how to solve this.

already i have completed login page , and now am in second page with textboxes.

Please help.

THANKS.

Posted 27-Apr-13 23:52pm

Software Engineer 892

Add a Solution

Comments

[no name] 28-Apr-13 7:23am

"how to solve this"... the exact same way the you have already been told.

1 solution

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)

ShivKrSingh · Accepted Answer · 2013-04-28T00:44:00

you can do the following:

on First Page(Login) :

you need to put your dropdown selectedValue in session to move it to the next page.

after successfull login: On second page you first need to get that values from session. and Then you the following...

XML

<pre lang="cs">
string sessValue = Conver.ToString(Session["youSessionName"]);
youConectionName.Open();
SqlCommand cmd = new SqlCommand("Select * from DeptInfo where DeptCode='" + sessValue + "'", youConectionName);

SqlDataReader dr = cmd.ExecuteReader();
        if (dr.HasRows)
        {
            Salary.Text  = rd["Salary"].ToString();
            Telephone.Text =rd["TelephoneNo"].ToString();
            Manager Name.Text=rd["ManagerName"].ToString();
        }
        else
        {
            //Code will reach here if no records found.
        }
</pre>

you can call this on page load or on button click as you want...

This will definately help you....