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#
course content

Course Content

Introduction to .NET with C#

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?

bookTask - 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

copy

              
12345678910111213

            
using System;
using MySql.Data.MySqlClient;

class Program
{
    static void Main(string[] args)
    {
        // Write code below this line
        string connectionString = ___;
        ___ connection = new ___(connectionString);
        // Write code above this line
    }
}

Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 3. Chapter 5
some-alt