Web Part Configuration:

Title:
enter the optional web part title

Web Part:
AESQL

Configuration:
enter the below configuration options:

connection=enter the database connection string
pwd=enter the connection password
parameters=Northwind (alternatively 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)
formatting (column formatting, see "Column Formatting here)
totalcolumns=column1;column2;..(enable column totals)
grid=1 (enter the desired grid layout)
header=some text (enter the optional header text)
footer=some text (enter the optional footer text)
rows=0 (suppress the number of rows displayed at the bottom)
columnheaders=0 (suppress the column headers)
columnwidths=Lastname=200 (set speific column widths)
columnnames=Lastname= Last Name (define column aliases)
alternaterowcolor=pink (define the alternate row color)
print=1 (enable printing)
export=1 (enable CSV exporting)
options=enter additional options as needed