Design

Step 1 : Add the Detailview from the toolbox :

Step 2 : click the New data source :

Step 3 : Select the Database :

Step 4 : Click the change button :

Step 5 : Select the Microsoft SQL Server :

Step 6 : Copy the server name :

Step 7 : Paste the server name and select the database and click OK button :

Step 8 : Click the Next button :

Step 9 : Click the Next button :

Step 10 : Select the table name :

Step 11 : Click the Advanced Button :

Step 12 : Select the Generate INSERT, UPDATE and DELETE statements :

Step 13 : Click the Test Query Button and click the Finish button :

Step 14 :Enable paging, Sorting, deleting, selection and RUN the code:

---

Output