I used stored procs too, but you can set them as the source in your table adapter. I make a stored proc that returns name and address from a large table, set it as my select source for the table adapter, change the klunky name it uses by default, and then I have a data table with name and address. Works well for me... if I can just figure out how to use it... ;-)