Пример #1
0
    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();
 }