CODEWITHSUNDEEP
asp.netsql-serverasp.net-mvc-3sql-server-2008linq-to-sql
ePezhman
ePezhman

Reputation: 4010

"String or binary data would be truncated" in uploading file in ASP.NET MVC3

I'm developing some application in ASP.NET MVC3 and trying to upload some file in SQL Server 2008, I have the type varbinary(MAX) in DB and I have the code below for uploading it, but I get the error "String or binary data would be truncated . The statement has been terminated" which I believe it's a data base error, where do you think my problem is? thanks

if (UploadedFile != null)
            {
                App_MessageAttachment NewAttachment= new App_MessageAttachment { FileName = UploadedFile.FileName, FilteContentType = UploadedFile.ContentType, MessageId = NM.Id, FileData = new byte[UploadedFile.ContentLength] };
                UploadedFile.InputStream.Read(NewAttachment.FileData, 0, UploadedFile.ContentLength);
                db.App_MessageAttachments.InsertOnSubmit(NewAttachment);
                db.SubmitChanges();
            }

Upvotes: 1

Views: 2571

Answers (2)

Jeremy Gray
Jeremy Gray

Reputation: 1418

I would start with Management Studio -> Tools -> SQL Profiler. Point it at your database and run the upload again. Press pause or stop after you see the error in your app and search for the error message within the trace window. This will give you the SQL that generated this message. If the solution doesn't immediately present itself to you, edit your post with the statement that failed.

Here are some Profiler resources

SQL Server Profiler Step by Step

How To: Use SQL Profiler

Upvotes: 0

Bryan Walker
Bryan Walker

Reputation: 921

That is a database error, but it isn't necessarily associated with the file portion of the insert. Check to make sure that FileName, FileContentType, and MessageId are all short enough to fit within their fields in the database.

Upvotes: 4

Related Questions