How to make that page shows different content with links

I want to know how to make that one page inherits contents from database on linkbutton click. If I have a lot of linkbuttons, and all of them have functions to read different data from database, like i have articles, and i want to load content of article with linkbuttons. one link button reads one content. I hope you understand me.

Hi,
As my understanding you want to read different article on click on different button. In that case create one aspx page and read article information from database for a given article id.
From the link button you need to navigate or open same page with different ArticleId

from your page

runat="server" />

in ArticleDetails page read the query string value

public partial class ArticleDetails : System.Web.UI.Page

{

private string _articleId;

protected void Page_Load(object sender, EventArgs e)

{

_articleId = Request.QueryString["ArticleId"];

LoadData();

}

private void LoadData()

{

string constring = @"Data Source=SQLEXPRESS;Initial Catalog=MyDb;Persist Security Info=True;User ID=MyUser;Password=MyPassword";

DataTable dt = new DataTable();

using (SqlConnection con = new SqlConnection(constring))

{

using (SqlCommand cmd = new SqlCommand("select *from ArticleInfo where ArticleId=@ArticleId", con))

{

con.Open();

cmd.Parameters.AddWithValue("@ArticleId", _articleId);

SqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())

{

LblArticleTitle.Text = reader["ArticleTitle"].ToString();

LblArticleDesc.Text = reader["ArticleDesc"].ToString();

}

reader.Close();

con.Close();

}

Regards,
Iftikar

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Accepted answer
Hi,
As my understanding you want to read different article on click on different button. In that case create one aspx page and read article information from database for a given article id.
From the link button you need to navigate or open same page with different ArticleId

from your page

runat="server" />

runat="server" />

runat="server" />

runat="server" />

in ArticleDetails page read the query string value

public partial class ArticleDetails : System.Web.UI.Page
{
private string _articleId;

protected void Page_Load(object sender, EventArgs e)
{
_articleId = Request.QueryString["ArticleId"];
LoadData();
}

private void LoadData()
{
string constring = @"Data Source=SQLEXPRESS;Initial Catalog=MyDb;Persist Security Info=True;User ID=MyUser;Password=MyPassword";
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(constring))
{
using (SqlCommand cmd = new SqlCommand("select *from ArticleInfo where ArticleId=@ArticleId", con))
{
con.Open();
cmd.Parameters.AddWithValue("@ArticleId", _articleId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
LblArticleTitle.Text = reader["ArticleTitle"].ToString();
LblArticleDesc.Text = reader["ArticleDesc"].ToString();
}
reader.Close();
con.Close();
}
}
}
}

Regards,
Iftikar
Nermin Huskic13y ago
Thank you very much on such a good explanation.