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

16 votes217 views1 answer
For loop on enum c#
C#
0 vote259 views1 answer
Yanderedev
C#
0 vote252 views1 answer
Dotnet.com
C#
0 vote254 views1 answer
How to pick a random item in c#
C#
0 vote282 views1 answer
How to have referecne to script in unity
C#
0 vote268 views1 answer
Can't add an editor script
C#
0 vote306 views1 answer
Unity move in x seconds to pos
C#Unity
0 vote263 views2 answers
Transform.lookat 2d
C#
0 vote393 views1 answer
How to make text show a variable in unity
C#Unity
0 vote207 views1 answer
How to make a capsule walk in unity
C#