<div>
This depends on the way how the file is stored on the MS SQL Server. Anyway it is easy - simply select the file by appropriate SQL command as any other value then save the retrieved value (yes, it can several megs but that's nothing for today's computers) to a temporary file and then attach this file to the e-mail message as any other file.<br />
<br />
Finally you should delete the temp file.<br />
<br />
Everything should be done at the ASP.NET server side.
</div>


This depends on the way how the file is stored on the MS SQL Server. Anyway it is easy - simply select the file by appropriate SQL command as any other value then save the retrieved value (yes, it can several megs but that's nothing for today's computers) to a temporary file and then attach this file to the e-mail message as any other file.

Finally you should delete the temp file.

Everything should be done at the ASP.NET server side.

<div>
Hi pcelba,<br />
<br />
Thanks for the affirmative idea.<br />
<br />
The docx or pdf are stored tblName.DocImage (image) with filename in &nbsp;tblName.DocFileName (varchar (50)) and PK at tblName.DocID (varchar(40)).<br />
<br />
Can you give me a working code to retrieve the DocImage based on PK and save to a temp file?<br />
<br />
<br />
Thanks.
</div>


Hi pcelba,

Thanks for the affirmative idea.

The docx or pdf are stored tblName.DocImage (image) with filename in  tblName.DocFileName (varchar (50)) and PK at tblName.DocID (varchar(40)).

Can you give me a working code to retrieve the DocImage based on PK and save to a temp file?


Thanks.

<div>
pcelba,<br />
<br />
I will try it and let you know.<br />
<br />
Thanks.
</div>


pcelba,

I will try it and let you know.

Thanks.

<div>
Great sources provided to help me come up with a solution.
</div>


Great sources provided to help me come up with a solution.

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
I'm using ASPNETEmail and I'm looking how to automatically fetch docx or pdf file with specific filename from MS SQL database and attach to an email. <br />
<br />
The best solution would be highly appreciated,<br />
<br />
<br />
Thanks.
</div>
</div>


Dear Experts,

I'm using ASPNETEmail and I'm looking how to automatically fetch docx or pdf file with specific filename from MS SQL database and attach to an email. 

The best solution would be highly appreciated,


Thanks.

How can I fetch docx or pdf file from MS SQL column for auto email attachment?

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.

Software

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.