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 vote254 views1 answer
Unity deactivate scripts in list
C#
0 vote250 views1 answer
How to specify order of test in c#
C#
0 vote282 views1 answer
How to convert int to char in c#
C#
0 vote218 views1 answer
Navmeshagent unity
C#
0 vote246 views1 answer
How to make a 3d object do something when clicked on
C#
0 vote282 views1 answer
C# write all bytes to a file
C#
5 votes296 views2 answers
How to check if key is held in unity
C#Unity
0 vote263 views1 answer
Generate a dropdown list from array data using razor .net mvc
C#
4 votes280 views1 answer
Unity move left and right
C#
6 votes247 views2 answers
Sum of two numbers in c#
C#