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