How to populate matlab GUI edit texts with values from MySQL database?

I have created a table with 10 columns in MySQL and manage to connect it with Matlab. What is the code to retrieve those data and display them in a matlab GUI edit texts boxes?

[BSantos]

Do you have Database Toolbox installed in your computer?

[hush puppy]

Yup, so what do I do next? Sorry, I'm new to MATLAB.

Answer 1

[Piyush Kumar]

Hi,

To retrieve data from the database, you can use the fetch function.

If you have created the edit text box using uicontrol, you can use the set function to display the value extracted from the database.

For example,

fig = figure('Position', [100, 100, 300, 200], 'Name', 'Simple GUI');
% Create an edit text box
editText = uicontrol('Style', 'edit', ...
                         'Position', [50, 100, 200, 40], ...
                         'String', 'Default value');
% db_value = fetch(conn, sqlquery) % Replace conn and sqlquery with the correct values
db_value = 'Hi, I am from db'
% Set the string value of the edit text box
set(editText, 'String', db_value);