"None can stop the rising sun, clouds can hide for a while........" -Ravi

Tuesday, January 27, 2009

Error when exporting GridView to Excel

Fix for error :" Control 'ctl00_ContentPlaceHolder1_Gridview1' of type 'GridView' must be placed inside a form tag with runat=server"

Fix: Add the following code in cs file.

public override void VerifyRenderingInServerForm(Control control)
// Confirms that an HtmlForm control is rendered for the
//specified ASP.NET server control at run time.


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

First try by using Connect time out

If it won't work, make the commandtimeout to 0
ex: sqlCmd.CommandTimeout = 0;

The Connect Timeout attribute of a SQL Connection string determines how long a SqlConnection Object runs before it stops attempting to connect to a server