I will look at your Project Tomorow when i get to the Office. now i need to ask you some few questions about what i see in your Code

The SP "Contacts_AllContacts_Select", Who owns the Sp, For an Exampel , if you call a SP that is Owned by the different user just like that , well SQL is supposed to tell you that the SP does not Exists. try to put a User of the SP like this

Code:
dbo.Contacts_AllContacts_Select
To fid out who is the Owner of the SP, in your management Studio , Go to Database, digg below Programibility and choose the StoredProcedure and in the StoredProcedure, look for you Sp "Contacts_AllContacts_Select", Check the Prefix of the SP. If i helped rate me.