I have a simple table News. Columns: NewsId, NewsTitle, NewsDate. i am selecting Top 5 news and binding the same to GridView which has hyperlink
When the hyperlink is clicked it will redirect to NewsDetail.aspx with the NewsId in querystring
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns = "false">
<Columns>
<asp:HyperLinkField HeaderText = "Headlines" DataTextField = "NewsTitle" DataNavigateUrlFields = "NewsId" DataNavigateUrlFormatString = "~/NewsDetail.aspx?Id={0}" />
</Columns>
</asp:GridView>
protected void Page_Load(object sender, EventArgs e)
{
string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
string query = "SELECT Top 5 NewsId, NewsTitle FROM News order by NewsDate desc";
SqlCommand cmd = new SqlCommand(query);
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataSet ds = new DataSet())
{
sda.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
}
}