Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving Excel Sql Server Image Field
I have a document module function running a my website that displays txt,
pdf, xls, ppt, doc files that are stored in a Sql Server 2000/2005 database table (image field). I would like to write a function triggered from a button event that saves the spreadsheet directly to the database table. I have 2 scenarios: 1) This routine writes the file disk and using VB.Net ADODB.Stream, saves to the database. I would like to remove the save to disk code and convert "This.Application" to an internal in-memory/in-process object which can be written to the database. ======= Code Sample 1 ============================== ** VSTO Button Event Invokes SaveAs method and save to disk. Dim AttachFileStream As New ADODB.Stream AttachFileStream.Type = ADODB.StreamTypeEnum.adTypeBinary AttachFileStream.Open() AttachFileStream.LoadFromFile(fname) rs = New ADODB.Recordset rs.AddNew() rs.Fields("reportFile").Value = AttachFileStream.Read rs.Update() AttachFileStream.Close() ========== End ==================== 2) Office Automation Executable in VB.Net (Visual Studio 2005) ========== Code 2 ================== myExcelApp = New Excel.Application <== creates Excel via VB.net Windows app ========== End ==================== As with example #1 above, I would like to save "myExcelApp" directly to SqlServer 2000/2005. Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving Excel workbook in SQL server using c# | Excel Programming | |||
Saving Excel workbook in SQL server using c# | Excel Discussion (Misc queries) | |||
Saving Excel workbook in SQL server using c# | Excel Programming | |||
Saving Excel workbook in SQL server using c# | Excel Programming | |||
Read Image From SQL Server n Export to Excel | Excel Programming |