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 vote133 views1 answer
Select records that does not exist in another table in Entity Framework
C#
3 votes137 views2 answers
Get property value from object c#
C#
0 vote116 views2 answers
Übersetzer
C#
1 vote122 views1 answer
C# request run as administrator
C#
11 votes121 views2 answers
How to check if an integer is in array c#
C#
44 votes124 views6 answers
C# byte array to string
C#
1 vote122 views2 answers
2d look at unity
C#
1 vote139 views1 answer
C# serviceCollection AddLogging
C#
1 vote138 views1 answer
C# loop through array of objet
C#
0 vote122 views1 answer
Pyqt single instance
C#