This way:
HTML:
Place you GridView below Menu control.
<asp:Menu ID="Menu1" runat="server" OnMenuItemClick="Menu_Click">
<Items>
<asp:MenuItem Text="Healthy Recipes" Value="0"></asp:MenuItem>
<asp:MenuItem Text="Desserts" Value="1"></asp:MenuItem>
</Items>
</asp:Menu>
C#:
protected void Menu_Click(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SELECT* from RecipeTable WHERE RecipeType = @RecipeType ", conn))
{
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
//If you want to search with Text
//cmd.Parameters.AddWithValue("@RecipeType", this.Menu1.SelectedItem.Text);
//If you want to search with value
cmd.Parameters.AddWithValue("@RecipeType", this.Menu1.SelectedItem.Value);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
}
}
Namespace:
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
Thank You.