User-1257946675 posted
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):
<asp:TemplateField HeaderText="Author" ItemStyle-Width="15%">
<ItemTemplate>
<asp:LinkButton ID="lbl_linkAuthor" Text='<%# Bind("author")%>' runat="server" OnClick="linkAuthor" CommandArgument='<%# Bind("author")%>' />
</ItemTemplate>
</asp:TemplateField>
And this is the code used in the back-end (c#)
:
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 
Thank you for your help 