Query the same datareader more than once

Question

I am creating a web app were people fill in boxes. Depending on the info they fill in, I only want certain values available for them afterwards. So I would start with a huge database(about 1 million names, adresses, postal code.....) query it first for a postal code that would be entered and then give them a drop down list of the last names available having that postal code. Once this is done, query the same database for the first names available with that postal code and also with the last name they picked just before. I was thinking of using a datareader but read that maybe a datagrid would be best. I'm new in vb.net(my third week on this job, internship for the summer) and I really need this to work. So what would be the best way to get this done without always having to query again the whole database each time with added parameters. I just want the database(datareader or datagrid) to diminish in size after each query so it goes faster. Any help would be greatly appreciated !!! Thanks!!!! vbnetrookie

yasser_8227 · Answer

It's better you use dataset rather than datareader. First query the database passing postal code as a parameter and populate dataset with valid values. Then Cache this dataset in memory to avoid database call. Display the last names in the ddl. Now when user selects last name query the dataset for first name passing last name and postal code as parameter instead of database. For more info: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbconDecidingOnDataAccessStrategy.asp On how to do RowFilter check this out: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataDataSetClassTopic.asp Cheers Yasser