One possibility is that when you make a new query: - save the last results in a datatable 1 (the currently binded datatable) - execute a new query - from the query save the results to datatable 2 - merge datatable 1 and 2 to datatable 3 - bind the datatable 3 to the grid You can do this with two datatables also if you want. For information about Merge, see http://msdn.microsoft.com/en-us/library/fk68ew7b.aspx[^] The need to optimize rises from a bad design.My articles[^]

Hi Mani, in your problem, u can save your last data in datatable variable. To use session variable, Session["mySearchResult"] = searchResultTable; searchResultGridView.DataSource = searchResultTable; searchResultGridView.DataBind(); When u search new keyword and return data back from server, save it in temp table. then retrieve your previous saved table from Session. and Loop through every row again and add it into old table and re-save it to Session. newSearchResultTable = // new search result data from server; searchResultTable = Session\["mySearchResult"\] as DataTable; // get back from session foreach(DataRow row in newSearchResultTable.Rows) // loop every rows { searchResultTable.Rows.Add(row); // add to existing table } Session\["mySearchResult"\] = searchResultTable; // save back and bind again searchResultGridView.DataSource = searchResultTable; searchResultGridView.DataBind(); Hint: when u enable the "EnableViewState" to false, your selected info will not be avaliable from the server. Hope it works,

Ali Al Omairi(Abu AlHassan) wrote: they are wasting their time and also other's. I think that may or may not be the case; I have learned lots of useful things by taking someone else's code and working through it. However, I usually start by studying the basics of the language in question. I must get a clever new signature for 2011.

You are right of course, I misread the getPath() function. I must get a clever new signature for 2011.

Or as we say "You can lead a horse to water but you cannot make it drink". However, one of the main qualities necessary to be a programmer (or anything else) is the ability to do one's own research. The sooner some of the questioners here learn that (hard) lesson, the better they will become. Merely posting questions asking others to do the work for them means they will not learn anything of much use, and will certainly not go very far in life. I must get a clever new signature for 2011.

i mean OO (Object Oriented). but forget it for now.