To return multiple rows with sql Server byte array

Question

I need to perform a query, in a table, where the data is of the type varbinary(max), then created the method below:

public List<byte[]> preenche_fotos(string nCrm)
    {
        consql.bd_string();
        SqlConnection sqlconn = new SqlConnection(consql.sqlconn);

        List<byte[]> list_foto = new List<byte[]>();

        try
        {
            consql._sql = @"SELECT bfoto
                            FROM crm_fotos
                            WHERE ncrm = @nCrm";

            SqlCommand cmd = new SqlCommand(consql._sql, sqlconn);

            cmd.Parameters.Add("@nCrm", SqlDbType.VarChar).Value = nCrm;

            sqlconn.Open();

            SqlDataReader leitor = cmd.ExecuteReader();

            while (leitor.Read())
            {
                list_foto.Add(???????);
            }
        }
        catch (Exception error)
        {
            MessageBox.Show("Error" + error);
        }
        finally
        {
            sqlconn.Close();
        }

        return list_foto;
    } 
}

So with the method Read of DataReader, I’ll read the query line by line, but how do I add the value to the list_foto?

Answer 1

To pass the values would be a cast to the array de bytes (byte[]) as follows:

while (leitor.Read())
{
    list_foto.Add((byte[])leitor['bfoto']);
}

where leitor['bfoto'] bfoto is the name of the table field.

_References:

• Reading Binary from table column into byte[] array
• How to Store and Read Byte Array in SQL Server Database using C# . Net
• Read and Write BLOB Data to SQL Server database using C# and VB.Net