protected void linkAuthor(object sender, EventArgs e)
{
LinkButton btn = (LinkButton)(sender);
string selectedAuthor = btn.CommandArgument;
string query = ("SELECT * FROM main WHERE author='" + selectedAuthor + "' ORDER BY ID ASC");
open_con(query); //method which connects to a database
query_info.Text = ("Displaying content by " + selectedAuthor + ".");
reset_parameters();
}
This works fine for the first time I click a category/author. But after the table has refreshed, and select another category or author then the table shows the wrong record.
How can I solve this?
You can view the page here: Try clicking at category 'Health' and then 'Puvent, Kevin'. The outcome is different to the one that was expected.
I think
The question will probably make more sense once you see the page
Member
1 Points
5 Posts
GridViewRow query linkbutton
Oct 20, 2012 08:44 AM|kevinp93|LINK
I am building a simple C# web app which will act like an online database for resources.
In my table, I have a category and author column.
When I click a category value in the table, the table will refresh showing only the categories that was selected.
To do this I used the following code (front-end):
And this is the code used in the back-end (c#) :
This works fine for the first time I click a category/author. But after the table has refreshed, and select another category or author then the table shows the wrong record.
How can I solve this?
You can view the page here: Try clicking at category
'Health'
and then'Puvent, Kevin'
. The outcome is different to the one that was expected. I thinkThe question will probably make more sense once you see the page
Thank you for your help
Contributor
2168 Points
905 Posts
Re: GridViewRow query linkbutton
Oct 20, 2012 08:49 AM|kaushikmaheta|LINK
try it write page load in which
if(!page.ispostback)
{
}
Remember to click Mark as Answer on the post that helps to others.
Member
1 Points
5 Posts
Re: GridViewRow query linkbutton
Oct 20, 2012 04:24 PM|kevinp93|LINK
Thank you soo much!
using (!IsPostBack) helped