Зміст курсу

Introduction to .NET with C#

1. Introduction

What is the .NET Platform exactly?Creating a Console Application Taking input from the User Task - Building a Simple Calculator Dealing with Exceptions caused by User Input Task - Improving the Calculator Reading Files Writing Files Task - File Based Calculator

2. Asynchronous Programming and Introduction to Web Services

What is Asynchronous Programming?Implementing an Asynchronous Method Task - Asynchronously Reading Files Introduction to APIs Making a GET Request Task - Using an API Handling Exceptions caused by HTTP Request Task - Exception Handling for API Response

3. Introduction to Databases with .NET

What is a Database?Structure of a Relational Database Setting Up A MySQL Server Connecting to the MySQL Server Task - Writing Connection Strings Executing Commands Task - Executing MySQL Commands MySqlCommand Methods Task - Connecting to a MySQL Database and Executing Commands

4. CRUD Operations with MySQL

Introduction to CRUD Operations Installing & Using MySQL Workbench CREATE - Part I Task - Using CREATE CREATE - Part II Task - Using INSERT Read Task - Using SELECT Update Task - Using UPDATE Delete - Part I Delete - Part II Task - Using DELETE

5. Optimizing Database Operations

Stored Procedures Task - Executing Stored Procedures DataReader vs DataSet DataAdapter & DataSet Task - Reading Tables using MySqlDataAdapter What's Next?

Introduction to .NET with C#

Task - Using CREATE

A grocery store's business is expanding, and they need an efficient way to keep track of their products. They hire you to make an application for them, which is based on a MySQL database where they can store and monitor all the products that they have in stock.

Your task is to write the C# code for:

Connecting to your local MySQL database;
Creating a new table called products with the following columns:

id: A column of type integer;
name: A string value up to 100 characters;
category: A string representing the category of the product. Can be up to 100 characters;
price: A float value representing the price;
stock_quantity: An integer representing the quantity of the product available in stock.

You can either create and connect to a new database or use an existing one.

Link to the Task: GitHub

1. Use MySqlConnector to establish a connection to the local database.
2. You also need to close the connection using the Close() method or by utilizing the using statement.
3. Creating objects is a non-query operation. This command will be executed using the ExecuteNonQuery() method.


using System;
using MySql.Data.MySqlClient;

class Program
{
    static void Main(string[] args)
    {
        // Write code below this line
        string connectionString = "your connection string";

        using(MySqlConnection connection = new MySqlConnection(connectionString))
        {
            connection.Open();

            string cmdText = "CREATE TABLE products (id INT, name VARCHAR(100), category VARCHAR(100), price FLOAT, stock_quantity INT);";
            MySqlCommand cmd = new MySqlCommand(cmdText, connection);
            cmd.ExecuteNonQuery();
        }
        // Write code above this line
    }
}

Все було зрозуміло?

Секція 4. Розділ 4

Зміст курсу

Introduction to .NET with C#

1. Introduction

2. Asynchronous Programming and Introduction to Web Services

3. Introduction to Databases with .NET

4. CRUD Operations with MySQL

5. Optimizing Database Operations

Stored Procedures Task - Executing Stored Procedures DataReader vs DataSet DataAdapter & DataSet Task - Reading Tables using MySqlDataAdapter What's Next?

Introduction to .NET with C#

Task - Using CREATE

Your task is to write the C# code for:

Connecting to your local MySQL database;
Creating a new table called products with the following columns:

id: A column of type integer;
name: A string value up to 100 characters;
category: A string representing the category of the product. Can be up to 100 characters;
price: A float value representing the price;
stock_quantity: An integer representing the quantity of the product available in stock.

You can either create and connect to a new database or use an existing one.

Link to the Task: GitHub


using System;
using MySql.Data.MySqlClient;

class Program
{
    static void Main(string[] args)
    {
        // Write code below this line
        string connectionString = "your connection string";

        using(MySqlConnection connection = new MySqlConnection(connectionString))
        {
            connection.Open();

            string cmdText = "CREATE TABLE products (id INT, name VARCHAR(100), category VARCHAR(100), price FLOAT, stock_quantity INT);";
            MySqlCommand cmd = new MySqlCommand(cmdText, connection);
            cmd.ExecuteNonQuery();
        }
        // Write code above this line
    }
}

Все було зрозуміло?

Секція 4. Розділ 4