Hi Venkat, U can dump the contents of ur data grid to an Excel sheet and dispaly it in the browser. So this will server u for both, Previewing as well as Printing. Here is how it goes ... 1. Create a new web form 2. Drag a drag a DataGrid control onto your Web form from the toolbar. Then right-click on the grid and choose Auto Format from the context menu. 3.In the code behind just add this code in Page Render or Page Load event Dim dt As DataTable = _ CType(Application.Item("MyGridData"), DataTable) Response.ContentType = "application/ms-excel" Response.AddHeader("Content-Disposition", _ "inline;filename=test.xls") DataGrid1.DataSource = dt DataGrid1.DataBind() DataGrid1.RenderControl(writer)
That's all u need to do. On the Page where ur Grid is present provide a print button and on click of this open this new aspx page which u have created. One more thing u need to take care is to make the dataset/datatable avaliable in the new aspx page.U can use the same dataset/datatable which u have used for binding to ur Data grid. Hope this helps. Cheers!! Siva |