Retrieving and displaying dynamic content from SQL database into ASP.NET pages

Question

I am currently working on the development of news portal website in asp.net. I have created a table in sql server 2008 with parameters (NewsId, NewsTitle, NewsDetails, NewsCategory). I am now able to dynamically retrieve the NewsTitle from the database and displaying it in my aspx page. Now I want to pass the NewsId for that particular NewsTitle and then retrieve the NewsDetails in a separate aspx page. What is the best thing to do this in ASP.NET? I don't want to create new aspx pages every time a link to the NewsTitle is clicked, rather I am interested to use the same Details page and pass different ID parameters?

regards,

well then pass the parameter via session or query string ! ! — V4Vendetta
– V4Vendetta, Commented Apr 17, 2012 at 5:50
learn to use database classes defined in C# (if you use ASP.NET with C#) or VB.NET. Get a book and read it. There will provide many examples using databases. — Snake Eyes
– Snake Eyes, Commented Apr 17, 2012 at 5:51

IrishChieftain · Accepted Answer · 2012-04-17 05:51:51Z

2

I'd keep them both on the same page and employ a master-details pattern using something like panels to toggle the visibility:

http://leedumond.com/blog/master-detail-editing-inserting-deleting-with-a-listview-and-detailsview/

This will give you the basic idea; the sample linked to shows both, but as I said it is a simple matter to toggle them on and off on the click of a button.

answered Apr 17, 2012 at 5:51

IrishChieftain

15.2k8 gold badges55 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ashwini Verma · Accepted Answer · 2012-04-17 06:30:13Z

1

You can do the following approach:

Take HyperLink in a Gridview to show a NewsTitle:

<asp:GridView ID="GridView1" runat="server">
    <Columns>
        <asp:TemplateField>
            <ItemTemplate>
                 <asp:HyperLink runat="server" ID="hl" NavigateUrl='<%#"NewsDetails.aspx?Newsid="+ Eval("NewsId") %>' Text='<%# Eval("NewsTitle") %>'></asp:HyperLink>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Bind the GridView datasource in code behind:

protected void getNewsDetails()
{
    DataTable dtNewsDetails = new DataTable();
    //retrieve data from database into the DataTable
    GridView1.DataSource = dtNewsDetails;
    GridView1.DataBind();
}

Now as GridView HyperLink will navigate to the NewsDetails.aspx with a NewsId as querystring, show the details accordingly in a NewsDetails.aspx page:

protected void Page_Load(object sender, EventArgs e) { string Newsid = Request.QueryString["Newsid"].ToString(); //show the details from database using Newsid }

answered Apr 17, 2012 at 6:30

Ashwini Verma

7,5257 gold badges39 silver badges56 bronze badges

3 Comments

Semytech Over a year ago

Thank you Ashwin. This seems interesting and I will let you know once i tried it.

Semytech Over a year ago

It is working fine now. I followed your guidelines except that I used FormView instead of GridView to display the NewsTitle and NewsDetails. Thank you once again

Ashwini Verma Over a year ago

I just given an idea! please mark as an answer if it worked for you.

Zaheer Ahmed · Accepted Answer · 2012-04-17 05:53:33Z

0

You can add a textBox with visible attribute set as False and when you retrieve the NewsDetails set it to textBox and set it visibility to True;

<asp:TextBox ID="NewsDetails" runat="server" TextMode="MultiLine" 
                        Height="30px" Width="200px" Visible="False" />

and

void GetNewsDetails()
{
NewsDetails.Text=GetDetailsQuery;
NewsDetails.Visible=True;
}

answered Apr 17, 2012 at 5:53

Zaheer Ahmed

28.7k12 gold badges77 silver badges113 bronze badges

2 Comments

V4Vendetta Over a year ago

Why would you display news in a TextBox ?

Zaheer Ahmed Over a year ago

You can use any control like label that is just an example for displaying on the same page.

Collectives™ on Stack Overflow

Retrieving and displaying dynamic content from SQL database into ASP.NET pages

3 Answers 3

Comments

3 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related