private void FillServicelevel()
{
//objSQLdb = new SQLDB();
objServicedb = new ServiceDB();
DataTable dt = new DataTable();
cbLevels.DataSource = null;
try
{
dt = objServicedb.GetServiceLevels(CommonData.CompanyCode, CommonData.BranchType).Tables[0];
//string strCmd = "SELECT desig_code,desig_name,ndesig_name FROM DESIG_MAS "+
// " WHERE dept_code IN(800000) ORDER BY ndesig_name ";
//dt = objSQLdb.ExecuteDataSet(strCmd).Tables[0];
if (dt.Rows.Count > 1)
{
DataRow dr = dt.NewRow();
dr[0] = "0";
dr[1] = "--Select--";
dt.Rows.InsertAt(dr, 0);
cbLevels.DataSource = dt;
cbLevels.DisplayMember = "desig_name";
cbLevels.ValueMember = "desig_code";
}
dt = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
objServicedb = null;
}
}
