Q:

C#.Net program to create a database in MySql dynamically

belongs to collection: C# Database Connectivity Programs

mahmoud2506
Save to bookmark
|
2022-05-14
|
  216 
0

C#.Net program to create a database in MySql dynamically

c# programming, examples, c# programming examples,
login and add your own answer to this question

All Answers

mahmoud2506
2022-05-14
need an explanation for this answer? contact us directly to get an explanation for this answer

Program:

The source code to create a database in MySQL dynamically is given below. The given program is compiled and executed successfully.

//C#.Net program to create a database in 
//MySql dynamically.

using MySql.Data.MySqlClient;
using System;

class Program
{
    static void Main(string[] args)
    {
        //Connection String to connect with MySQL database.
        string connString = "server=localhost;userid=root;password=root";
        MySqlConnection conn = new MySqlConnection(connString);

        conn.Open();

        MySqlCommand cmd = new MySqlCommand("create database Sample_DB", conn);
        cmd.ExecuteNonQuery();

        Console.WriteLine("Database Sample_DB created successfully");
        conn.Close();
    }
}

Output:

Database Sample_DB created successfully
Press any key to continue . . .

Explanation:

In the above program, we imported a namespace MySql.Data.MySqlClient to establish the connection with the MySql database. Then we created a class Program that contains the Main() method.

The Main() method is the entry point for the program. In the Main() method, we created a connection string variable ConnString that contains the database connectivity credentials. After that we established the connection to the MySql using MySqlConnection class and then create the "Sample_DB" database using ExecuteNonQuery() method of MySqlCommand class and print the "Database Sample_DB created successfully" message on the console screen.

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

C# Database Connectivity Programs
This question belongs to these collections

Similar questions

need a help?

find thousands of online teachers now
C#.Net program to create a table in MySql database... >>
<< C#.Net program to get the MySQL version using the ...