I have the datareader look into my table through an sql command and put its values into an array. it executes and read fine. i can can navigate through my records also. the problem is that I can not do a search again. it says there is a sharing violation. this is because my reader is still open. i would close it but i need to be able to navigate. is there a better option that what i am using? maybe a temporary table that it could store my filtered records that can be overwritten whenever i do a search again.