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 vote329 views1 answer
Asp net identity extend relationship
C#
0 vote330 views1 answer
Remove loading bars devexpress on callback
C#
0 vote335 views1 answer
Unity set list of strings
C#
2 votes358 views1 answer
Unity public static variable
C#Unity
0 vote373 views1 answer
C# md5 hash bouncycastle encypt decrypt with key
C#
0 vote319 views1 answer
Cant find desktop and documents folder macOs
C#
1 vote328 views1 answer
Mvc 5 dropdownlist
C#
1 vote324 views1 answer
C# sql duplicate key exception
C#
3 votes313 views2 answers
C# bytes to image
C#
2 votes322 views1 answer
Unity public static variable
C#