in sql statement somethin worng

aditya immadi

hai firends... i have a small problem...my case is when i'm pulling the particular records from database i write the code like this...my problem is the records are not displaying as my wish
they are binding in alphabetical order in my datalist..i want the records as per the. below identitiesthat means id the recor id is 166 then that record must be in first ..can any one help ....

con.Open();

            string str = "select * from Candidate where id in(166,175,85,91,155,14,276,5,54,43,314,149,137)";

            SqlCommand cmd = new SqlCommand(str, con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);

Thanks and Regards

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

aditya immadi13y ago
thanks and simply perfect
Riyaz Akhtar13y ago
There was typo mistake in above query, try this

SELECT CASE
WHEN id in(166,175,85,91,155) THEN 1
WHEN id in(14,276,5,54,43) THEN 2
ELSE 3 END as ordr, *
from Candidate WHERE id in(166,175,85,91,155,14,276,5,54,43,314,149,137)
order by ordr asc
aditya immadi13y ago
Msg 195, Level 15, State 10, Line 2 'id' is not a recognized built-in function name. it say this error Mr.Iftikar Thanks and regards
aditya immadi13y ago
there is no relation in between those records but client wants 25 particular records in startup page in 5 rows and 5 columns the the first record which has the identity 166 is the head of the department and last record is which has identity 137 is general manager who is lower designation in top 25 jobs.,,and my task is pull and display records as per the given identities list Thnaks and Regards
Riyaz Akhtar13y ago
Hi Aditya,

try something like below SQL query:

select CASE
WHEN id (166,175,85,91,155) THEN 1
WHEN id (14,276,5,54,43) THEN 2
ELSE 3 END as ordr, *
from Candidate WHERE id in(166,175,85,91,155,14,276,5,54,43,314,149,137)
order by ordr asc
Iftikar Hussain13y ago
what is relation between these two row value?
1st row - 166,175,85,91,155
2nd row - 14,276,5,54,43
what should come for 3rd row?

Regards,
Iftikar
aditya immadi13y ago
hi,
i need records which has identity 166,175,85,91,155 in first row
and i need records which are has the idenity 14,276,5,54,43 in second row.....etc etc

thanks and regards
Iftikar Hussain13y ago
Hi,
What is the order you need follow? after 166 which record need to be display? Please provide more details

Regards,
Iftikar
aditya immadi13y ago
ya Sanjeeb your right,but i need display records as per the id's given not in asc or desc order that mean the record which id has 166 taht record must display in first row and first column (asume we have 5*5 records)
Sanjeeb Lenka13y ago
hi,

try the below query.

string str = "select * from Candidate where id in(166,175,85,91,155,14,276,5,54,43,314,149,137)order by id desc";

Mark it as answered it it helps you.