In page load we call BindEmployeeDropDownList method
- protected void Page_Load(object sender, EventArgs e)
- {
- if (!IsPostBack)
- {
- BindEmployeeDropDownList();
- }
- }
-
- Public Void BindEmployeeDropDownList()
- {
-
- string strsql1 = string.Empty;
- strsql1 = "select * from Employee order by empid";
- DataTable dtemployee= objDUT.getdata(strsql1);
- if (dtemployee.Rows.Count > 0)
- {
- ddlemployee.DataSource = dt_keyword;
- ddlemployee.DataTextField = "EmpName";
- ddlemployee.DataValueField = "id";
- ddlemployee.DataBind();
- }
- ddlemployee.Items.Insert(0, new ListItem("-Select-", "0"));
- ddlemployee.SelectedValue = "0";
- }