public void FillCombo1(System.Web.UI.WebControls.DropDownList lst, ref tblAttributes objtblAttr, bool blnSelectAll, int intSelectedId, bool blnAutoPostBack) { SqlDataReader objReader = null; try { FillDataReader obj = new FillDataReader(); //If con Is Nothing Then DBConnectionOpenDynamic(0); //End If if ((objReader != null)) { if (objReader.IsClosed == false) { objReader.Close(); } } objReader = obj.fn_FillDataReader(ref objtblAttr, con); lst.AutoPostBack = blnAutoPostBack; lst.DataSource = objReader; lst.DataTextField = objtblAttr.strDisplayField; lst.DataValueField = objtblAttr.strValueField; lst.DataBind(); if (intSelectedId != 0) { lst.SelectedValue = Convert.ToString(intSelectedId); } if (blnSelectAll == true) { lst.Items.Insert(0, "-- Not Applicable --"); } } catch (Exception ex) { if (objtblAttr.strProc != "sp_getIUDErrorDetails") { saveErrorDetails(objtblAttr.strQuery, objtblAttr.strProc, returnStringFromArr(objtblAttr.strOutputStringArr), HttpContext.Current.Request.RawUrl, "fillcombo", ex.Message); } } finally { if (con != null) { if (con.State == ConnectionState.Open) { con.Close(); } } if (objReader != null) { if (objReader.IsClosed == false) { objReader.Close(); } } } }
public void FillRadioListBox(System.Web.UI.WebControls.RadioButtonList lst, ref tblAttributes objtblAttr, bool blnAutoPostBack, int intSelectedId) { SqlDataReader objReader = null; try { DBConnectionOpenDynamic(0); FillDataReader obj = new FillDataReader(); if ((objReader != null)) { if (objReader.IsClosed == false) { objReader.Close(); } } objReader = obj.fn_FillDataReader(ref objtblAttr, con); lst.AutoPostBack = blnAutoPostBack; if (intSelectedId != 0) { lst.SelectedValue = Convert.ToString(intSelectedId); } lst.DataSource = objReader; lst.DataTextField = objtblAttr.strDisplayField; lst.DataValueField = objtblAttr.strValueField; lst.RepeatColumns = objtblAttr.intColumn; //lst.RepeatDirection = objtblAttr.strRepeateDirection; lst.DataBind(); } catch (Exception ex) { if (objtblAttr.strProc != "sp_getIUDErrorDetails") { saveErrorDetails(objtblAttr.strQuery, objtblAttr.strProc, returnStringFromArr(objtblAttr.strOutputStringArr), HttpContext.Current.Request.RawUrl, "RLB", ex.Message); } } finally { if (con != null) { if (con.State == ConnectionState.Open) { con.Close(); } } if (objReader != null) { if (objReader.IsClosed == false) { objReader.Close(); } } } }
public void FillListBox(System.Web.UI.WebControls.ListBox lst, ref tblAttributes objtblAttr, bool blnAutoPostBack) { SqlDataReader objReader = null; try { FillDataReader obj = new FillDataReader(); DBConnectionOpenDynamic(0); if (objReader != null) { if (objReader.IsClosed == false) { objReader.Close(); } } objReader = obj.fn_FillDataReader(ref objtblAttr, con); lst.AutoPostBack = blnAutoPostBack; lst.DataSource = objReader; lst.DataTextField = objtblAttr.strDisplayField; lst.DataValueField = objtblAttr.strValueField; lst.DataBind(); } catch (Exception ex) { if (objtblAttr.strProc != "sp_getIUDErrorDetails") { saveErrorDetails(objtblAttr.strQuery, objtblAttr.strProc, returnStringFromArr(objtblAttr.strOutputStringArr), HttpContext.Current.Request.RawUrl, "LB", ex.Message); } } finally { if (con != null) { if (con.State == ConnectionState.Open) { con.Close(); } } if (objReader != null) { if (objReader.IsClosed == false) { objReader.Close(); } } } }