Creating GridView & Performing operations:-

Create a New WebPage

1. Click on View menu
2. Click on  ServerExplorer  
3. Right Click on It
4. Select Data Connections
5. Click on Add Connection
6. Select  the Server Name(.)
7. Select use SQL Server Authentication
8. Type  UserName(sa)  , Password(Admin123),
9. Activate save my password option      
10. Select the DataBase (Employee)
11. Click on OK
12. A connection will be created in ServerExplorer
13. with ServerName.DataBaseName.
14. Click on (+) symbol of table
15. Select the table EmpDetails drag it and
16. leave on the Webpage
17. This will create GridView Control
18. Run the application and Check
19. To provide all other facilities to GridView select
20. the GridViewControl click on Smart Tag button(  ).
21. Activate the options like

• Enable Paging
• Enable Sorting
• Enable Deleting
• Enable Editing