in sql statement somethin worng

Question

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

Riyaz Akhtar · Answer

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 immadi · Answer

thanks and simply perfect

aditya immadi · Answer

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 immadi · Answer

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 Akhtar · Answer

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 Hussain · Answer

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 immadi · Answer

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 Hussain · Answer

Hi, What is the order you need follow? after 166 which record need to be display? Please provide more details Regards, Iftikar

aditya immadi · Answer

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 Lenka · Answer

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.

in sql statement somethin worng

Mahesh Chand