AccessDataSource in VS

To Documents

Using an AccessDataSource Control in Visual Studio

Here are the steps for using an AccessDataSource control in Visual Studio
1. Open Visual Studio. Create an ASP.Net Web Application.
2. In the Solution Explorer, go to the Design Window of the Default.aspx file.
3. Drag an AccessDataSource from the Toolbox onto the form. Use the Properties Window to change its ID to ads.
4. Click on the ads control. Click on the right arrow and click on Configure DataSource.
5. In the Configure Data Source Dialog, enter the name of the Access database. Click Next.
6. Check the * textbox. The SQL statement should be Select * FROM [Persons]. Click Next.
7. Click Test Query. The entire Persons table should be displayed. Click Finish.
8. Drag a GridView control from the Toolbox onto the form. Use the Properties Window to change its ID to gvPersons.
9. Click on the gvPersons control. Click on the right arrow. Click on the Choose Data Source drop down list and select ads.
10. Run the application. The Persons table should be displayed.
11. Place TextBox, DropDownList, and Button controls on the form. Use the Properties Window to change their IDs to txtAge, ddlGender, and btnButton, respectively.
12. Use the Properties Window to add items to the Items property of ddlGender. Add two Items with Text=Female,Value=F; Text=Male, Value=M.
13. Double click on btnButton to produce the event handler btnButton_Click in the code-behind window. Add these lines of C# code to this event handler
```
ads.SelectCommand = SELECT * FROM Persons  +
    WHERE Age <  + txtAge.Text +  AND  +
     Gender = ' + ddlGender.SelectedValue + ';;
```
14. Run the application.
15. Move the btnSubmit_Click event handler to the .aspx file. change protected to public and place the event handler to within <script runat=server> </script> tags.
16. You can now change the name of the .aspx file from Default.aspx to example.aspx (or some other name) and upload it to ectweb2.