ASP & SQL tables

[Jamie Sutherland]

Hi,
I have a table in SQL Server which contains three fields
ID, Name, Colour.

on my aspx page I need to show theses results but as buttons and the
backcolour to match what is in the table.

ie record 1 could be:
ID: 1
Name: John
Colour: Purple

so my output to either a button or should then have a purple background
whith the text as john and when clicked opens a new page ie page2.aspx?ID=1
I can successfully get the records from the DB using the SQLDatarReader

any help please

thanks
Jamie

[DotNetJerome]

Hi,

You can create the button cotrols dynamically...and yoiu can add them into
container control.

You can add your events code also with attributes to the button control.

Cheers,

Jerome. M

"Jamie Sutherland" wrote:

Hi,
I have a table in SQL Server which contains three fields
ID, Name, Colour.

on my aspx page I need to show theses results but as buttons and the
backcolour to match what is in the table.

ie record 1 could be:
ID: 1
Name: John
Colour: Purple

so my output to either a button or should then have a purple background
whith the text as john and when clicked opens a new page ie page2.aspx?ID=1
I can successfully get the records from the DB using the SQLDatarReader

any help please

thanks
Jamie