ASP.net accessibility help

[Bakedgoods]

See post 4 for new problem!

My initial testing has gone well and thanks for everyone who has helped me

Just to make things 'nicer' though, i'm looking for some help.

I'm storing employee hours in a timesheet database, at the moment they will select a TimeCode to book hours too, to make this easier I would like to have them select the name of the TimeCode, but for the value to be stored as the CodeID.

I know if you add values manually to a DropDownList this is fairly easy, but the list will need to be populated by a Query.

I'm not sure of the easiest way to go about this, i'm i'll need to write some sort of query (or should I try do it in code?) that will fetch the ID based on the name, and then insert that instead?

My insert query at the moment is fairly typical...

INSERT INTO tblHours
                      (TimeCode, Date, Hours, Username, Comments, Approved)
VALUES     (@TimeCode,@Date,@Hours,@Username,@Comments,@Approved)

Thanks for any help guys

 

[Bakedgoods]

I completely forgot about that property, all I had to do was change the DataTextField to CodeName and got exactly what I want.

Thanks Haircut

Expect serious questions soon when I try to write reports using SQL reporting services based on data from two databases, i've never even seen the reporting services development tools :x

 

[Bakedgoods]

Ok another usability one here guys...

At the moment i'm displaying a lot of data using a field called Timecode, although users would eventually get to know off the top opf their heads what this Timecode actually means, it's a lot easier if they just see the name.

The problem is, the name is held in a different table..

Do I get the name in the original query that fetches the data, or do I just run another query after the data has been fetched which will then grab the Timecode Name and replace the 'Timecode 7' with the Name?

Thanks!