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
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.
Using Share point designer 2007 for import/Export Share point site
Using Data View to Display data from multiple Share point List