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

2 votes111 views1 answer
Double
C#
8 votes129 views2 answers
How to sort a list of objects in place
C#
5 votes113 views1 answer
C# .net using url
C#
0 vote81 views1 answer
C# class reference
C#
2 votes144 views1 answer
Unity save list to json
C#Unity
0 vote131 views1 answer
How to set the forgound color of listitems in c#
C#
0 vote131 views1 answer
Increase value in dictionary against a key in c#
C#
0 vote124 views1 answer
C# lernen kostenlos
C#
3 votes153 views1 answer
Change sprite of a sprite unity
C#Unity
0 vote132 views1 answer
C# milisecond to h m s
C#