Arun,

As far as I'm aware the Command object lets you return return codes and output parameters from a stored procedure the connection object can't.
Say if you were batch updating with the stored proc you could return how many records you added/edited/deleted etc. from the sp.

They also say its more reliable, hmmmm!

John