C# mysql query

MySqlConnection con = new MySqlConnection(connectionString);
con.Open();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM customers",con);
MySqlDataReader reader = cmd.ExecuteReader();
	while (reader.Read())
	{
    	//You can get values from column names
    	Console.WriteLine(reader["customerName"].ToString());
      	//Or return the value from the columnID, in this case, 0
    	Console.WriteLine(reader.GetInt32(0));
	}
con.Close();

Similar codes

1 vote122 views4 answers
Catch multiple exception c#
C#
0 vote114 views1 answer
Custom Encrypted String Type
C#
0 vote128 views1 answer
C# easy
C#
0 vote116 views1 answer
C# writeline list
C#
0 vote114 views1 answer
The type or namespace name 'Notifications' does not exist in the namespace 'Unity' (are you missing an assembly reference?)
C#
6 votes121 views1 answer
Unity rotate vector
C#
0 vote74 views1 answer
Content ReadAsStringAsync sync c#
C#
1 vote121 views1 answer
How to delete multiple file by datagridview in c#
C#
0 vote113 views2 answers
On scene loaded
C#
0 vote117 views3 answers
Query string not ending with with vowels
C#