How to Display data from External Databases in Share point


HTML clipboard

Easy way to Display data from External Databases in Share point without using Business Data Catalog.

Here I am showing you how to display a data from external database in Share point using SharePoint designer

1. As usual you have to open the site in share point designer and open the page where you want to display the data. Please make sure you have checked out the files first.

2. Click Insert ASP.NET Controls and select More ASP.Net Controls.

image1.gif

3. As shown below select Grid view form Data Group and Drag that to your share point page.

image2.gif

4. You will get a screen like below.

image3.gif

5. From Choose Data Source Select New Data Source.

image4.gif

6. Give name for the data source.

image5.gif

7. From the next screen Click New connection.

image6.gif

8.
From the popup please give the DB details as shown below and click on Test Connection.

image7.gif

  image8.gif

9. Click ok and Press Next Button.

image9.gif

10. You have to save the connection string as shown below.

image10.gif

11. Click Next. You will get a screen like below .Select the field you want to display.

image11.gif

12.
Click next and test your query.

13. Click Next and test the query we written.

  image12.gif

14.
Click On Finish.

15. Save and Check in your file.

16. Open your page in Browser you can see the Grid view with Data.

image13.gif