private void setItemGroupDetail(string Query, ComboBox cmb, string Message) { //string selectCommand = "select groupID,GROUPNAME,GROUPDESC from dbo.ItemGroup"; cmb.Items.Clear(); cmb.Items.Add("Select A " + Message); dt = dbMainClass.getDataBoundToComboBox(Query); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { cmb.Items.Add(dr[1].ToString().ToUpper()); if (Message.ToUpper() == "UNIT") { UnitList.Add(dr[0].ToString()); } else { GroupList.Add(dr[0].ToString()); } } dt.Dispose(); } else if (dt != null && dt.Rows.Count == 0) { cmb.Items.Clear(); cmb.Items.Add("Add New " + Message); } cmb.SelectedIndex = 0; }