private void _FillCombo() { ECCMS db = new ECCMS(); try { DataTable dtProvince = db.lkpProvinceCollection.GetAllAsDataTable(); ECCCommon.FillCombo(ref drpProvince, dtProvince, "ProvNameEng", "ProvId", true); } finally { db.Dispose(); db.Close(); } }
private void _FillCombo() { ECCMS db = new ECCMS(); try { DataTable dtProvince = db.lkpProvinceCollection.GetAllAsDataTable(); ECCCommon.FillCombo(ref drpProvince, dtProvince, "ProvNameEng", "ProvId", true); DataTable dtAllagType = db.lkpAllegationtypeCollection.GetAllAsDataTable(); ECCCommon.FillCombo(ref drpAllegationType, dtAllagType, "AllagType_Name", "AllagType_ID", true); DataTable dtBit = db.lkpBitCollection.GetAllAsDataTable(); ECCCommon.FillCombo(ref drpKuchi, dtBit, "BitName", "BitID", true); ECCCommon.FillCombo(ref drpAppeal, dtBit, "BitName", "BitID", true); DataTable dtGender = db.lkpGendersCollection.GetAllAsDataTable(); ECCCommon.FillCombo(ref drpGender1, dtGender, "GenderName", "GenderID", true); ECCCommon.FillCombo(ref drpGender2, dtGender, "GenderName", "GenderID", true); DataTable dtCompType = db.lkpComplainanttypeCollection.GetAllAsDataTable(); ECCCommon.FillCombo(ref drpComplaintType, dtCompType, "Comp_Name", "Comp_TypeID", true); DataTable dtRespType = db.lkpRespondanttypeCollection.GetAllAsDataTable(); ECCCommon.FillCombo(ref drpRespondantType, dtRespType, "RespType_Name", "RespType_ID", true); DataTable dtRespOffice = db.lkpResponsibleOfficeCollection.GetAllAsDataTable(); ECCCommon.FillCombo(ref drpResponOffice, dtRespOffice, "Resp_OfficeName", "Resp_OfficeID", true); DataTable dtSanc = db.lkpSanctionCollection.GetAllAsDataTable(); ECCCommon.FillCombo(ref drpSanctTypr, dtSanc, "SacntionName", "SacntionID", true); DataTable dtPro = db.lkpCasepriorityCollection.GetAllAsDataTable(); ECCCommon.FillCombo(ref drpCasePro, dtPro, "caseProName", "caseProID", true); DataTable dtStatus = db.lklStatusCollection.GetAsDataTable("Active=1", "StatusID"); ECCCommon.FillCombo(ref drpStatus, dtStatus, "StatusName", "StatusID", true); } finally { db.Dispose(); db.Close(); } }