protected void fillddl() { DataTable dtcomemail = new DataTable(); DataTable dtempemail = new DataTable(); MasterCls clsMaster = new MasterCls(); dtempemail = clsMaster.SelectEmpEmail(Convert.ToInt32(Session["EmployeeIdep"])); if (dtempemail.Rows.Count > 0) { if (dtempemail.Rows[0]["Email"] != System.DBNull.Value) { empeml = dtempemail.Rows[0]["Email"].ToString(); } } dtcomemail = clsMaster.SelectCompanyEmailForEmp(Convert.ToInt32(Session["EmployeeIdep"])); ddlempemail.DataSource = dtcomemail; ddlempemail.DataBind(); ddlempemail.Items.Insert(0, "-Select-"); ddlempemail.SelectedItem.Value = "0"; if (empeml != "") { ddlempemail.Items.Insert(1, empeml); ddlempemail.SelectedIndex = 1; } }
protected void Fillddlemployee() { MasterCls clsMaster = new MasterCls(); DataTable dt = new DataTable(); dt = clsMaster.SelectEmployeewithDesgDeptName(ddlbusiness.SelectedValue); ddlemployee.DataSource = dt; ddlemployee.DataBind(); ddlemployee.Items.Insert(0, "All"); ddlemployee.SelectedItem.Value = "0"; }
protected void FillGridDesignationwithDept() { DataTable dt; dt = new DataTable(); clsMaster = new MasterCls(); dt = clsMaster.SelectDesignationMasterwithDataDept(ddlbusiness.SelectedValue); //dt = clsMaster.SelectDesignationMasterwithDept(6); grdDesignation.DataSource = dt; DataView myDataView = new DataView(); myDataView = dt.DefaultView; if (hdnsortExp.Value != string.Empty) { myDataView.Sort = string.Format("{0} {1}", hdnsortExp.Value, hdnsortDir.Value); } grdDesignation.DataBind(); }