Click here to Skip to main content
11,431,829 members (58,851 online)
Click here to Skip to main content

Tagged as

Upload and Download Files From DataGridView Cells

, 25 May 2011 CPOL
Rate this:
Please Sign up or sign in to vote.
This post helps to upload any file into a datagridview cell and also download it from the datagridview cell.
Image.jpg

Introduction

This post helps to upload any file into a datagridview cell and also download it from the datagridview cell. In the attached project file, I have declared a model variable Dictionary<int, byte[]> _myAttachments which stores the attachments as Byte array, and key stores the rowIndex.

Dictionary<int, byte[]> _myAttachments = new Dictionary<int, byte[]>();

Select the attachment cell and click on the ‘Upload File’ button. It will pop up a FileDialog for the user to select the required file which is to be uploaded.

The following routine uploads the user selected file and shows the file name in the provided dataGridViewCell.

/// <summary>
/// Upload Attachment at the provided DataGridViewCell
/// </summary>
/// <param name="dgvCell"></param>
private void UploadAttachment(DataGridViewCell dgvCell)
{
    using (OpenFileDialog fileDialog = new OpenFileDialog())
    {
        //Set File dialog properties
        fileDialog.CheckFileExists = true;
        fileDialog.CheckPathExists = true;
        fileDialog.Filter = "All Files|*.*";
        fileDialog.Title = "Select a file";
        fileDialog.Multiselect = false;

        if (fileDialog.ShowDialog() == DialogResult.OK)
        {
            FileInfo fileInfo = new FileInfo(fileDialog.FileName);
            byte[] binaryData = File.ReadAllBytes(fileDialog.FileName);
            dataGridView1.Rows[dgvCell.RowIndex].Cells[1].Value = fileInfo.Name;

            if (_myAttachments.ContainsKey(dgvCell.RowIndex))
                _myAttachments[dgvCell.RowIndex] = binaryData;
            else
                _myAttachments.Add(dgvCell.RowIndex, binaryData);
        }
    }
}

The DownloadAttachment routine can be called on cell double click or the ‘Download’ button click event.

/// <summary>
/// Download Attachment from the provided DataGridViewCell
/// </summary>
/// <param name="dgvCell"></param>
private void DownloadAttachment(DataGridViewCell dgvCell)
{
    string fileName = Convert.ToString(dgvCell.Value);

    //Return if the cell is empty
    if (fileName == string.Empty)
        return;

    FileInfo fileInfo = new FileInfo(fileName);
    string fileExtension = fileInfo.Extension;

    byte[] byteData = null;

    //show save as dialog
    using (SaveFileDialog saveFileDialog1 = new SaveFileDialog())
    {
        //Set Save dialog properties
        saveFileDialog1.Filter = "Files (*" + fileExtension + ")|*" + fileExtension;
        saveFileDialog1.Title = "Save File as";
        saveFileDialog1.CheckPathExists = true;
        saveFileDialog1.FileName = fileName;

        if (saveFileDialog1.ShowDialog() == DialogResult.OK)
        {
            byteData = _myAttachments[dgvCell.RowIndex];
            File.WriteAllBytes(saveFileDialog1.FileName, byteData);
        }
    }
}

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Balu Sathish
Software Developer Calpine Technologies
India India
No Biography provided

Comments and Discussions

 
QuestionHow could i populate this grid with database Pin
Mohammad Imran18-Feb-15 20:24
memberMohammad Imran18-Feb-15 20:24 
QuestionDownload Attachment from WCF service Pin
kiquenet.com18-Nov-14 3:25
memberkiquenet.com18-Nov-14 3:25 
QuestionHow to add attach file for my second and third column Pin
Member 1094597318-Jul-14 15:45
memberMember 1094597318-Jul-14 15:45 
AnswerRe: How to add attach file for my second and third column Pin
Balu Sathish21-Jul-14 4:39
memberBalu Sathish21-Jul-14 4:39 
GeneralRe: How to add attach file for my second and third column Pin
Member 1094597321-Jul-14 10:30
memberMember 1094597321-Jul-14 10:30 
GeneralRe: How to add attach file for my second and third column Pin
Balu Sathish21-Jul-14 20:26
memberBalu Sathish21-Jul-14 20:26 
GeneralRe: How to add attach file for my second and third column Pin
Member 1094597322-Jul-14 5:31
memberMember 1094597322-Jul-14 5:31 
Questiondatagried Pin
Member 101908545-Oct-13 16:26
memberMember 101908545-Oct-13 16:26 
QuestionCan we open the file from DataGridView? Pin
TAN THIAM HUAT19-Jul-12 23:44
memberTAN THIAM HUAT19-Jul-12 23:44 
GeneralMy vote of 3 Pin
sharry2kool27-Jun-12 20:55
membersharry2kool27-Jun-12 20:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.150428.2 | Last Updated 25 May 2011
Article Copyright 2011 by Balu Sathish
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid