Display Data from Access with selected records

 

1. Open a new page and save it as driverreport.aspx.

2. Go to the toolbox, go to asp.net controls, click on the + next to the data folder, then drag the grid view to your page:  You will see:

Grid view

3. Click the down arrow in the choose data source box and select new data source you will see:

data source

 

4. Click on Access Database: you will see:

choose source for data

5. Ether type in the path which would be fpdb/driver.mdb or click browse and go to the database and select it.  Then click next and you will see:

database field selection

6. In this case we only have one table, but if you had other tables you would click on the drop down arrow and select them.


7. Click the * box to select all of the fields, click where next.  You will see:

Selecting records from data base

8.  In this case we will select records based on the lastname field = wylie
    a. In column, click the drop down arrow and select Lastname field
    b. In operator field, click the drop down arrow and select =
    c. In source, click the drop down arrow and select form
    d. In form field, type in Lastname
    e. Click Add.

 

Selecting records using where clause

9. You will see:

selecting records lastname=wylie

10. click Ok, You will see:

sql statement added to selecting

11. Click Next, You will see:

select fields

12. Click test query.  You will see:

select records were clause

13. Click ok, you will see:

query results for lastname = wylie

14. Click finish.  You will see:

grid view of data in driver.mdb

15. Click on auto format you will see:

auto format choices

16. Select a format and click Ok.  You will see:

formatted output

 

17. Save the file and press F12. to display the page.