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 vote343 views1 answer
When creating a new boolean column in an existing table how to set the default value as true in c# models code first
C#
0 vote307 views1 answer
Unity callback
C#Unity
1 vote319 views1 answer
If number negative c sharp
C#
3 votes311 views1 answer
Tinyint in c#
C#
4 votes367 views1 answer
Gameobject in unity c#
C#Unity
6 votes382 views1 answer
Unity access child
C#Unity
2 votes337 views1 answer
Unity gameobject.find not working
C#
22 votes317 views3 answers
Textmeshpro text
C#
10 votes384 views1 answer
Change height of rect transform unity
C#Unity
31 votes354 views3 answers
Get key unity
C#Unity