Gridview + Dropdownlist

[NerdTop72]

I am making a work order system for my computer work...

I have several tables

TBLJob
JobID (Autoincriment)
ComputerID (Relationship to TBLComputer.ComputerID)
UserID (Relationship to TblUser.UserID)
SoftwareID (Relationship to TBLSoftware.SoftwareID)
ErrorID (Relationship to TBLError.ErrorID)
WorkerID
WorkOrderNum
DateTime
Hardware
Software
JobDesc
Status

TblComputer
ComputerID (Autoincriment)
ComputerName
IP
Location
Make
Model
Serial
OS

TBLSoftware
SoftwareID (Autoincriment)
SoftwareTitle
SoftwareVer
Location
InstallationNotes
RemovalNotes

TBLError
ErrorID (Autoincriment)
SoftwareID
ErrorDesc
EventID
ErrorCode

I Have an ASP page that I enter in the Job information from a series of dropdownlists that are populated from each seperate table.
I want to make another page to edit this data. I have 1 sqldatasource set to TBLJob and I want to link
TBLJob.ComputerID to TBLComputer.ComputerID to list the ComputerNames in the dropdownlist in the gridview, instead of showing just the ID number... Currently it shows the ID number

How Would I Insert a Dropdownlist?

How would I fill the dropdownlist with the value that is in the rows?

How would I return the Value to edit the record for TBLJob so it returns its ID and not the Name?

I would like to do the same to these fields as well...
SoftwareID
ErrorID

I am a bit confused how i would do this?

Thanks
Jason

 

[ca8msm]

Have a look at the help files:

http://msdn2.microsoft.com/en-us/library/bb288032.aspx

-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]