private void BindDropSearch() { ddlDepName.DataSource = DepartmentBLL.GetAllDepartment(); ddlDepName.Items.Insert(0, new ListItem("Select Department", "")); ddlDepName.DataTextField = "Name"; ddlDepName.DataValueField = "DepId"; ddlDepName.DataBind(); }
private void BindData() { dgvDepartment.Rows.Clear(); var depBLL = new DepartmentBLL(); var result = depBLL.GetAllDepartment(); int i = 1; foreach (var item in result) { dgvDepartment.Rows.Add(item.DepartmentID, i++, item.DepartmentName); } }
private void BindGrid(bool isSearch) { //if (ddlDepName.SelectedIndex != -1 && isSearch) //{ // Department obj = new Department(); // obj.DepartmentID = int.Parse(ddlDepName.SelectedValue); // DepartmentBLL depBll = new DepartmentBLL(); // ds = depBll.GetById(obj); //} //else { ds = DepartmentBLL.GetAllDepartment(connection); } DepDisplayGrid.DataSource = ds; DepDisplayGrid.DataBind(); }
protected void CategoryDisplayGrid_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { if ((e.Row.RowState & DataControlRowState.Edit) > 0) { try { DropDownList depList = (DropDownList)e.Row.FindControl("ddlDepName"); depList.DataSource = DepartmentBLL.GetAllDepartment(); depList.DataBind(); depList.DataTextField = "Name"; depList.DataValueField = "DepId"; depList.DataBind(); depList.Items.FindByValue((e.Row.FindControl("lblDep_Id") as Label).Text).Selected = true; DataRowView dr = e.Row.DataItem as DataRowView; depList.SelectedValue = (string)e.Row.DataItem; // you can use e.Row.DataItem to get the value } catch (Exception exo) { } } } }
private void BindGrid(bool isSearch) { if (ddlCatName.SelectedIndex != -1 && isSearch) { Category obj = new Category(); obj.CategoryID = int.Parse(ddlCatName.SelectedValue); CategoryBLL ins = new CategoryBLL(); ds = ins.GetById(obj); } else { ds = CategoryBLL.GetAllCategories(); } CategoryDisplayGrid.DataSource = ds; CategoryDisplayGrid.DataBind(); DropDownList depList = (DropDownList)CategoryDisplayGrid.FooterRow.FindControl("ddlAddDepName"); depList.DataSource = DepartmentBLL.GetAllDepartment(); depList.DataBind(); depList.DataTextField = "Name"; depList.DataValueField = "DepId"; depList.DataBind(); }
private void GetAllDepartment() { departmentGridView.DataSource = aDepartmentBll.GetAllDepartment(); }