How TO Set Default Value In Combobox

[amitpshelke]

HI,

I am using combox, the values comes dynamically from database.
ex: combobox shows values such as category: food, clothes, watches...ect

now when the form loads i want to show ''ALL" as default category.
without entering "ALL" as values in database.

"ExecuteCommandReturnDataTable" is method defined in connection.cs file
i dont want to make any changes in it.

also my code look likes

MyConnection con = new MyConnection();
                string sql;
                sql = "select PlayerCatID, PlayerCatName from  
                         tblcms_mst_PlayerCategory";
                DataTable dt;
                dt = (DataTable)con.ExecuteCommandReturnDataTable(sql);
                cmbPlayerCategory.DataSource = dt;
                cmbPlayerCategory.DisplayMember = "PlayerCatName";
                cmbPlayerCategory.ValueMember = "PlayerCatID";
                cmbPlayerCategory.Name = "PlayerCategoryName";
                con.disposeMe();
 

[kenobewan]

I believe that you can alter your datatable before using it as the datasource. HTH.