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 vote192 views1 answer
Build a project from dotnet using cli
C#
0 vote214 views1 answer
Gravity script unity
C#Unity
0 vote152 views1 answer
How to read key from web config in JavaScript
C#
1 vote178 views1 answer
C# using file.io
C#
0 vote223 views1 answer
Enemy turret one direction ahooting script unity 2d
C#Unity
3 votes203 views1 answer
Create a directory if it doesnt exist c#
C#
1 vote189 views1 answer
Detecting a right click unity
C#
0 vote215 views1 answer
C# serialize to xml
C#
0 vote212 views1 answer
Create class for database connection in c#
C#
0 vote200 views1 answer
Filter collection viewbag
C#