sp_helpfile will tell you the database file size which have been allocated to your database.

SELECT FILEPROPERTY('yourdatabaselogicalfilename', 'spaceused') will give you space used for your database files.