ADVERTISEMENT
ADVERTISEMENT

C#.Net program to get the records of a specified MySql database table

Here, we are going to learn how to get the records of a specified MySql database table in C#?
Submitted by Nidhi, on February 10, 2021

In this program, here we will connect to the MySQL database and get employee records of the employee table then print them on the console screen.

Program:

The source code to print the column names of a specified MySql database table is given below. The given program is compiled and executed successfully.

//C#.NET program to print the column values of a 
//specified MySql database table.

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("SELECT * FROM employee", conn);

        MySqlDataReader reader;

        reader = cmd.ExecuteReader();

        while(reader.Read())
        {
            Console.WriteLine(reader.GetInt32(0) + " " + reader.GetString(1) + " " + reader.GetUInt32(2));
        }

        conn.Close();
    }
}

Output:

101 Sumit Kumar 63200
102 Vijay 25000
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 get the employee records using MySqlDataReader class. Here, we used Read() method to record one by one and we used GetInt32(), GetString() methods to read column values and print records 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.