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 vote183 views1 answer
C# extension
C#
1 vote161 views2 answers
Get processor id c# web application
C#
0 vote161 views1 answer
Rotate along normal unity
C#
1 vote226 views1 answer
Xamarin.Forms - How to navigate to a tabbed page child page
C#
1 vote164 views1 answer
Toggle unity c#
C#
0 vote165 views1 answer
C# make two checkbox uncheckable both
C#
0 vote164 views1 answer
C# object to dictionary
C#
7 votes219 views3 answers
How to change scenes on collision unity
C#Unity
0 vote222 views1 answer
How to get point of collision in unity
C#Unity
0 vote169 views1 answer
Unity shooting script 2d
C#