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 vote145 views1 answer
C# i++ meaning
C#
0 vote150 views1 answer
C# insert from with bind array
C#
0 vote193 views1 answer
Get datacontext of itemscontrol item c#
C#
3 votes191 views1 answer
Unity pause animator
C#Unity
0 vote252 views1 answer
How to detach the camera from the player after death unity
C#Unity
0 vote162 views1 answer
Lambda Expression to filter a list of list of items
C#
0 vote137 views1 answer
Mvc form name
C#
1 vote158 views1 answer
Hos to make slider in editor unity
C#
0 vote150 views1 answer
Process start web document
C#
0 vote193 views1 answer
Unity make a gambeobject array
C#Unity