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 vote293 views1 answer
Print text c# unity
C#
0 vote334 views1 answer
Unity dictionary check if key exists
C#
1 vote338 views1 answer
Https request c#
C#
2 votes321 views1 answer
Move to another scene unity
C#
9 votes298 views5 answers
Uuid laravel
C#
0 vote312 views1 answer
C# reflection create generic type
C#
0 vote345 views1 answer
Unity game object remove parent
C#Unity
3 votes333 views1 answer
Create a directory if it doesnt exist c#
C#
0 vote308 views1 answer
How many zeros in quinnonagintillion
C#
-1 vote302 views1 answer
What does -> in f#?
C#