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 vote365 views1 answer
Monodevelop ubuntu 20.04
C#
1 vote343 views2 answers
C# get filename without extension
C#
6 votes332 views1 answer
Asp.net core entity framework database first
C#
10 votes330 views2 answers
C# string contains
C#
0 vote420 views1 answer
Unity android keycodes
C#Unity
0 vote382 views1 answer
Unity stop object from rotating
C#Unity
4 votes343 views1 answer
C# loop datatable rows
C#
3 votes325 views1 answer
Data type decimal tsql c#
C#
1 vote391 views1 answer
Ajax asp.net core
C#
21 votes368 views4 answers
C# convert int to string
C#