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 vote298 views1 answer
C# join strings with comma
C#
0 vote310 views1 answer
Unity get default font
C#
1 vote329 views2 answers
Convert string to utf8 c#
C#
1 vote280 views1 answer
Unity spawn button
C#
0 vote263 views1 answer
How to check if control key is pressed c#
C#
2 votes284 views1 answer
How to pause physics in unity c#
C#
1 vote282 views1 answer
C# cast to type variable
C#
1 vote274 views1 answer
Get both item and index in c#
C#
2 votes284 views1 answer
How to reference scripts in other scenes unity
C#
0 vote288 views1 answer
Conncet oracle database in c# visual studio
C#