I want to output a <h1> tag with a piece of data from a database table

Firstly my page does this:-
1: receives post from links.aspx, opens connection to a database then pulls data and populates a grid DONE that bit that was rather easy.

2: opens a connection (SqlDataSource2) and gets the following "select UID, LinkArea, FriendlyName from where @uid wtb_cat" Now what I want to be able to do is write a H1 tag from that, in the good olde days I'd have done something like <%=FriendlyName%> I've looked through a ton of books and can't find the code I am looking for, can anyone help?

--

404 real life user not found

__________________
--

404 real life user not found

...Are you trying to add the H1 tags in the datagrid or are you simply trying to write the data out to the browser surrounded by an H1 tag?



================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========

I am trying to get at the data and write it into a <h1> outside the datagrid

Data grids can be useful but in this case not really :S

--

404 real life user not found

What are you returning the data into? A dataset, datatable, datareader?

In all of the cases, getting to your data will be something similiar to

Response.Write("<h1>" + Convert.ToString(datatable.rows[0]["FriendlyName"]) + "</h1>");
Response.Write("<h1>" + Convert.ToString(datareader["FriendlyName"]) + "</h1>");
Response.Write("<h1>" + Convert.ToString(dataset.tables[0].rows[0]["FriendlyName"]) + "</h1>");



================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========

Alright, thanks for that, whilst looking at that code I assume, that in this instance we are using a datatable which is populated on page load.

So I've had a look through the books I already have and help files, and am still missing some of the point on the datatable bit, so i've just ordered the WroxBox (asp.net version) Thanks for your help anyway.

--

404 real life user not found