How to connect to MySQL using C# and display a list of entries in the console?

Question

How would I select all the items from a table using C# Visual Studio?

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
namespace MySQLConnection
{ 
class Program
{
    static void Main(string[] args)
    {

            Console.WriteLine(args[0]);

    }
}
}

score 2 · Accepted Answer · answered Nov 06 '11 at 17:40

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;

namespace ConsoleApplication3
{
    class Program
    {
        public static string db = &quot;server=localhost;database=dsc;uid=root;password=&quot;;
        static void Main(string[] args)
        {
            try
            {
                MySqlConnection con = new MySqlConnection(db);
                con.Open(); // connection must be openned for command
                MySqlCommand cmd = new MySqlCommand(&quot;Select * FROM `tablename`&quot;, con);
                MySqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    Console.WriteLine(reader.GetString(&quot;id&quot;) + &quot;: &quot; + reader.GetString(&quot;name&quot;) + &quot; - &quot; + reader.GetString(&quot;hs&quot;));
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(&quot;Error: &quot;+ex);
            }
            finally
            {
                con.Close();
            }
        }
    }
}

Gives me an error of. The type of namespace name 'MySQLConnection' could not be found. — Aaron, Nov 06 '11 at 17:44
@Matthew Take a look at this link on how to add mysql reference http://stackoverflow.com/questions/1102281/how-do-i-add-a-reference-to-the-mysql-connector-for-net... — Glory Raj, Nov 06 '11 at 17:50

score 1 · Answer 2 · answered Nov 06 '11 at 17:37

SqlConnection conn = new SqlConnection([connectionstring]);
SqlCommand com1 =  new SqlCommand("Select * from [tablename]",conn);
conn.Open(); //Open the connection
SqlDataReader reader = com1.ExecuteReader();

while(Reader.Read()){ //read each row at a time

console.write(reader["columname"].toString]);
}

conn.Close(); //don't forget to close it after you're done

Does that help?

The connectionstring is a string which depends on the database location. The stuff in brackets in the sqlcommand is a 'select *' which will return all columns.

When you want to write the stuff out, you either give the column name or an integer. If you don't even know how many columns, you can put a loop which breaks when there's an exception thrown.

How to connect to MySQL using C# and display a list of entries in the console?

2 Answers2