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 vote180 views1 answer
Enzymes chemical factory
C#
0 vote183 views1 answer
C# how to load type of class from string
C#
0 vote180 views1 answer
Hacking
C#
0 vote231 views1 answer
What is string args in c#
C#
3 votes180 views1 answer
Show private fields in inspecotr unity
C#
2 votes171 views1 answer
Untiy instanciate prefab
C#
0 vote181 views1 answer
C# pi
C#
1 vote198 views1 answer
Unity flexiable space
C#Unity
1 vote185 views1 answer
In what occasions do you use void update and fixedupdate C# unity
C#
0 vote199 views2 answers
C sharp type in word and calculate how much a letter is inside that word
C#