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
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