MATLAB: How to display an sql data Table in a uitable

displaysqluitable

Hallo every one

How to Upload/ Display a an SQL data Table in a uitable,

Thank you in advance.

Best Answer

From R2018a, we can display table array data in uitable.

The following is an example of reading data from PostgreSQL and show it in uitable.

%% Access to database
conn = database('db_name','usename', 'password', ...
    'Vendor','PostgreSQL', ...
    'Server','localhost','PortNumber',5432);
tableName = 'table_name';
% Read data from SQL
data = sqlread(conn, tableName);
%% plot in uitable
f = uifigure;
uit = uitable(f, 'Data', data);

Related Solutions

MATLAB: How to select from a table within a specific schema

This would depend on which command you are using to query the database:

If you are using 'sqlread', you can specify it as a argument:

tablename = 'productTable';
data = sqlread(conn,tablename,'Schema','dbo');

If you are using 'fetch' or 'select', then in your SQL statement, you specify the schema with the table name:

results = fetch(conn, 'SELECT * FROM schemaName.inventoryTable');

You can find more information regarding the SQL statement syntax in the documentation for your database. For SQL Server, we see this syntax explained here:

https://docs.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/transact-sql-syntax-conventions-transact-sql?view=sql-server-ver15

MATLAB: How to query a database to extract data from multiple tables

The key to retrieving information from a database is the query that is passed to the driver to retrieve that information. The code below shows an example of connecting to a database, and retrieving data from multiple tables based on some criteria.

query = 'SELECT ALL Table1.Name, Table1.Number FROM Table2, Table1 WHERE Table1.Number = Table2.Number AND Table1.Name = Table2.Name';
conn = database('Example','','');
cursor = exec(conn,query);
results = fetch(cursor);
results.data

Note that you will need to download the attached MDB-file and create a new data source in Access. To set up the data source, follow the steps below:

1) Download the attached MDB file and save it as Example.mdb

2) In your system's Control Panel, open up the Administrative Tools dialog

3) Select the Data Source (ODBC) tool

4) Add a new datasource, called Example, by selecting the Data Source to be the file downloaded in step 1

Best Answer

Related Solutions

MATLAB: How to select from a table within a specific schema

MATLAB: How to query a database to extract data from multiple tables

Related Question