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.

C# Database Programs »


ADVERTISEMENT



ADVERTISEMENT



Comments and Discussions


ADVERTISEMENT

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.