sql query

Question

hi I have country dropdownlist I am binding it from database I want to display india first is it possible to with sql query

Praneet Rane · Answer

Use following query : select -1 as Id, 'India' as Country union select id,Country from CountryMaster

Hanook · Answer

Possible with sql server... SELECT * FROM country ORDER BY CASE WHEN CoutryName = 'India' THEN 1 ELSE 2 END

Girish Sapariya · Answer

Hi , i agree with Jignesh, if you are known to the index of "India" then you can use his code dropDownList1.SelectedIndex = 5; and if you dont know the index then try this, Assuming that your Combobox is bind with a list of string having Country Names only foreach(string str in dropDownList1.ItemsSource) { if(str.Equals("India") { dropDownList1.SelectedItem = str; break; } } Here i had iterate the list in your dropDownList1, and when I find India, just select that in your combobox and break the loop. Hope this will help you

Jignesh Trivedi · Answer

hi, I think if you have knowledge about value of Id field of India" than you can use selectedIndex property to select any value from drop down list. dropDownList1.SelectedIndex = 5; Please refer http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.dropdownlist.selectedindex%28v=vs.110%29.aspx hope this will help you.

Jaganathan Bantheswaran · Answer

Instead of doing there in the DB, just do it on Code [C#]. If you are using C#, ddl.Items.Insert(0, itemtobeinserted);

sql query

Answers (5)