Display all users from Database and If I select anyone user, I need to show all details of the selected user

Question

0.00/5 (No votes)

See more:

ASP.NET

<li class="dropdown">
          <a href="#" class="dropdown-toggle" data-toggle="dropdown">Groups <span class="caret"></span><span style="font-size:16px;" class="pull-right hidden-xs showopacity glyphicon glyphicon-user"></span></a>
          <ul class="dropdown-menu forAnimate" role="menu">
            <li ><a href="#">Group Details<span style="font-size:16px;" class="pull-right hidden-xs showopacity glyphicon glyphicon-th-list"><asp:DropDownList runat="server" CssClass="required form-control" ID="DropDownList1"></asp:DropDownList>
                
                              </span></a></li> 
            </ul>   
               </li>

i need idea for this..how to fetch all the details from database using one table id..please any1 help me..If i select any1 user from dropdownlist,it shows all the details of that user...
please can anyone tel me about basic code..am beginner of c#

Posted 3-Feb-16 20:27pm

Member 12081616

Updated 3-Feb-16 20:41pm

VR Karthikeyan

v3

Add a Solution

Comments

Sinisa Hajnal 4-Feb-16 3:12am

Google for a bit and you'll find it. There are several ways, one of the worst of them includes returning everything at once. Why would you retrieve data about 100 users if page user will only look at the details of two or three of them?

Instead, fetch IDs and names or whatever you're showing and when the user is selected, go to the database and fetch the details needed.

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)

VR Karthikeyan · Answer 1 · 2016-02-03T21:09:00

Hi, Consider, you are having user table named "AllUsers" as follows,

UserId	UserName	PhoneNumber	Address
User1	John	4567891234	Xyz
User2	David	9987123456	Abc
User3	Richard	8529784562	Def

Now just select the UserName from the table using the following query,

SQL

Select UserName from AllUsers

It will returns the list of UserNames. Bind this to your DropDown List.
And Now, When your are selecting an user from dropdown menu, you will have a single UserName, store it to a string property like SelectedUser. In this case, consider the SelectedUser as John.
Then use the following query to get the details about John,

SQL

Select * from AllUsers Where UserName='John'

It returns the entire row like the following,

UserId	UserName	PhoneNumber	Address
User1	John	4567891234	Xyz