sql query

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

Hanook12y ago

Possible with sql server...

SELECT *
FROM country
ORDER BY CASE WHEN CoutryName = 'India' THEN 1 ELSE 2 END

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

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;

hope this will help you.

Instead of doing there in the DB, just do it on Code [C#].

If you are using C#,

ddl.Items.Insert(0, itemtobeinserted);