GUI for Database Connection

Hi,

Can someone point me to the direction of creating a GUI which can connect user to SQL Server and perform CRUD operations like show data edit add and delete. Which template in app designer might be helpful for creating such a GUI.

Answer 1

[Piyush Kumar]

Hi,

To create a GUI in MATLAB using App Designer to connect to an SQL Server and perform CRUD (Create, Read, Update, Delete) operations, you can follow these steps -

• After opening MATLAB APP Designer, choose Blank App template.
• Use Text Fields for user input(servername, username, password, etc), Buttons for action(e.g., Connect, Add, Edit, Delete), a Table to display data from the database, and Labels to guide users
• Go to the code view and define properties for the database connection.
• Write callback functions for the buttons to handle database operations - connecting to the database.
• Add functions to handle CRUD operations. For example, to read data from the database and display it in a table.

To learn more about creating GUI using App Designer, refer to these links -

• https://www.mathworks.com/help/matlab/creating_guis/create-a-simple-app-or-gui-using-app-designer.html
• https://www.mathworks.com/videos/gui-building-in-matlab-97169.html

[Piyush Kumar]

I couldn't find any available templates for this task.