Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Task - Writing Connection Strings | Introduction to Databases with .NET
Introduction to .NET with C#

Task - Writing Connection StringsTask - Writing Connection Strings

Your task is to write the connection string to connect to a MySql server. The server details are given below.

Note

The following details do not point to a real server, so it is not necessary to run the code. This task tests your ability to write a connection string. You can confirm your code's correctness by looking at the provided solution.

IP Address: 123.456.0.7
Port: 7779
User: root
Password: root123

Also, fill in the two blanks with the appropriate type/class name.

cs

index.cs

1. In the MySQL connection string we write the attribute-value pairs according to the attribute=value syntax. The pairs are separated by the semicolon (;) character.
2. We use the MySqlConnection class to create a connection object. 
using System;
using MySql.Data.MySqlClient;

class Program
{
    static void Main(string[] args)
    {
        // Write code below this line
        string connectionString = "server=123.456.0.7;port=7779;user=root;password=root123;";
        MySqlConnection connection = new MySqlConnection(connectionString);
        // Write code above this line
    }
}

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

Секція 3. Розділ 5
course content

Зміст курсу

Introduction to .NET with C#

1. Introduction

What is the .NET Platform exactly?Creating a Console ApplicationTaking input from the UserTask - Building a Simple CalculatorDealing with Exceptions caused by User InputTask - Improving the CalculatorReading FilesWriting FilesTask - File Based Calculator

2. Asynchronous Programming and Introduction to Web Services

What is Asynchronous Programming?Implementing an Asynchronous MethodTask - Asynchronously Reading FilesIntroduction to APIsMaking a GET RequestTask - Using an APIHandling Exceptions caused by HTTP RequestTask - Exception Handling for API Response

3. Introduction to Databases with .NET

What is a Database?Structure of a Relational DatabaseSetting Up A MySQL ServerConnecting to the MySQL ServerTask - Writing Connection StringsExecuting CommandsTask - Executing MySQL CommandsMySqlCommand MethodsTask - Connecting to a MySQL Database and Executing Commands

4. CRUD Operations with MySQL

Introduction to CRUD OperationsInstalling & Using MySQL WorkbenchCREATE - Part ITask - Using CREATECREATE - Part IITask - Using INSERTReadTask - Using SELECTUpdateTask - Using UPDATEDelete - Part IDelete - Part IITask - Using DELETE

5. Optimizing Database Operations

Stored ProceduresTask - Executing Stored ProceduresDataReader vs DataSetDataAdapter & DataSetTask - Reading Tables using MySqlDataAdapterWhat's Next?

Introduction to .NET with C#

Task - Writing Connection StringsTask - Writing Connection Strings

Your task is to write the connection string to connect to a MySql server. The server details are given below.

Note

The following details do not point to a real server, so it is not necessary to run the code. This task tests your ability to write a connection string. You can confirm your code's correctness by looking at the provided solution.

IP Address: 123.456.0.7
Port: 7779
User: root
Password: root123

Also, fill in the two blanks with the appropriate type/class name.

cs

index.cs

1. In the MySQL connection string we write the attribute-value pairs according to the attribute=value syntax. The pairs are separated by the semicolon (;) character.
2. We use the MySqlConnection class to create a connection object. 
using System;
using MySql.Data.MySqlClient;

class Program
{
    static void Main(string[] args)
    {
        // Write code below this line
        string connectionString = "server=123.456.0.7;port=7779;user=root;password=root123;";
        MySqlConnection connection = new MySqlConnection(connectionString);
        // Write code above this line
    }
}

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

Секція 3. Розділ 5
some-alt