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