byte[] data = {0x01, 0x02, 0x03, 0x04}; MySqlPacket packet = new MySqlPacket(data); int value = packet.ReadInt32(); //value will be equal to 16909060
MySqlConnection conn = new MySqlConnection("server=localhost;user=root;password=1234;database=test;"); MySqlCommand cmd = new MySqlCommand("SELECT * FROM users", conn); conn.Open(); MySqlDataReader reader = cmd.ExecuteReader(); while(reader.Read()) { int id = reader.GetInt32(0); string name = reader.GetString(1); int age = reader.GetInt32(2); Console.WriteLine("ID: " + id + ", Name: " + name + ", Age: " + age); } conn.Close();In this example, we create a MySqlConnection object passing the connection string as a parameter. We then create a MySqlCommand object passing a SQL query and the MySqlConnection object. We open the connection and execute the query using the ExecuteReader method. We then loop through the data returned by the query using the Read method of the MySqlDataReader object. For each row of data, we use the GetInt32 and GetString methods of the reader to retrieve the values of the columns. Finally, we close the connection.