hope this could help http://www.nsftools.com/misc/SearchAndHighlight.htm[^] in the highlighting function, just break the code and return after the first highlight and hold the value in a local variable and see if you could give that value in the local variable as the starting index for the next search, hope this could work in the code u claimed u currently have, the one that does well for one time search. But defintly needs some tuning.

I think your way of approach is quite too complex for that task. If your aim is to show the rows that the user has checked in some other page, you could better take the ids of the checked rows, into a session variable and use a simple query just like the query which loads the grid in the first page with an extra where condition for the ids, so the ones that are selected alone will come. This should do ur task, it is strongly suggested that you dont take such values to database, just to show stuff in corresponding pages. And infact you can even do this with no database hit (for this purpose) in the second page, just take all the values of the selected rows into a datatable and take that datatable to the next page through session, but the session size will become heavy. Both the above ways are where your project allows to handle values in session, if that is not the case, you can try cookies too. and worst case your db method could help, and in your case, see whether the values u check are inserted in the table and use break points and see whether all the tables and rows that you want are in the dataset you are returned with.

hi ramana, Thnx, for ur help, but if u go through my post, u can see i have already done this ContentType method, but the problem is it will come as a single sheet, what i need is that each of the page i select should come in different excel sheet, Please see if you could do anything in this regard.

Hey people, Could somebody sujest a way to export a set of web pages to excel - a page a sheet. For single page exports i use the ContentType specifications. But im not able to export multiple pages. All pages come into a single sheet. I tried using Excel object, but as far as i could explore, it lets me to enter values to each cell which is almost impossible to do for a web page which contains data spread across many tables and tds (Un Structured). Moreover it consumes lots of time for execution. I also tried using OWCs 9.0 and 11.0, but msdn advises not to use it also it demands licensed office versions in client systems, that i cant guarantee. At last i tried to generate an XML document from the Response (HTML) string, to a XL schema valid xml. But converting tds with attributes to , really blows me off. Also child Tables are pieces i cant able to find a solution. Could somebody sujest a way for this problem.