Display content from Database (While loop) in C# / .NET

Question

I'm very new to .NET and unfortunately having to take over an ex-colleague's project.

Part of my code has a while loop to loop out query results...

        while (reader.Read())
        {
            pageTitle.Text = reader["title"].ToString();
        }

I am currently using this to retrieve the Page Title from a Table in my Database.

I want to display this in my <title></title> of the SiteMaster file, but unfortunately right now using this method:

<title><asp:Label ID="pageTitle" runat="server" /></title> is giving me a span tag inside the <title>. I want to remove the altogether and just have the Title value.

Can anyone explain the best way to do this?

Appreciate your help and patience with this.

Thank you

Wouldn't that loop overwrite the previous titles if you have a result set of more than one item? Is this the desired functionality? — IAmTimCorey
– IAmTimCorey, Commented May 17, 2011 at 15:24

dana · Accepted Answer · 2011-05-17 15:19:26Z

3

Make sure the <head> tag has the runat="server" attribute, for example:

<head runat="server">

Then set the title by using:

Page.Title = reader["title"].ToString();

answered May 17, 2011 at 15:19

dana

18.3k7 gold badges71 silver badges91 bronze badges

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

5 Comments

IAmTimCorey Over a year ago

Here is a link about how to do this: 4guysfromrolla.com/articles/051006-1.aspx

michaelmcgurk Over a year ago

Wow! Many Thanks, Dana!!! And if I were to do this for my meta keywords or meta description, would it be Page.Keywords =.... ?

codeandcloud Over a year ago

@user644978: Page.MetaKeywords use VS intellisense once in a while. won't hurt :)

dana Over a year ago

For .NET 4.0 you can use the Page.MetaKeywords. For previous versions you need to declare the tag <meta id="Keywords" name="Keywords" />, which will create an instance of System.Web.UI.HtmlControls.HtmlMeta that you can access from code.

michaelmcgurk Over a year ago

Wow! Tremendous help again, Dana. Page.MetaKeywords and Page.MetaDescription worked mucho coolness. Thanks to @naveen too and @BiggsTRC for the linkage. You guys rock.

Druid · Accepted Answer · 2011-05-17 15:19:35Z

3

Use the <asp:Literal> tag instead.

answered May 17, 2011 at 15:19

Druid

6,4634 gold badges44 silver badges57 bronze badges

6 Comments

Khepri Over a year ago

This would be my recommendation. asp:Label renders as span. Literal gives you what you need.

codeandcloud Over a year ago

hmmm... why shouldn't he use Page.Title

Druid Over a year ago

He could, as dana has suggested. This is an answer to getting rid of the span tag as asked.

michaelmcgurk Over a year ago

Thanks, Druid. I'll look into this tag just now and report back.

codeandcloud Over a year ago

@Khepri and @Druid: I totally disagree. framework should be your friend right? whats the point in putting a literal inside the title tag and then calling the literal when you could just use Page.Title

|

Collectives™ on Stack Overflow

Display content from Database (While loop) in C# / .NET

2 Answers 2

5 Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related