Error in uploading files in DB

Harlem 98

4y1.5k.NET

Hello.

I'm trying to save files in DB, which should record the file as "BinaryData".

I'm using Telerik's framework RadAsyncUpload method, similar to a normal FileUpload, but when i upload the file i get the extension

"System.IO.IOException: The process cannot access the file because it is being used by another process."

and the file only gets loaded in the App_Data folder of my app, in an automatically created "RadUploadTemp" folder.

I've tried to disable the Path mentions in my SaveFile method, getting "Path not found error". Any of the available telerik demos is similar to my context.

How do i solve this?

//my insert/update operations method
public void SaveFile(object sender, EventArgs e){ListagemTimesheet model = new ListagemTimesheet();model.IDRecursoHumano = Convert.ToInt32(rdpInvestigadorE.Text);model.IDEstadoTimesheet = Convert.ToInt32(rcbEstado.SelectedValue);model.Observações = Obervaçoestxt.Text;model.AssinaturaTimesheet = txtAssinaturaTimesheet.Text;model.DataEnvio = DataEnvio.SelectedDate.Value;if (!string.IsNullOrEmpty(Ficheiro) && FileTipo != null){model.Ficheiro = Path.GetFileNameWithoutExtension(Ficheiro);model.FileContent = fileBytes;model.FileTipo = Path.GetExtension(FileTipo);}if (!string.IsNullOrEmpty(FileID.Text) && Convert.ToInt32(FileID.Text) > 0){model.ID = Convert.ToInt32(FileID.Text);listagembll.UpdateFile(model);}else{listagembll.InsertFile(model);}//Ascx.Cs methodpublic void RadAsyncUpload1_FileUploaded(object sender, FileUploadedEventArgs e){RadAsyncUpload1.Visible = false; //falsevar liItem = new HtmlGenericControl("li");Ficheiro = e.File.FileName; // sintaxe metodoFileTipo = e.File.ContentType;e.IsValid = true;e.File.InputStream.Position = 0;fileBytes = new byte[e.File.InputStream.Length];for (int totalBytesCopied = 0; totalBytesCopied < e.File.InputStream.Length; )totalBytesCopied += e.File.InputStream.Read(fileBytes, totalBytesCopied, Convert.ToInt32(e.File.InputStream.Length) - totalBytesCopied); //conversao para bytes}//Ascx reference
Formatos permitidos: pdf,xlsx,xlsm,xls,txt

Here you can see a DEMO, which shows the funcionality implemented with images and with their datacontext, which unfortunatly i cannot addapt to my 3 tier architecture

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Harlem 984y ago
Thak you for your awnsers. I have made changes to the method, and now i don´t have exceptions, target file is created and file name is saved in DB, but FileContent (the file itself) saves as null.

Also, it only allows me to use the method once.
//partial class declarations

(...)

        string Ficheiro = string.Empty;
        string FileTipo = string.Empty;

       byte[] fileBytes = null;

(...)

//DataBase save method
public void SaveFile(object sender, EventArgs e)
        {
            ListagemTimesheet model = new ListagemTimesheet();

            model.IDRecursoHumano = Convert.ToInt32(rdpInvestigadorE.Text);
            model.IDEstadoTimesheet = Convert.ToInt32(rcbEstado.SelectedValue);
            model.Observações = Obervaçoestxt.Text;
            model.AssinaturaTimesheet = txtAssinaturaTimesheet.Text;
            model.DataEnvio = DataEnvio.SelectedDate.Value;

            if (Objecto.ID > 0)
            {
                model.ID = Convert.ToInt32(FileID.Text);

                if (!string.IsNullOrEmpty(Ficheiro) && FileTipo != null)
                {

                    model.Ficheiro = Path.GetFileNameWithoutExtension(Ficheiro); //FileName
                    model.FileTipo = Path.GetExtension(FileTipo); //FileExtension
                    model.FileContent = fileBytes; //Content
                }

                if (!string.IsNullOrEmpty(FileID.Text) && Convert.ToInt32(FileID.Text) > 0)
                {
                    model.ID = Convert.ToInt32(FileID.Text);
                    listagembll.UpdateFile(model);

                }
                else
                {

                }
            }

//Code-behind
protected void Page_Load(object sender, EventArgs e)
        {
            RadAsyncUpload1.TargetFolder = Server.MapPath("~/TargetFiles");
        }

public void RadAsyncUpload1_FileUploaded(object sender, FileUploadedEventArgs e)
        {
            RadAsyncUpload1.Visible = false;
            Stream fileStream = e.File.InputStream;
            Ficheiro = e.File.FileName; // sintaxe metodo
            FileTipo = e.File.ContentType;
            e.IsValid = true;
            byte[] dados = new byte[fileStream.Length - 1 + 1];
            fileStream.Read(dados, 0, System.Convert.ToInt32(fileStream.Length));
            fileStream.Close();
        }
//FrontEnd
"RadAsyncUpload1" runat="server" AllowedFileExtensions="xlsx,xlsm,xls,txt,pdf" MultipleFileSelection="Disabled"  OverwriteExistingFiles="true" OnFileUploaded="RadAsyncUpload1_FileUploaded" UploadedFilesRendering="BelowFileInput" Culture="pt-PT" TemporaryFileExpiration="00:30:00" ToolTip="Anexar ficheiro">class="allowed-attachments">Formatos permitidos: class="allowed-attachments-list">pdf,xlsx,xlsm,xls,txt
Any ideas?
Rijwan Ansari4y ago
You can check below code:
ASPX:
<telerik:RadAsyncUpload runat="server" ID="RadAsyncUpload1" TargetFolder="~/Images/Img/"
    AllowedFileExtensions=".jpg" MaxFileSize="57971152" MultipleFileSelection="Automatic"
    UploadedFilesRendering="BelowFileInput" OnFileUploaded="RadAsyncUpload1_FileUploaded">
telerik:RadAsyncUpload>
<br />
<telerik:RadButton ID="RadButton1" runat="server" Text="Submit">
telerik:RadButton>
C#
protected void RadAsyncUpload1_FileUploaded(object sender, FileUploadedEventArgs e)
{
    Stream fileStream = e.File.InputStream;
    byte[] attachmentBytes = new byte[fileStream.Length];
    fileStream.Read(attachmentBytes, 0, Convert.ToInt32(fileStream.Length));

    System.Data.SqlClient.SqlConnection conn = null;
    try
    {
        try
        {
            conn = new System.Data.SqlClient.SqlConnection(
                ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString);
            conn.Open();
            System.Data.SqlClient.SqlCommand insertCommand =
                new System.Data.SqlClient.SqlCommand(
                "Insert into [Pictable] (msgid, pic1) Values (1, @Pic)", conn);
            insertCommand.Parameters.Add("@Pic", SqlDbType.VarBinary).Value = attachmentBytes;
            int queryResult = insertCommand.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
        }
    }
    finally
    {
        if (conn != null)
        {
            fileStream.Close();
            conn.Close();
        }
    }
}
Sachin Singh4y ago
first set the target folder
"RadUpload1" runat="server" overwriteexistingfiles="true" targetfolder="~/MyFiles" />
"server" ID="Button1" Text="Submit" />
On submit event get the file conetent andpass that to your data access method (insert statement)
UploadedFile attachment = RadUpload1.UploadedFiles[0];

// create byte array
byte[] attachmentBytes = new byte[attachment.InputStream.Length];

// read attachment into byte array
attachment.InputStream.Read(attachmentBytes, 0, attachmentBytes.Length);

// pass the attachmentBytes to your insert statement
Srinivasan Ramamoorthi4y ago
check this link
https://www.telerik.com/forums/how-to-avoid-io-exception-when-using-radasyncupload