/// <summary>
/// Name:BindDropDown
/// Decription:Bind dropdown.
/// Author:Monal shah
/// Created Date:2010/11/11
/// </summary>
private void BindDropDown()
{
try
{
objDt = new DataTable();
objcl.GetSqlStmt = objcl.SelectQuery(ConstantMessage.TableName);
objDt = objcl.DataTables();
if (objDt.Rows.Count > 0)
{
for (int intI = 0; intI < objDt.Rows.Count; intI++)
{
EmployeeListItem.Add(new ListItem(Convert.ToString(objDt.Rows[intI]["EmpName"])));
}
this.DdlEmployee.DataSource = objDt;
this.DdlEmployee.DataBind();
Cache.Add("EmployeeList", EmployeeListItem, null, Cache.NoAbsoluteExpiration, System.TimeSpan.FromSeconds(60), CacheItemPriority.High, null);
}
}
catch (Exception)
{ Response.Redirect("Error.aspx", false); }
finally
{
objcl = null;
objDt.Dispose();
EmployeeListItem = null;
}
}
/// <summary>
/// Name:BindDropDown
/// Decription:Bind dropdown.
/// Author:Monal shah
/// Created Date:2010/11/11
/// </summary>
private void BindDropDown()
{
try
{
objDt = new DataTable();
objcl.GetSqlStmt = objcl.SelectQuery(ConstantMessage.TableName);
objDt = objcl.DataTables();
if (objDt.Rows.Count > 0)
{
this.DdlEmployee.DataSource = objDt;
this.DdlEmployee.DataBind();
}
}
catch (Exception)
{ Response.Redirect("Error.aspx", false); }
finally
{
objcl = null;
objDt.Dispose();
}
}