>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... ;-)
Well, sure that would work if your Stored Proc only returns one table. My point is that most of my Stored Procs return more than one table and so I fill a DataSet.