We are attempting to utilize the datarepeater, however, we have run into a glitch!
Here's the issue: when we perform the search we take the results and dump them into a temporary SQL Server table becuae we only want the records returned that match the query. The repeater returns the whole table starting with the first record of the query. So, we can read the temp table into the repeater fine, but when we call another search the repeater displays the previously selected record. The only way we can view the current record is to re-start the program. It's like the repeater has it's own memory. How can we re-query our table and have the repeater display the new results without unloading the program?
Here's the issue: when we perform the search we take the results and dump them into a temporary SQL Server table becuae we only want the records returned that match the query. The repeater returns the whole table starting with the first record of the query. So, we can read the temp table into the repeater fine, but when we call another search the repeater displays the previously selected record. The only way we can view the current record is to re-start the program. It's like the repeater has it's own memory. How can we re-query our table and have the repeater display the new results without unloading the program?