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;
}