Course Content
Introduction to .NET with C#
Introduction to .NET with C#
Task - Connecting to a MySQL Database and Executing Commands
This task will recap most of the basic concepts of this chapter but the solution for it is very similar to what we had been practicing in the videos. Your task is to:
- Write the code for connecting to a server. You can connect to your local server if you have it hosted on your PC. If not, you can enter placeholder values in the connection string. The database name in the connection string should be
school
; - Make sure you are correctly closing the connection after use; Use either the
Close()
method or theusing
statement; - Enclose the relevant code into a try-catch block;
- Execute the command for creating a new table called
teachers
, which will have four columns, namelyid
,name
,age
, andexperience
. Use the following command:CREATE TABLE teachers (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30), age INT, experience FLOAT)
; - Execute the following three commands, which will insert 3 rows into the database:
- Finally, read and display the data of the 3 rows. The column
name
is of typeString
,age
is of typeInt32
, andexperience
is of typeFloat
.
Thanks for your feedback!