basic datalist

[Matt Mercer]

Hi,

I want to use a datalist to display the contents of a database. I want
to show the database field name and the content of the field for every
record returned by the select statement. For example, I have a data
base the holds descriptions of people. I ask for everyone with brown
hair (let's say only two people do). My database fields are: Name,
hair color, eye color. I want to see:

Name:
Jane Doe

Hair Color:
Brown

Eye Color:
Blue

Name:
Jenny Blah

Hair Color:
Brown

Eye Color:
Green

I see how to manually set this up, but isn't there a way to
programatically have the datalist spit out field names and values
returned by the SELECT statement. Code for this should be small. Thank
you.

[Cowboy (Gregory A. Beamer) - MVP]

A repeater is a better option than a data list for this type of entry, unless
you want to create multiple lists (one for each person). Data lists are best
for one entry (column) over and over again.

With a repeater, you will simply write the resulting HTML tags you want to
be your output. Create a single person table, chop off <table> and put in
header, </table> goes in footer and the rest goes in the repeater item. You
then write your data binding tags and bind it to some data in the code behind.

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** ************
Think Outside the Box!
*************** ************

"Matt Mercer" wrote:

Hi,

I want to use a datalist to display the contents of a database. I want
to show the database field name and the content of the field for every
record returned by the select statement. For example, I have a data
base the holds descriptions of people. I ask for everyone with brown
hair (let's say only two people do). My database fields are: Name,
hair color, eye color. I want to see:

Name:
Jane Doe

Hair Color:
Brown

Eye Color:
Blue

Name:
Jenny Blah

Hair Color:
Brown

Eye Color:
Green

I see how to manually set this up, but isn't there a way to
programatically have the datalist spit out field names and values
returned by the SELECT statement. Code for this should be small. Thank
you.