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

0 vote236 views1 answer
C# using rename class
C#
6 votes218 views2 answers
Unity play sound effect
C#
-1 vote232 views1 answer
Wpf hexagon
C#
5 votes265 views1 answer
Unity create scriptableobject asset
C#Unity
1 vote226 views1 answer
Wpf restart application c#
C#
2 votes216 views1 answer
Change array size in unity
C#
3 votes219 views1 answer
Unity get project file directory
C#
0 vote216 views8 answers
Dinero en C#
C#
-1 vote206 views1 answer
Run as administrator vs 2019
C#
0 vote212 views1 answer
C# restclient timeout
C#