Upload file into Database

I am using SQL server 2005, how to store and retrieve. Xls,. Doc,. PDF,. jpg ,.bmp file into database, can you give some me examples.

PersistenceManager PM = PersistenceManager.DefaultManager;

EntityList<ImageUpload> ListDatas = new EntityList<ImageUpload>();

private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e)

ListDatas.Add(ImageUpload.Create(PM));

private void Form1_Load(object sender, EventArgs e)

ListDatas.ReplaceRange(PM.GetEntities<ImageUpload>());

OpenFileDialog openFileDialog1 = new OpenFileDialog();

private void SelectFileultraButton_Click(object sender, EventArgs e)

openFileDialog1.Filter = "All Files (*.*)|*.*";

openFileDialog1.Title = "Select File";

if (DialogResult.Cancel == openFileDialog1.ShowDialog())

return;

string fileName = Path.GetFileName(fileNameUltraTextEditor.Text.ToString());

byte[] content = ReadFileToByteArray(fileName);

ImageUpload CurrentFile = bsFile.Current as ImageUpload;

protected static byte[] ReadFileToByteArray(string fileName)

FileStream fileStream = new FileStream(fileName, FileMode.OpenOrCreate, FileAccess.Read);

long len;

Byte[] fileAsByte = new Byte[len];

MemoryStream memoryStream = new MemoryStream(fileAsByte);

return memoryStream.ToArray();

private void saveToolStripButton_Click(object sender, EventArgs e)

if (PM.HasChanges())

try

MessageBox.Show("Sucessfully saved");

catch (Exception ex)

MessageBox.Show(ex.Message.ToString());

else

MessageBox.Show("Nothing to save");

private void RetriveultraButton_Click(object sender, EventArgs e)

string fileName = string.Empty;

byte[] content = null;

ImageUpload CurrentFile = bsFile.Current as ImageUpload;

DirectoryInfo di = new DirectoryInfo("C:\\Test");

if (di.Exists == false)

FileStream fs = new FileStream(di + "\\" + fileName, FileMode.Create);

fs.Write(content, 0, System.Convert.ToInt32(content.Length));

fs.Seek(0, SeekOrigin.Begin);