Not ordered data from database

Question

0.00/5 (No votes)

See more:

Hi,

I used this sql statement to retrieve data from database:

SQL

select UserID from  Users

but when i receive data by like this code, the records in dataset is not ordered like in the database table:

lbtnUserID.Text = usersEditDataSet.Tables[0].Rows[0]["UserID"].ToString();

the value of lbtnUserID.Text must be = 1
but it gives me 7

whyyyyyyyyyyyyyyyyy?

I am sure that the data is ordered right in table......

Help me plz

thanks

Posted 26-Dec-10 18:30pm

MrLonely_2

Updated 26-Dec-10 18:31pm

v2

Add a Solution

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)

Al-Farooque Shubho · Accepted Answer · 2010-12-26T18:50:00

Solution 1

You are not using any "Order By" clause in your query. So, the database server is returning the result set in an order which is not having the same order shown in the database table.

Most probably, using an "Order by UserId (Or, Primary key field)" would solve this issue, but, I would recommend you to add a "Where" filter to your query if you need to load a specific user from the database. For example:

SELECT UserId from Users WHERE UserId = 1

Posted 26-Dec-10 18:50pm

Al-Farooque Shubho

Comments

MrLonely_2 27-Dec-10 1:00am

Thanks man........ but i want to get all users from database.......but i did not use order by as i suspect that it will be ordered with primay key field by default.....
but now i used order by and it is succeeded ...... thanks man.......many kisses

Hiren solanki · Accepted Answer · 2010-12-26T19:37:00

Solution 2

There's another alternate way if you don't want to sort at a time of SQL retrieval.

You can also sort from datatable itself using DefaultView

For Ex.

usersEditDataSet.Tables[0].DefaultView.Sort = "UserID ASC";

Posted 26-Dec-10 19:37pm

Hiren solanki

Comments

MrLonely_2 27-Dec-10 7:58am

very good idea.... thank u very much .........