Can I upload a PDF file on AddEditReview.aspx page?

southside123 · April 23rd, 2014, 10:41 AM

You're right Imar! That was my mistake all the time. Now I know what's the problem. Thanks.

But now there's another error when inserting the pdf file together with a review on the AddEditReview.aspx.

You did for the pictures in this way:

Code:

int photoAlbumId = Convert.ToInt32(Request.QueryString.Get("PhotoAlbumId"));
    Picture myPicture = (Picture)e.Entity;
    myPicture.PhotoAlbumId = photoAlbumId;
    myPicture.ImageUrl = virtualFolder + fileName + extension;

I'm trying this way on the DetailsView1_ItemInserting:

Code:

int bookId = Convert.ToInt32(Request.QueryString.Get("BookId"));
        Review review = (Review)e.Values;
        review.BookId = bookId;
        review.PDFUrl = virtualFolder + fileName + extension;

But I'm getting:

Unable to cast object of type 'System.Collections.Specialized.OrderedDictionary' to type 'ELibraryModel.Review'.

Error on line:

Code:

Review review = (Review)e.Values;

I don't know If I'm doing it right.

Imar · April 23rd, 2014, 02:08 PM

If you're not using Entity Framework, you don't have access to an actual Review instance. Instead, e.Values contains a dictionary with Key/Value pairs for all columns in the Review table.

Provided that BookId and PDFUrl are in your SELECT statement and Parameters, something like this should work:

e.Values["BookId"] = bookId;
e.Values["PDFUrl"] = virtualFolder + fileName + extension;

Hope this helps,

Imar

southside123 · April 24th, 2014, 06:56 PM

Hi Imar,

I'm trying as you said:

Code:

protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
    {
        e.Values["UpdateDateTime"] = DateTime.Now;

        int bookId = Convert.ToInt32(Request.QueryString.Get("BookId"));

        e.Values["BookId"] = bookId;

        // Insert book
        FileUpload FileUpload1 = (FileUpload)DetailsView1.FindControl("FileUpload1");
        string virtualFolder = "~/PDF/";
        string physicalFolder = Server.MapPath(virtualFolder);
        string fileName = Guid.NewGuid().ToString();
        string extension = System.IO.Path.GetExtension(FileUpload1.FileName);
        
        // Upload file
        FileUpload1.SaveAs(System.IO.Path.Combine(physicalFolder, fileName + extension));

        // Assign url to db
        
        e.Values["PDFUrl"] = virtualFolder + fileName + extension;

        // Validate book's type
        if (!FileUpload1.HasFile || !FileUpload1.FileName.ToLower().EndsWith(".pdf"))
        {
            CustomValidator CustomValidator1 = (CustomValidator)DetailsView1.FindControl("CustomValidator1");
            CustomValidator1.IsValid = false;
            e.Cancel = true;
        }
    }

But still the same error:

String or binary data would be truncated.
The statement has been terminated.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): String or binary data would be truncated.
The statement has been terminated.]
System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1789294
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5340642
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +244
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1691
System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +275
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +1421
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +177
System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) +208
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +163
System.Web.UI.WebControls.SqlDataSourceView.Execut eDbCommand(DbCommand command, DataSourceOperation operation) +378
System.Web.UI.WebControls.SqlDataSourceView.Execut eInsert(IDictionary values) +399
System.Web.UI.DataSourceView.Insert(IDictionary values, DataSourceViewOperationCallback callback) +81
System.Web.UI.WebControls.DetailsView.HandleInsert (String commandArg, Boolean causesValidation) +365
System.Web.UI.WebControls.DetailsView.HandleEvent( EventArgs e, Boolean causesValidation, String validationGroup) +584
System.Web.UI.WebControls.DetailsView.OnBubbleEven t(Object source, EventArgs e) +89
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.DetailsViewRow.OnBubbleE vent(Object source, EventArgs e) +80
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.Button.OnCommand(Command EventArgs e) +114
System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +159
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +35
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724

Imar · April 27th, 2014, 08:42 AM

Looks like the same issue: you're sending data that is larger than the column in the table can hold. Try debugging e.Values and see what data you are sending, and then look in the database to see if the max. column length matches the size of the data you're sending.

Imar