Use the data view of Sharepoint to display data in an existing database [reprinted]

See this articleArticleThat's good. Let's turn it over for backup.

 In many cases, you may need to display some data in other databases on the SharePoint site. In this case, you need to use the data view function of Microsoft Office Sharepoint designer 2007.

First, use the Microsoft Office Sharepoint designer 2007 software to open the site (subject: the form-certified site currently does not support Microsoft Office Sharepoint designer 2007 connection modification ), therefore, I can only connect to the site through Windows authentication. At the same time, I want to display the existing registered user information in the form Authentication database on the homepage.

1. Open the page where you want to insert data and insert a row into the table.

 

2. Insert a data view into the new table.

3. Click Connect to database in data source database-database connection ....., Click "Configure database connection .... ";

4. Enter some information to connect to the database server. The prompt is: if the database and SharePoint are on the same server, you can enter "." In the server name "."

5. The system will have a security prompt, which will occur when you do not configure SSO login.

6. At this time, the system starts to connect to the SQL server.

7. After the connection is successful, select the corresponding data table. In this example, select aspnet_users in the aspnetdb table and click Finish.

8. You can filter and sort databases on this page. It seems that the function is quite powerful!

9. Click "show data"

10. Select the fields you want to display

11. Click "multi-project view"

12. OK!

Let's hand over the rest to the artist!

Later, I sorted the displayed data in descending order by lastactivitvdate and modified the table border. The final result is as follows:

 

[Original address]