Using VS.net 2005 asp 2.0 VB. can't get Detials View to show anything

[DougP]

I added FormView to the top of the page and I can see the data just fine. Then I added details view below so I can see details. I am an Access programmer. I am converting an Access db to WEB and need to learn .ASP.net
Anyway there are two tables in the access db the “Timesheet” table is the top of the form and the “Timesheet details” is below , details is different table and they are linked by two fields Employee ID and Week Number.
In ASP.net the details never seems to show up at all.
I have hard coded values in the Access datasource and run the “Test query” in the Wizard and data shows up just fine, but when I view it on the WEB nothing shows.
Here is the Query in Access datasource

SELECT UniqueID, EmployeeID, WeekNumber, OT, TypeHours, PayDate, [Day], ProjectNumber, Expenses, Miles, Hours, Billable, ProjectDescription FROM [Timesheet Details] WHERE (EmployeeID = '104') AND (WeekNumber = 30)

What’s the trick to make this thing work or is this not supposed to work that way.
See attached screen capture of the access db. I want my ASP page to be the same as the Screen capture or as near as it can be. I would prefer to use the built controls in ASP rather that write it all out from scratch.

DougP
< I Built one

http://www.robots2000.com

 

[jbenson001]

What you want to do can be done, the problem is the datasource controls. They cause more problems than they do good. Once you try to do somehing more than just simple data display, they become useless. This is the part that you should be writing yourself. Get rid of any datasource controls and write the data access yourself. You can use thrid party DALs like Microsoft's data access application block.