// sets datasources and bind data to controls. private void Bind() { var service = new Service(); GridViewOrders.DataSource = service.GetMembersWithOrderStatistics(SortExpression); GridViewOrders.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { //只检索当前用户的订单 SqlDataSourceOrders.SelectCommand = string.Format("SELECT * FROM [Orders] WHERE UserId IN (SELECT UserId from [aspnet_Users] WHERE UserName='******')", User.Identity.Name); //绑定数据 GridViewOrders.DataBind(); }
private void RefreshData() { var data = imsdb.Orders.OrderByDescending(d => d.Id).ToList(); GridViewOrders.DataSource = data; GridViewOrders.DataBind(); }
/// <summary> /// Sets datasources and bind data to controls. /// </summary> private void Bind() { // Retrieve orders via Customer Facade. var repository = new CustomerRepository(); GridViewOrders.DataSource = repository.GetCustomersWithOrderStatistics(SortExpression); GridViewOrders.DataBind(); }
/// <summary> /// Sets datasources and bind data to controls. /// </summary> private void Bind() { // Retrieve orders via Customer Facade. CustomerController controller = new CustomerController(); GridViewOrders.DataSource = controller.GetCustomersWithOrderStatistics(SortExpression); GridViewOrders.DataBind(); }
protected void ButtonCompleteDeal_Command(object sender, CommandEventArgs e) { string confirmValue = Request.Form["confirm_value"]; if (confirmValue == "Yes") // Ok во всплывающем окне { GridViewOrders.DeleteRow(GridViewOrders.SelectedIndex); // удаление записи из GridView и как следствие из БД Ordergoods } }
protected void UpdatePanel1_Load(object sender, EventArgs e) { //Populate Orders grid Order order = new Order(); DataTable dataTable = order.ToDataTable(order.GetAllOrders()); GridViewOrders.DataSource = dataTable; GridViewOrders.DataBind(); }
private void filter() { String date = ddlOrderDate.Text; String id = txtID.Text; String name = txtCName.Text; String rep = ddlSalesManager.Text; DataSet ds = obj.filter_BBL(date, id, name, rep); Cache.Remove("ds"); Cache.Insert("ds", ds); labelCID.Text = "CID: " + (String)ViewState["CID"]; GridViewOrders.DataSource = Cache.Get("ds"); GridViewOrders.DataBind(); }
/// <summary> /// Sets datasources and bind data to controls. /// </summary> private void Bind() { // Get customer via Customer Repository. var repository = new CustomerRepository(); ActionServiceReference.Customer customer = repository.GetCustomerWithOrders(CustomerId); // Set company name LabelHeader.Text = "<font color='black'>Orders for:</font> " + customer.Company + " (" + customer.Country + ")"; GridViewOrders.DataSource = customer.Orders; GridViewOrders.DataBind(); }
// sets datasources and bind data to controls. private void Bind() { // get member var service = new Service(); var member = service.GetMember(MemberId); // set company name LabelHeader.Text = "<font color='black'>Orders for:</font> " + member.CompanyName + " (" + member.Country + ")"; GridViewOrders.DataSource = service.GetOrdersByMember(MemberId); GridViewOrders.DataBind(); }
protected void GridViewEmployees_SelectedIndexChanged(object sender, EventArgs e) { GridView gridView = (sender as GridView); if (gridView != null) { System.Threading.Thread.Sleep(3000); NORTHWNDEntities context = new NORTHWNDEntities(); List <Order> orders = context.Orders.Where(x => x.EmployeeID == (int)gridView.SelectedValue).ToList <Order>(); GridViewOrders.DataSource = orders; GridViewOrders.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataSet ds = obj.GetUserOrders_BLL(); Cache.Insert("ds", ds); GridViewOrders.DataSource = ds; GridViewOrders.DataBind(); ddlSalesManager.DataSource = obj.GetSalesManager_BBL(); ddlSalesManager.DataTextField = "CustRouteRep"; ddlSalesManager.DataValueField = "CustRouteRep"; ddlSalesManager.DataBind(); ddlSalesManager.Items.Insert(0, new ListItem(String.Empty, String.Empty)); ddlSalesManager.SelectedIndex = 0; } }
protected void txtSearch_TextChanged(object sender, EventArgs e) { var data = imsdb.Orders.Where(d => d.OrderDate.ToString() == txtSearch.Text || d.CustomerName.Contains(txtSearch.Text) || d.CustomerPhone.Contains(txtSearch.Text) || d.Id.ToString() == txtSearch.Text || d.ProductName.Contains(txtSearch.Text) || d.Quantity.ToString() == txtSearch.Text || d.Rate.ToString() == txtSearch.Text || d.Amount.ToString() == txtSearch.Text || d.Vat.ToString() == txtSearch.Text || d.ServiceCharge.ToString() == txtSearch.Text || d.Discount.ToString() == txtSearch.Text || d.NetAmount.ToString() == txtSearch.Text).ToList(); GridViewOrders.DataSource = data; GridViewOrders.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["typeid"].ToString() != "2") { Response.Redirect("~/Login/Login.aspx"); } } catch (Exception) { Response.Redirect("~/Login/Login.aspx"); } if (!IsPostBack) { var data = imsdb.Orders.OrderByDescending(d => d.Id).ToList(); GridViewOrders.DataSource = data; GridViewOrders.DataBind(); } }
protected void GridViewOrders_Sorting(object sender, GridViewSortEventArgs e) { if (e.SortExpression == (string)ViewState["SortColumn"]) { // We are resorting the same column, so flip the sort direction e.SortDirection = ((SortDirection)ViewState["SortColumnDirection"] == SortDirection.Ascending) ? SortDirection.Descending : SortDirection.Ascending; } // Apply the sort DataTable dataTable = GridViewOrders.DataSource as DataTable; dataTable.DefaultView.Sort = e.SortExpression + (string)((e.SortDirection == SortDirection.Ascending) ? " ASC" : " DESC"); ViewState["SortColumn"] = e.SortExpression; ViewState["SortColumnDirection"] = e.SortDirection; GridViewOrders.DataSource = dataTable; GridViewOrders.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (HttpContext.Current.User.Identity.IsAuthenticated) { var email = HttpContext.Current.User.Identity.Name.Trim(); if (!IsPostBack) { int userID = GetSignedInUserID(email); DataTable datTable = GetOrders(userID); if (datTable != null && datTable.Rows.Count > 0) { GridViewOrders.DataSource = datTable; GridViewOrders.DataBind(); } else { divAlertMessage.Visible = true; divAlertMessage.Attributes["class"] = "alert fade in alert-error"; LabelAlertMessage.Text = "There are no order records."; } } } }
protected void GridViewOrders_PageIndexChanging(object sender, GridViewPageEventArgs e) { GridViewOrders.PageIndex = e.NewPageIndex; GridViewOrders.DataBind(); }
protected void GridViewOrders_RowEditing(object sender, GridViewEditEventArgs e) { GridViewOrders.EditIndex = e.NewEditIndex; GridViewOrders.DataSource = Cache.Get("ds"); GridViewOrders.DataBind(); }
protected void GridViewOrders_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { GridViewOrders.EditIndex = -1; GridViewOrders.DataSource = Cache.Get("ds"); GridViewOrders.DataBind(); }
private void UpdateGridViewOrders() { GridViewOrders.DataSource = DataAccess.selectQuery("Select * from Orders where UID=" + id); GridViewOrders.DataBind(); }
private void GridViewOrdersBind() { GridViewOrders.DataSource = Connection.dbTable("SELECT * FROM clients_order"); GridViewOrders.DataBind(); }