Comments by Sriram Chitturi (Top 17 by date)

You have to provide more details.
How are you creating the report? Any details..

Give details of your web.config and settings on your Application and IIS server

a) What is the Type of the SQL server column 45?
b) You are creating a stream to the buffer and writing to the buffer back why?
also
c) what are you saving to in image.Save(...) call ?

If you want to read from that file, then call Image.FromFile()

Rakesh
unless you give a hint of how you are displaying the hindi characters on your page we cannot help you.

Shan
The connections to the DB are pooled by ADO.NET as long as the connection string is constant. So pretty much you will be reusing the same connection every time you are polling the database.
Here are few problems with the WCF approach
a) there may be a restriction on the number of concurrent connections you can make from a process to FTP server, so the individual requests have to know how many requests are actively dowloading
b) the FTP server can restrict the number of connections you can me from a machine or for a login - the effect is same as (a) above
c) WCF request timeout, but you can control that

As long as you do not see the above issues, you are fine. Otherwise just go by the Windows service and it is easier to implement.

Do you have a SQL Server on a server machine?

If yes, move the dbSQLTest.mdf file to the that server and attach the database.

See the following link : http://msdn.microsoft.com/en-us/library/ms190209.aspx

Create a login in SQL Server to be used by the application. Or if you want to use to windows domain logins user CREATE LOGIN <domain\login> from WINDOWS.

Check this link : http://msdn.microsoft.com/en-us/library/ms189751.aspx

Change the connection string in the application to:

a) if using a sql server login -"DataSource=<server>;Database=<database>;User=<login>;Password=<pwd>;"

b) if you are using Windows logins

"DataSource=<server>;Database=<database>;TrustedConnection=true;"

Check http://www.connectionstrings.com for different types of connection strings.

But then it is always going to read only one file called filename.txt.

Or am I missing something?

Shan
why is the request to web service getting queued? If this is because of a restriction with the number of FTP calls you can make?
If you are implementing a windows service, then remove the CLR trigger itself and keep polling the table for pending rows at regular intervals based on status, that is much better in terms of design.
If there is a restriction on number of FTP calls you can make and the downloading is queued in the windows service also, then use multithreading and a semaphore to control the number of threads downloading from FTP.

You must be using an old version of software.
What is the version of Crystal Reports are you using?
Also what software suite are you using?

Since you are using C# and ASP.NET - you can use SmtpClient and MailMessage classes in System.Net.Mail namespace.

Refer this page for an example of sending the mail
http://weblogs.asp.net/scottgu/archive/2005/12/10/432854.aspx

Here is a good page with SMTP server settings with different ISPs
http://www.emailaddressmanager.com/tips/mail-settings.html

If your own ISP provider is providing this service refer to their web site or contact support for servername and port.

Which version of Visual Studio are you running?
How are you starting the application? - "Start without debugging" or "Start Debugging"?
What is the complete URL? -can you share.

Anoop, there is nothing wrong with your code. It worked as it is from my machine.
Did you get a chance to set the proxy address in web.config and try.