How to Display data from External Databases in Share point

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.



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



4. You will get a screen like below.



5. From Choose Data Source Select New Data Source.



6. Give name for the data source.



7. From the next screen Click New connection.



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



 

9. Click ok and Press Next Button.



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



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



12. Click next and test your query.

13. Click Next and test the query we written.

 

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.