thanx a lot, will try the 1st option.

I hope this is a bad practice.. In your code connection is open and seems to be never closed. Best thing to do is to use Paging in Sql server with @rowsPerPage being 1 and @pageNum being row no. hope u understand the concept ----------------- logiclabz

Next time you post a question, post it in proper english. Type 'we' instead of 'v' and someone might help you. 2) Post the portion of code where you are having a problem with 3) Use google to find your answer To move to the next record, use the .Read method. SqlDataReader dr = comm.ExecuteReader(); //where comm is SqlCommand dr.Read(); //Fetches next record

ur saying that i should create a flag field in my database , and everytime a user logs in set flag to 1, and then on logging out set flag to 0.right? is there any easier way?