Converting issue Byte to Byte

Question

i never work with Bytes before i have a getting error here in may code please have a look

    SqlDataReader reader = cmd.ExecuteReader();
    reader.Read();
    SqlDataReader dr = ExecuteReader(Globals.con, CommandType.Text,
    "select FileName,MediaData,Extension from media where Id=" + ID);
    string FileName="";
    Byte[] MediaData= null;
    string Extension = "";
    while (dr.Read())
    {
        FileName = dr["FileName"].ToString();
        MediaData = Convert.ToByte(dr["MediaData"].ToString()); error is here
        Extension = dr["Extension"].ToString();              
    }
    dr.Close();
    string filename = (String)FileName;
    byte[] fileToDownload = (byte[])MediaData;
    String fileExtension = (String)Extension;

    in gridview i use this code below it working i need manual date
     not like code below
    string filename = (String)reader.GetValue(1);
    byte[] fileToDownload = (byte[])reader.GetValue(2);
    String fileExtension = (String)reader.GetValue(3);

please help me out in it

which error you are getting?

Parag Meshram
– Parag Meshram

2013-06-06 11:43:00 +00:00
Commented Jun 6, 2013 at 11:43 — Parag Meshram
– Parag Meshram, Commented Jun 6, 2013 at 11:43

Oded · Accepted Answer · 2013-06-06 11:02:54Z

1

Convert.ToByte returns a single byte, not an array.

You are also using ToString which can completely convert the binary data into a representation that you can't use:

MediaData = Convert.ToByte(dr["MediaData"].ToString())

Should be:

MediaData = (byte[])dr.Items["MediaData"];

answered Jun 6, 2013 at 11:02

Oded

501k102 gold badges900 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Bikram Over a year ago

im using this same please check the code one again MediaData = Convert.ToByte(dr["MediaData"].ToString()); error is here

Oded Over a year ago

@Vikas - Exactly. I have explained why that line is not working.

Collectives™ on Stack Overflow

Converting issue Byte to Byte

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related