"Anbu C Joseph" wrote:

> I having a problem where in I have to upload the excel document into BLOB db
> column of a table. I tried and I was able to upload the excel document. when
> the size of the excel document goes more than 32kb it fails and throws a
> conversion error. other wise it is working as desired.
>
> Following is the code I tried.
>
> 1) first i upload the excel file to the server.
> 2) The using byte stream I make the excel file to of file type
> 3) Then Insert the filetype to the BLOB column.
>
> Please give me a very good solution.
>
>

"Anbu C Joseph" <AnbuCJos***@discussions.microsoft.com> schreef in bericht
news:DEEA8F3F-9BD2-4C2B-8163-D85793418CAB@microsoft.com...
> The below problem is from ASP.net page and in VB.NET.
> Framework is 1.1
>
> "Anbu C Joseph" wrote:
>
>> I having a problem where in I have to upload the excel document into BLOB
>> db
>> column of a table. I tried and I was able to upload the excel document.
>> when
>> the size of the excel document goes more than 32kb it fails and throws a
>> conversion error. other wise it is working as desired.
>>
>> Following is the code I tried.
>>
>> 1) first i upload the excel file to the server.
>> 2) The using byte stream I make the excel file to of file type
>> 3) Then Insert the filetype to the BLOB column.
>>
>> Please give me a very good solution.
>>
>>

"Cor Ligthert [MVP]" wrote:

> AnBu,
>
> Because you succeed in files from below 32Kb, I think showing you a
> memorystream solution has no sense because you are using that most probably
> already.
>
> I don't know if you users should use it direct from your database. Otherwise
> is in my idea Zipping it first forever a good solution. In Net 2.0 is
> zipping integrated for 1.x are more than enough Zip solutions on Internet.
>
> http://www.sharpdevelop.net/OpenSource/SharpZipLib/Default.aspx
>
> http://www.gzip.org/zlib/
>
> Cor
>
> "Anbu C Joseph" <AnbuCJos***@discussions.microsoft.com> schreef in bericht
> news:DEEA8F3F-9BD2-4C2B-8163-D85793418CAB@microsoft.com...
> > The below problem is from ASP.net page and in VB.NET.
> > Framework is 1.1
> >
> > "Anbu C Joseph" wrote:
> >
> >> I having a problem where in I have to upload the excel document into BLOB
> >> db
> >> column of a table. I tried and I was able to upload the excel document.
> >> when
> >> the size of the excel document goes more than 32kb it fails and throws a
> >> conversion error. other wise it is working as desired.
> >>
> >> Following is the code I tried.
> >>
> >> 1) first i upload the excel file to the server.
> >> 2) The using byte stream I make the excel file to of file type
> >> 3) Then Insert the filetype to the BLOB column.
> >>
> >> Please give me a very good solution.
> >>
> >>
>
>
>