Create the customer table in your own test database using below table script and insert some records initially to load gridview with data.
Once you execute the above table and insert scripts, you will get the below records in the table initially to load data into gridview control.
A powerful sequence of Mantra, Pranayama, Hand Mudras and Meditation. There can be several approaches taken for validating data. For our example we are going to use Customers table of Northwind database. Open its smart tag and choose "Configure Data Source" option to start Configure Data Source wizard.
On the first step of the wizard click on "New Connection" button to open a dialog as shown in Figure 1.
Execute the below SP_Customer stored procedure in sql server database which is used to handle insert, update, select and delete a record into customer table.