Saving PDF files to database

Dear Friends

I have a requirement to save pdf files to database and need to send those saved pdf files thru emails. How can i save the pdf files to database and send those files as attachment by using a stored procedure in the database server. I cannot sent the emails from the client because there are thousands of such files which is not a good soulution. Am expecting some guidelines

Vinu M

If you're using SQL Server 2005, try Database Mail: http://msdn2.microsoft.com/en-us/library/ms175887.aspx

Saving Data and retrieving it from the database

Heres my requirement from a financial analysis im doing...

I have just calculated an industry averages on financial ratios...Now i wanna upload this industry average to the system...so that I can compare it to the individual companies' averages after calculating a particular company's average; meaning i wanna be able to call the industry average of a particular ratio (eg Current Ratio) after calculating a company's corresponding ratio...Is there a code fragment i can use for this ??

Thanks in advance...

Adam

Hi,

From your description, it seems that you are going to retrieve the industry averages which you stored in database after calculating particular company's averages, right?

I think the code should be based on the data structure. I don't know how do you handle with your data storage in your project? Does each company's average data stored in a table? Where does the industry average data comes from? It comes from manually calculating? If so, what you should do is just save the data into a single data table, when you are going to calculate each company's average, retrieve the data from your database and save it in a seesion or viewstate to avoid reading the value from database frequently.

Above is just the general idea for your question, as for detail code, it depends on what kinds of way you are going to use, SqlDataReader, Dataset and etc… But the usage of this kinds of data accessing technique can be found at the following address.
http://quickstarts.asp.net/QuickStartv20/aspnet/doc/data/default.aspx

Thanks.

sql

Saving and retriving data to SQL db from FCKeditor

Hi Every one

I m using FCKeditor in my web application and my requirement is to create and edit documents in FCKeditor.

The problem is in storing the data. it is not storing the data in the DB. its only stors some html code but it is incomplete.

Please some one Solve this problem

HI

FCKeditor stores HTML in a hidden field which can then be stored in the database or displayed on another page.

Could you please elaberate your issue or post some code so we could be more helpful.

sql