private void RefreshData()
    {
        var customerorders = imsdb.Stores.Where(x => x.StoreName == ddlSelectStoreName.SelectedItem.ToString()).ToList();

        GridViewStoresProduct.DataSource = customerorders;
        GridViewStoresProduct.DataBind();
    }
    protected void ddlSelectStoreName_SelectedIndexChanged(object sender, EventArgs e)
    {
        string getstorename = ddlSelectStoreName.SelectedItem.ToString();
        var    stores       = imsdb.Products.Where(x => x.StoreName == getstorename).ToList();
        var    countProduct = imsdb.Products.Where(x => x.StoreName == getstorename).ToList().Count();

        if (ddlSelectStoreName.SelectedValue == "0")
        {
            lblStoreName.Text                = " ";
            lblTotalProduct.Text             = " ";
            GridViewStoresProduct.DataSource = stores;
            GridViewStoresProduct.DataBind();
        }
        else
        {
            lblStoreName.Text                = ddlSelectStoreName.SelectedItem.ToString();
            lblTotalProduct.Text             = countProduct.ToString();
            GridViewStoresProduct.DataSource = stores;
            GridViewStoresProduct.DataBind();
        }
    }