Esempio n. 1
0
        private void GerarCards()
        {// SELECT a.foto,m.modelo FROM modelosSet m, aeronaveSet a WHERE a.idModelo = m.Id
            flowLayoutPanel1.Controls.Clear();
            SqlCommand    command = new SqlCommand("SELECT a.foto,m.modelo,a.som FROM Modelo m, Aeronave a WHERE a.id_modelo = m.id_modelo AND a.id_modelo = '" + id + "'", conexao.conectar());
            SqlDataReader reader  = command.ExecuteReader();

            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    byte[] picData = reader["foto"] as byte[] ?? null;
                    byte[] somData = reader["som"] as byte[] ?? null;


                    if (picData != null)
                    {
                        using (MemoryStream ms = new MemoryStream(picData))
                        {
                            System.Drawing.Bitmap bmp  = new System.Drawing.Bitmap(ms);
                            UCAviazinho           card = new UCAviazinho();
                            card.Construtor(reader.GetString(1), bmp, somData);
                            flowLayoutPanel1.Controls.Add(card);
                        }
                    }
                }
            }
        }
Esempio n. 2
0
        private void button1_Click(object sender, EventArgs e)
        {
            string busca = textBox1.Text;

            flowLayoutPanel2.Controls.Clear();
            SqlCommand    command = new SqlCommand("SELECT a.foto,m.modelo,a.som FROM Modelo m, Aeronave a WHERE a.id_modelo = m.id_modelo AND m.modelo = '" + busca + "'", conexao.conectar());
            SqlDataReader reader  = command.ExecuteReader();

            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    byte[] picData = reader["foto"] as byte[] ?? null;
                    byte[] somData = reader["som"] as byte[] ?? null;


                    if (picData != null)
                    {
                        using (MemoryStream ms = new MemoryStream(picData))
                        {
                            System.Drawing.Bitmap bmp  = new System.Drawing.Bitmap(ms);
                            UCAviazinho           card = new UCAviazinho();
                            card.Construtor(reader.GetString(1), bmp, somData);
                            flowLayoutPanel2.Controls.Add(card);
                        }
                    }
                }
            }
        }