Q:

C#.Net program to print the column name of a specified MySql database table

belongs to collection: C# Database Connectivity Programs

0

C#.Net program to print the column name of a specified MySql database table

All Answers

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

Program:

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

//C#.NET program to print the column names 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();

        Console.WriteLine("Employee table columns: ");
        Console.WriteLine("\t"+ reader.GetName(0));
        Console.WriteLine("\t" + reader.GetName(1));
        Console.WriteLine("\t" + reader.GetName(2));
        
        conn.Close();
    }
}

Output:

Employee table columns:
        eid
        ename
        salary
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 column names using ExecuteReader() and GetName() methods of MySqlDataReader class and then print them on the console screen.

 

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

total answers (1)

C#.Net program to get the records of a specified M... >>
<< C#.Net program to insert a record in the MySql dat...