try this
SELECT ADD_USER_ID,COUNT(PHOTO_ID) as ID FROM DSActor.DTL_PHOTOS GROUP BY ADD_USER_ID
and in gridview
<asp:boundfield datafield="ADD_USER_ID" headertext="Profile Id" />
<asp:boundfield datafield="ID" headertext=" Uploaded Photos" />
Hope this solution will Work for you :)