Last post Oct 20, 2012 04:24 PM by kevinp93
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):
<asp:TemplateField HeaderText="Author" ItemStyle-Width="15%">
<asp:LinkButton ID="lbl_linkAuthor" Text='<%# Bind("author")%>' runat="server" OnClick="linkAuthor" CommandArgument='<%# Bind("author")%>' />
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 + ".");
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.
The question will probably make more sense once you see the page
Thank you for your help
Oct 20, 2012 08:49 AM|kaushikmaheta|LINK
try it write page load in which
Oct 20, 2012 04:24 PM|kevinp93|LINK
Thank you soo much!
using (!IsPostBack) helped