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();
        }
    }