Find DropDownList Item By Text in GridView HeaderTemplate using C#

Hi Vincenzo67,

Refer below code.

HTML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" OnRowDataBound="RowDataBound"
    EmptyDataText="No Record Found!" AllowPaging="true" OnPageIndexChanging="OnPaging">
    <Columns>
        <asp:BoundField HeaderText="Contact Name" DataField="ContactName" />
        <asp:TemplateField>
            <HeaderTemplate>
                <asp:DropDownList ID="ddlCity" runat="server" AutoPostBack="true" AppendDataBoundItems="true"
                    OnSelectedIndexChanged="CityChanged">
                    <asp:ListItem Text="Select" Value="Select"></asp:ListItem>
                </asp:DropDownList>
            </HeaderTemplate>
            <ItemTemplate>
                <%# Eval("City") %>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <HeaderTemplate>
                <asp:DropDownList ID="ddlCountry" runat="server" AutoPostBack="true" AppendDataBoundItems="true"
                    OnSelectedIndexChanged="CountryChanged">
                    <asp:ListItem Text="Select" Value="Select"></asp:ListItem>
                </asp:DropDownList>
            </HeaderTemplate>
            <ItemTemplate>
                <%# Eval("Country") %>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Namespaces

C#

using System.Data;
using System.Data.SqlClient;
using System.Configuration;

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        ViewState["SelectedCountry"] = "Select";
        ViewState["SelectedCity"] = "Select";
        this.BindGrid();
    }
}

protected void CountryChanged(object sender, EventArgs e)
{
    DropDownList ddlCountry = (DropDownList)sender;
    ViewState["SelectedCountry"] = ddlCountry.SelectedValue;
    this.BindGrid();
}

protected void CityChanged(object sender, EventArgs e)
{
    DropDownList ddlCity = (DropDownList)sender;
    ViewState["SelectedCity"] = ddlCity.SelectedValue;
    this.BindGrid();
}

protected void RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.Header)
    {
        DropDownList ddlCity = (DropDownList)e.Row.FindControl("ddlCity");
        this.BindCities(ddlCity);
        DropDownList ddlCountry = (DropDownList)e.Row.FindControl("ddlCountry");
        this.BindCountries(ddlCountry);
    }
}

protected void OnPaging(object sender, GridViewPageEventArgs e)
{
    GridView1.PageIndex = e.NewPageIndex;
    this.BindGrid();
}

private DataTable GetDataTable(string query)
{
    string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(conString))
    {
        using (SqlCommand cmd = new SqlCommand(query))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
            {
                cmd.Connection = con;
                using (DataTable dt = new DataTable())
                {
                    sda.Fill(dt);

                    return dt;
                }
            }
        }
    }
}

private void BindGrid()
{
    string query = "SELECT ContactName, City, Country FROM Customers WHERE 1 = 1 ";
    if (ViewState["SelectedCountry"].ToString().ToUpper() != "SELECT")
    {
        query += " AND Country = '" + ViewState["SelectedCountry"].ToString() + "'";
    }
    if (ViewState["SelectedCity"].ToString().ToUpper() != "SELECT")
    {
        query += " AND City = '" + ViewState["SelectedCity"].ToString() + "'";
    }
    GridView1.DataSource = GetDataTable(query);
    GridView1.DataBind();
}

private void BindCountries(DropDownList ddlCountry)
{
    ddlCountry.DataSource = GetDataTable("SELECT DISTINCT Country FROM Customers WHERE Country <> 'NULL'");
    ddlCountry.DataTextField = "Country";
    ddlCountry.DataValueField = "Country";
    ddlCountry.DataBind();
    if (ViewState["SelectedCountry"] != null)
    {
        ddlCountry.Items.FindByText(ViewState["SelectedCountry"].ToString()).Selected = true;
    }
}

private void BindCities(DropDownList ddlCity)
{
    ddlCity.DataSource = GetDataTable("SELECT DISTINCT City FROM Customers WHERE City <> 'NULL'");
    ddlCity.DataTextField = "City";
    ddlCity.DataValueField = "City";
    ddlCity.DataBind();
    if (ViewState["SelectedCity"] != null)
    {
        ddlCity.Items.FindByText(ViewState["SelectedCity"].ToString()).Selected = true;
    }
}

Screenshot

Add the following condition to verify the item is present or not. If predeent then apply the selected property to TRUE.

if (ViewState["SelectedCity"] != null)
{
    if(myDDL.Items.FindByText(ViewState["SelectedCity"].ToString()) != null)
    {
            myDDL.Items.FindByText(ViewState["SelectedCity"].ToString()).Selected = true;
    }
}