This article will show you how to export Gridview to Excel

Have the gridview on the aspx page. Then place a button called BtnExport on the page. Add a click event to the button and write this following code.

You are getting the following error:

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

You may need to increase your timeout on the connectionstring and the SQL command.

Umbraco is a great CMS to use and it is gear towards developer gather then end user. Unlike Joomla it is not a plug and play architecure but rather a framework giving the developer a greater flexibility to control the look and feel of the web application. One of the hickup you may find during the installation are: No connection to repository. Runway could not be installed as there was no connection to: 'http://packages.umbraco.org'

Here is how you can embed Windows Media Video file into a webpage. Just copy and paste it in your code and replace the src file name with your file name. 

TcpTrace server a tunnel between the client and the server. It monitor the traffic back and and forth between this tunnel. Start tcptrace.exe and up comes a dialog box asking for local port #, destination server, and destination port # (Ignore the logging options for now) Fill these in, click Ok.

Local Port #         8080
Destination Server   www.razorsoft.net
Destination Port #   80

Now configure your client so that it thinks the server is at localhost:8080. tcpTrace will forward all the traffic from localport:8080 to the remote server (and vica versa), dumping the contents in the process. If you are hosting a server say on port 80 and want to use it, then change your server to run on port 81, and setup

Local Port #         80
Destination Server   localhost
Destination Port #   81

For more info visit pocketsoap.

Solution 1:

When you deploy or try to open a report on the reporting services 2008 you may get an error "The underlying connection was closed: An unexpected error occurred on a send". How I solve this problem is that I check the reportserver.config file and make sure it is correct. The default value key SecureConnectionLevel may be set to 2, this will require SSL configuration. Where you do not need to use SSL you can turn it off and set it to 0. This will make the services unsecured but will work.

Solution 2:

If you are getting a similar error message for Web Services then try the following:

Often we all want to spend as little effort as possible yet to get as much result as we can. Just as I am writing this article I want to write a little as I can yet I want to deliver the information to you as much as I could. The Dataset allow us to write very little code yet it has so much capabilities. Behind the scene the Dataset actually uses the DataReader itself. The DataReader is a readonly class that enable you to retrieve data quickly and return data soon as the result is available.Dataset on the other hand wont be availble until it fully populates the whole Dataset. You should only use dataset when you need to perform a data manipulate and store it back to the database. However the majority of the time all we need to use is the DataReader.

With ASP.Net 2 now we have a new class call SqlDataSource. This class enable you to quickly populate the gridview without any knowledge of coding, how cool is that hey?

First set the connectionstring in the web.config file.

QVISLib - C# Handy Library

After frustrating rewrite all this method time after time I have compile it into a handy library which I can re-use them time over time again. I thought I might share this to everyone out there who would find this useful too. All source code and demo application are availble in this download.

When we need to know information about the the database it self, we can query the database schema from the system object.

Here are some basic command you can use to query database meta: