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 vote164 views1 answer
Vb.net read registry key as string
C#
2 votes162 views1 answer
C# separate string by comma
C#
1 vote162 views1 answer
C# data table primary key from 2 columns
C#
1 vote174 views1 answer
C# dynamic object get value
C#
0 vote173 views1 answer
C# find duplicate
C#
0 vote212 views3 answers
Get current location latitude and longitude in android
C#
0 vote174 views1 answer
Is and as in c#
C#
0 vote232 views1 answer
Save string unity
C#
10 votes177 views3 answers
Get percentage c#
C#
7 votes181 views2 answers
Unity how to create a prefab
C#Unity