如何使用SQLDataAdapter从同一个表访问多个记录？

This almost works. I get an error at the last line that looks like it's complaining about the C1 reference. Is there a simple way around this? There is nothing wrong with the query or connection.This almost works. I get an error at the last l