SharePoint Data Grid Web Part

Using SQL Table for DataGrid

Click “Modify Shared Web Part”.

Select SQL server as a data source.

Enter SQL server name, user name and password. Then click “Connect” to connect to SQL server.

Enter data base name on selected SQL server and choose and SQL table to display items in your DataGrid.

Now you need to define which columns will be displayed in your DataGrid. Use button s on the right to change the order of columns in DataGrid table.

Click “OK” to finish adjustment or click “Apply” to save the settings and continue.

As a result items from selected SQL table will be displayed in the DataGrid Web Part.