Зміст курсу

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 UPDATE

Some new stock has arrived. The store owner tells you to set the quantity of all the products to 200, which was previously less than 100.

Your task is to update the quantity of all the products to 200, which is less than 100 in terms of quantity.

Link to the Task: GitHub

Use the UPDATE statement with the condition WHERE stock_quantity < 100.


using MySql.Data.MySqlClient;

public class CRUD_Task_4
{
    // Write the connection string here
    public static string connectionString = "server=___;port=___;user=___;password=___;database=___";

    static void Main(string[] args)
    {
        // Write code below this line
        using (MySqlConnection connection = new MySqlConnection(connectionString))
        {
            connection.Open();

            string cmdText = "UPDATE store SET stock_quantity = 200 WHERE stock_quantity < 100";
            MySqlCommand cmd = new MySqlCommand(cmdText, connection);
            cmd.ExecuteNonQuery();
        }
        // Write code above this line
    }
}

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

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

Зміст курсу

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 UPDATE

Some new stock has arrived. The store owner tells you to set the quantity of all the products to 200, which was previously less than 100.

Your task is to update the quantity of all the products to 200, which is less than 100 in terms of quantity.

Link to the Task: GitHub

Use the UPDATE statement with the condition WHERE stock_quantity < 100.


using MySql.Data.MySqlClient;

public class CRUD_Task_4
{
    // Write the connection string here
    public static string connectionString = "server=___;port=___;user=___;password=___;database=___";

    static void Main(string[] args)
    {
        // Write code below this line
        using (MySqlConnection connection = new MySqlConnection(connectionString))
        {
            connection.Open();

            string cmdText = "UPDATE store SET stock_quantity = 200 WHERE stock_quantity < 100";
            MySqlCommand cmd = new MySqlCommand(cmdText, connection);
            cmd.ExecuteNonQuery();
        }
        // Write code above this line
    }
}

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

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