<< SharePoint 2019 'Modern' Web PartsTable of contents 
SQL Query Viewer Web Part

The SQL Query Viewer Web Part allows to query external SQL Server databases and displays the result as a pageable list without having to resort to Sharepoint Designer.
The Enterprise version adds OLE-DB and ODBC data source support (MS Access, Excel, CSV, Oracle etc.), allows to create Web Part connections (row filters etc.), sort columns and define search filters.
Sharepoint 2019 Modern SQL Query Viewer Web Part

Web Part Configuration:

enter the optional web part title

Web Part:

enter the below configuration options:

parameters=Northwind (enter the name of your connection parameter file)
query=SELECT.. (enter your SQL SELECT query)
pagesize=7 (enter the desired page size)
filter=LastName (enter the desired optional search filters)
grid=1 (enter the desired grid layout)
header=some text (enter the optional header text)
footer=some text (enter the optional footer text)

Web Part Configuration

Please enter a comment below if you want to give feedback or have suggestions for improvements:

User Comments Post a Comment