#Front-End: Python, Back-End: Ms SQL In this project, I've designed a scheduling system with the help of Python and Ms SQL. With python, I've created a GUI from where user can enter data and the data will be stored in Ms SQL. Features include:
- Inserting data through python based GUI data-fields
- storing the data in Ms SQL database table
- modify or delete data from that table
- share the database table to the recipients if required via python email system.
To design the GUI window, we need certain libraries:
tkinter: to design the GUI windowpillow: to set background image for the GUI window
To connect Ms SQL, we need:
pyodbc: to establish connection with Ms SQL- provide the exact database name to create table under that specific database
import
pymysqlto establish connection with MySQL
- import the library
smtplib
Here I have imported email IDs from an excel file. For reading excel file, we have imported
pandaslibrary.
Results of some features are shown below:
- Inserting data

- Database output

- Shared the excel format of the MsSQL table via email

- Video output of some features of this project