How to populate gridview based on client click on navigation bar

Question

4.00/5 (1 vote)

See more:

In my project i have a navigation bar which shows the different types of recipes e.g: Healthy Recipes, Desserts, etc...

In the same page i have a gridview which is binded by database (RecipeTable) to show the list of recipes available.

My problem is how should i bind gridview with the navigation bar selection.

e.g: when a user clicks on Healthy Recipe the gridview should show the recipes saved under healthy recipes type.

i have search a lot but could not find anything related to this.

Please help me.

Posted 27-Mar-14 21:43pm

Garishma

Add a Solution

Comments

Mahesh_Bhosale 28-Mar-14 4:37am

you need to get id of recipes from navigation bar. and then pull data form database upon id.

Garishma 28-Mar-14 4:41am

Could you please explain in detail.. m a newbie. just a small example. please

3 solutions

Solution 3

It depends what sort of navigation bar do you use.
If your navigational control is html then add runat="server" attribute to its tag and on code behind you add something like this:

C#

protected void Page_Load(object sender, EventArgs e)
{
     if (!this.IsPostBack)
     {
         this.yourNavigationControl.ServerClick += (s, evt) =>
         {
          //Bind data to your grid according to navigation element you have clicked
         };
    }
}

If your navigation control is WebForms control, then it is even simpler.
Most controls (if not all) used for navigation have some sort of click event - use that!

C#

protected void NavigationButton_Click(object sender, EventArgs e)
{
     //Bind data to your grid according to navigation element you have clicked
}

protected void MenuItemClick(object sender, MenuEventArgs e)
{
     //Bind data to your grid according to navigation element you have clicked
}

Posted 27-Mar-14 23:11pm

Oshtri Deka

Updated 27-Mar-14 23:12pm

v2

Comments

Garishma 28-Mar-14 5:24am

Following is the code used. please help me.

for navigation:
<asp:Menu ID="Menu1" runat="server" OnMenuItemClick="Menu_Click">
<items>
<asp:MenuItem Text="Healthy Recipes">
<asp:MenuItem Text="Desserts">

for binding data:
con.Open();
SqlCommand cmd = new SqlCommand("Select * from RecipeTable where ___________", con);
cmd.ExecuteNonQuery();

SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);

gridRecipe.DataSource = ds;
gridRecipe.DataBind();
con.Close();

Oshtri Deka 28-Mar-14 6:12am

C'mon, try harder!
This isn't quantum physics.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

nandakishoreroyal · Accepted Answer · 2014-03-27T22:51:00

onclick event for navigation bar, and in onclick event you sort the data table based on your id of the clicked navigartion bar and bind the grid..

example : I have datatable in session,

I clicked on "Link1"

then in onclick event

if(id="Link1")
{
datatable.sort("your condition")
gridview.datasource=datatable;
gridview.bind();
}
else if(id="Link2")
{

C#

datatable.sort("your condition")
gridview.datasource=datatable;
gridview.bind();

}

Garishma · Accepted Answer · 2014-03-29T08:28:00

The solution is:

My Menu Item Code is:

C#

<asp:Menu ID="Menu1" runat="server" OnMenuItemClick="Menu_Click">
<Items>
    <asp:MenuItem Text="Heathy" Value="0" Selected="true"></asp:MenuItem>
    <asp:MenuItem Text="Kids" Value="1"></asp:MenuItem>
</Items>
</asp:Menu>

MenuItem_Click code is:

C#

string MenuBind = Menu1.SelectedItem.Text;
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["aaaaaaaaaaaa"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("Select * from [tablename] WHERE column_name=@type", con);
        cmd.Parameters.Add(new SqlParameter("@type", MenuBind));
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);

        gridRecipe.DataSource = ds;
        gridRecipe.DataBind();
        con.Close();

Thanks a lot for your attention.. Appreciated!!!!

How to populate gridview based on client click on navigation bar

3 solutions

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0