ADVERTISEMENT

ADVERTISEMENT

ADVERTISEMENT

C#.Net program to insert a record in the MySql database

Here, we are going to learn how to insert a record in the MySql database in C#?
Submitted by Nidhi, on February 10, 2021

In this program, here we will connect to the MySQL database and then insert a record into the "employee" table.

Program:

The source code to insert a record in the MySql database is given below. The given program is compiled and executed successfully.

//C#.NET program to insert a record in MySql database.

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;database=Sample_DB";
        MySqlConnection conn = new MySqlConnection(connString);

        conn.Open();

        MySqlCommand cmd = new MySqlCommand("INSERT INTO employee(eid,ename, salary) VALUES(@eid,@ename,@salary)", conn);

        cmd.Parameters.AddWithValue("@eid", 101);
        cmd.Parameters.AddWithValue("@ename", "Amit Kumar");
        cmd.Parameters.AddWithValue("@salary", 43200);
        cmd.Prepare();

        cmd.ExecuteNonQuery();
        Console.WriteLine("Record inserted successfully");
        conn.Close();
    }
}

Output:

Record inserted 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 database using MySqlConnection class and then insert a record into the "employee" table using ExecuteNonQuery() method of MySqlCommand class and then print the "Record inserted successfully" message on the console screen.

ADVERTISEMENT
ADVERTISEMENT




Comments and Discussions

ADVERTISEMENT

ADVERTISEMENT

ADVERTISEMENT

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.