// writing to access database
byte[] buff = null;
FileStream fs = new FileStream(fileName, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
long numBytes = fs.Length;
buff = br.ReadBytes((int)numBytes);
mycon.Open();
OleDbCommand cmd = new OleDbCommand("INSERT INTO song VALUES('1','" + buff + "')", mycon);
cmd.ExecuteNonQuery();
// reading from access database
OleDbCommand cmd = new OleDbCommand("select file from song", mycon);
System.Data.OleDb.OleDbDataReader dr;
dr = cmd.ExecuteReader();
dr.Read();
temp = (byte[])dr["file"];
int len = temp.Length;
although while writing the byte array is of size 970 kb while reading it from the access database and when i try to store it into byte array i get only 25 bytes , solution ?