protected void Page_Load(object sender, EventArgs e)
{
LblEmployeeID.Visible = false;
if (!IsPostBack)
{
DdlHEmployeeID.Focus();//set focus on EmployeeID
EmployeeID_Fill();
}
}
/// <summary>
/// Method Name:EmployeeID_Fill
/// Description: Get the data from table bind with control
/// </summary>
public void EmployeeID_Fill()
{
ConstantMessages objconst;
//DdlHEmployeeID.Items.Clear();
StringBuilder strBrInsert;
SqlConnection sqlconn;
sqlconn = new SqlConnection();
SqlCommand sqlcmd;
SqlDataAdapter sqladapter;
DataTable dttable;
strBrInsert = new StringBuilder("SELECT EmployeeID");
strBrInsert.Append(" FROM Employees");
try
{
sqlconn.ConnectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString;
sqlconn.Open();
sqlcmd = new SqlCommand(strBrInsert.ToString(), sqlconn);
sqladapter = new SqlDataAdapter(sqlcmd);
dttable = new DataTable();
sqladapter.Fill(dttable);
DdlHEmployeeID.DataSource = dttable;
DdlHEmployeeID.DataTextField = "EmployeeID";
DdlHEmployeeID.DataValueField = "EmployeeID";
DdlHEmployeeID.DataBind();
}
catch (Exception)
{
objconst = new ConstantMessages();
Response.Redirect(objconst.strerrorpage);
}
finally
{
if (sqlconn.State == ConnectionState.Open)
{
sqlconn.Close();
}
objconst = null;
strBrInsert = null;
sqlconn = null;
sqlcmd = null;
sqladapter = null;
dttable = null;
}
}
