How to display an sql data Table in a uitable
5 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Oussama Louati
el 21 de Nov. de 2018
Comentada: Kojiro Saito
el 30 de Nov. de 2018
Hallo every one
How to Upload/ Display a an SQL data Table in a uitable,
Thank you in advance.
0 comentarios
Respuesta aceptada
Kojiro Saito
el 27 de Nov. de 2018
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);
4 comentarios
Kojiro Saito
el 30 de Nov. de 2018
uitable has a property CellSelectionCallback, and by using this, selected lines can be caught up.
Here is an example of do something from selected lines (app.data and app.selected are properties added in AppDesigner)
app.UITable.CellSelectionCallback = {@selectedChange, app};
function selectedChange(src, eve, app)
% Get selected lines
app.selected = eve.Indices(:, 1);
% Extract only selected lines from original data
selectedData = app.data(app.selected, :);
% Do something on selected lines
% for example,
% m = mean(selectedData);
end
Más respuestas (1)
Ver también
Categorías
Más información sobre Develop Apps Using App Designer en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!