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

1 vote103 views1 answer
Removing illlegal char from filename
C#
0 vote113 views1 answer
C# decimal with two places store as string with two places
C#
0 vote124 views1 answer
Create material unity script
C#
0 vote117 views1 answer
PrincipalContext c# example
C#
0 vote130 views1 answer
C# substring find word
C#
1 vote166 views1 answer
Unity how to get the side ways velocity of a object
C#Unity
0 vote114 views1 answer
C# datetime serialization issues
C#
0 vote113 views1 answer
C# expression func automatically select return type
C#
0 vote70 views1 answer
Convert linq query to json format
C#
1 vote114 views1 answer
C# sort array
C#