What do you think should I do - create one SP that will return multiple resultsets or multiple SPs to return one resultset each? If the later, should I create multiple properties for each DS and use GetDataSet for each one?

Naomi, if the tables are related in some logical way, it is usually better to have one SP that returns multiple result sets...