private void RefreshData() { var customerorders = imsdb.Orders.Where(x => x.CustomerName == ddlSelectCustomer.SelectedItem.ToString()).ToList(); GridViewCustomerOrders.DataSource = customerorders; GridViewCustomerOrders.DataBind(); }
protected void ddlSelectCustomer_SelectedIndexChanged(object sender, EventArgs e) { string getcustomer = ddlSelectCustomer.SelectedItem.ToString(); var customerorders = imsdb.Orders.Where(x => x.CustomerName == getcustomer).ToList(); var countOrder = imsdb.Orders.Where(x => x.CustomerName == getcustomer).ToList().Count(); if (ddlSelectCustomer.SelectedValue == "0") { lblCustomerName.Text = " "; lblTotalOrder.Text = " "; GridViewCustomerOrders.DataSource = customerorders; GridViewCustomerOrders.DataBind(); } else { lblCustomerName.Text = ddlSelectCustomer.SelectedItem.ToString(); lblTotalOrder.Text = countOrder.ToString(); GridViewCustomerOrders.DataSource = customerorders; GridViewCustomerOrders.DataBind(); } }