public void FillCheckedBoxList(CheckBoxList chkList, string strSQL, string strValue, string strText, string strDisplay) { SqlConnection conFillChk = new SqlConnection(strConnectionString);//new SqlConnection(ConfigurationManager.AppSettings.Get("Connectionstring")); conFillChk.Open(); SqlCommand cmdFillChk = new SqlCommand(strSQL, conFillChk); cmdFillChk.CommandTimeout = 0; SqlDataReader rdrFillChk = cmdFillChk.ExecuteReader(); chkList.DataSource = rdrFillChk; chkList.DataValueField = strValue; chkList.DataTextField = strText; chkList.DataBind(); chkList.Dispose(); rdrFillChk.Close(); rdrFillChk.Dispose(); conFillChk.Close(); conFillChk.Dispose(); GC.Collect(); }
public void Cleanup() { shimsContext?.Dispose(); FixTimes?.Dispose(); DropDownListScheduleType?.Dispose(); DropDownListDays?.Dispose(); DropDownListTime?.Dispose(); LblDomain?.Dispose(); LblMessages?.Dispose(); LblLastRun?.Dispose(); LbOptions?.Dispose(); LbSelections?.Dispose(); Selections?.Dispose(); PnlFieldMappings?.Dispose(); TblFieldMappings?.Dispose(); TxtAreaEntityExclusions?.Dispose(); BtnRunManually?.Dispose(); CheckBoxListDays?.Dispose(); CbDelete?.Dispose(); FrequencyOptions?.Dispose(); adsyncadmin?.Dispose(); SizeLimitTextBox?.Dispose(); }