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