Showing a Excel report in a Web Page by using Response.Content Type

When showing Excel in a Webpage using a dataset and binding the dataset to a datagrid. Make sure that you keep EnableViewState=false.This is because State is getting lost when you bind the data to the datagrid.This is to maitain state accross the webpage.