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

18 votes107 views6 answers
Laravel route redirect
C#
0 vote96 views1 answer
How many zeros in quinnonagintillion
C#
1 vote108 views1 answer
Get all sundays between two dates c#
C#
1 vote104 views1 answer
Unity set material
C#
2 votes109 views1 answer
Unity 2d how to set an object or the mouse position
C#
0 vote105 views1 answer
Last N lines from file
C#
0 vote93 views1 answer
How to run code without a gameobject unity
C#
55 votes145 views6 answers
C# print
C#
481 votes242 views10 answers
December global holidays
C#
0 vote100 views1 answer
DefaultContractResolver .net exclude null values JsonSerializerSettings ContractResolver DefaultContractResolver
C#