public DataSet FetchReportActivity() { DataSet dsGrp = new DataSet(); Whitfield_Project wUser = new Whitfield_Project(); dsGrp = wUser.GetWorkOrders(ViewState["EstNum"].ToString(), Convert.ToInt32(ViewState["twc_project_number"].ToString())); return dsGrp; }
public void BindWorkOrders() { DataSet dsGrp = new DataSet(); Whitfield_Project wUser = new Whitfield_Project(); dsGrp = wUser.GetWorkOrders(ViewState["EstNum"].ToString(), Convert.ToInt32(ViewState["twc_project_number"].ToString())); if (dsGrp.Tables[0].Rows.Count > 0) { ddlworkorders.DataSource = dsGrp; ddlworkorders.DataTextField = "WODesc"; ddlworkorders.DataValueField = "work_order_id"; ddlworkorders.DataBind(); ddlworkorders.Items.Insert(0, common.AddItemToList("Select WorkOrder", "0")); } }
private void DisplayGrid() { Whitfield_Project _wc = new Whitfield_Project(); DataSet _dsWorkOrders = new DataSet(); _dsWorkOrders = _wc.GetWorkOrders(ViewState["EstNum"].ToString(), Convert.ToInt32(ViewState["twc_project_number"].ToString())); this.PopulateDataGrid(_dsWorkOrders); }
public void BindWorkOrders() { DataSet dsGrp = new DataSet(); Whitfield_Project wUser = new Whitfield_Project(); ddlworkorders.Items.Clear(); dsGrp = wUser.GetWorkOrders(ddlProject.SelectedItem.Value); if (dsGrp.Tables[0].Rows.Count > 0) { ddlworkorders.DataSource = dsGrp; ddlworkorders.DataTextField = "woid"; ddlworkorders.DataValueField = "work_order_id"; ddlworkorders.DataBind(); ddlworkorders.Items.Insert(0, common.AddItemToList("Select WorkOrder", "0")); } else { ddlworkorders.Items.Insert(0, common.AddItemToList("No workorders available", "0")); } }