GUI for Database Connection

1 view (last 30 days)
Sagar Gupta
Sagar Gupta on 10 May 2021
Commented: Piyush Kumar on 22 Oct 2024
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.

Answers (1)

Piyush Kumar
Piyush Kumar on 22 Oct 2024
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 -
  1 Comment
Piyush Kumar
Piyush Kumar on 22 Oct 2024
I couldn't find any available templates for this task.

Sign in to comment.

Products


Release

R2021a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!