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 vote126 views1 answer
How to sign in with your unity id in unity hub
C#Unity
5 votes117 views2 answers
Find value in object c#
C#
14 votes116 views3 answers
C# array to list
C#
0 vote107 views1 answer
Trhow exception if is null c#
C#
-1 vote108 views1 answer
How to create a random vector2 in unity
C#
46 votes102 views6 answers
Unity C# random number
C#
35 votes111 views4 answers
C# list length
C#
2 votes107 views1 answer
C# skip following code in loop
C#
2 votes112 views1 answer
Convert string int Linq
C#
0 vote138 views1 answer
Unity generate random offset position around a gameobject
C#Unity