Comments by Ravi Kumar Shakya (Top 5 by date)

i already told you i want the data only for that perticular search page. then i dont think it will better to store in a session and for every new search viewstate can easily chamge but we cant change session automatically as viewstate.

Here you need to use a Column having identity or primary key so that with the help of that column value you can delete complete row of that table if the count of that value is more than on.

Can you please show me the table with the [Column Name] and [Data] of 10-20 rows or some sample table like that so that i can give you exact query.

It will not work becouse it will return you the rows with atleast having a record. You need to count no of repeatation for a row then delete the rows that are more than once, You can use Identity column to do this.


SELECT id, COUNT(*) TotalCount
FROM items
GROUP BY id
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC

I mean to say whenever i click on next, Data shuold be come from dataset only not from database. same with previous click.
I have a dataset with 1000s of records i want to fetch records again n again from dataset not from database.