how to get just a single value from an sql database and show it in a table.

I would like to get single values from a huge sql server and put it into a table. let's say 4 by 4. How do I do that?

I have a connection string with a select statement that will only return a value. But, I do not know how to put that value into a table.

Thank you.

Hi,

You want to display data from a SQL Server database on a page having a 4 x 4 Table right? Trying reading a bit about using GridView Control, or give me a bit more detail

|||

Dearmic_lch

If you only want to display value. I think gridview is the best solution. Can u give me more information about your table ?, which fields do you want to display?

|||

I understand about GridView and I think it's great. However, I am having problems showing an N * N gridview.

For example, I wanted to create Year vs Age Matrix, but, Gridview functionality is limited. Can I do that with gridview?

|||

Hi, mic_lch,

I'm not quite sure what kind of result you need to get. Could you give us an example of the output?

Thanks!