Day-10

Today's Topic:

• Applications of OOPs concepts

• Recap of connecting to database and AddUser page functionality

• Interview skills

Task-10:

• Create an asp.net page which displays no.of active users

• Task Summary :

1. Create a new ASP.Net Web page with following controls:

a) Button : Text of the button should be "Fetch Active Users". The button should hold the functionality to fetch No.of Active Users.

b) Label1 : id = lbl_display. Text Should be No.of Active Users.

c) Label2 : id = lbl_usercount. Text should be assigned when users click "Fetch Active Users"

2. A Function "fetch_active_user_count" should be developed in Business Logic Class:

a) Formulate the query like we did for fetching user details.

b) Use getdataset() function to fetch results from DB and return the results (Dataset.tables[0].rows.count)