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

3 votes181 views1 answer
C# post get request
C#
1 vote246 views1 answer
Unity detect if version is a build or in editor
C#Unity
1 vote181 views1 answer
Dapper delete where in list
C#
0 vote175 views1 answer
[Package Manager Window] Error while fetching labels: User is not logged in or user status invalid. UnityEngine.GUIUtility:ProcessEvent (int,intptr,bool&)
C#
3 votes180 views1 answer
Linq include
C#
1 vote266 views3 answers
Unity follow object
C#Unity
0 vote184 views1 answer
Freeze time unity 2d script
C#
32 votes189 views4 answers
Raycasthit unity
C#
0 vote207 views1 answer
How to get integer value from textbox in c#
C#
0 vote185 views1 answer
Unity create cube in script
C#