Try this:
string query ="select f.fileName,(CONVERT(varchar(100), f.fileType) + ' - ' +CONVERT(varchar(100),f.fileSize))as fileInfo,f.filepath,f.createdOn,f.statusId,s.statusName from fileInfo As f left join status As s on f.statusId=s.statusId where userId=(select userId from userInfo where email = '" + key + "')"
[EDIT]
ALTER PROC Grid_getAlldata @email NVARCHAR(50)
AS
BEGIN
SELECT fileInfo.fileName, (CONVERT(VARCHAR(40),fileInfo.fileSize) + '<br/>' +CONVERT(VARCHAR(40), fileInfo.fileType)) AS fileInformation,
fileInfo.filePath, fileInfo.createdOn,fileInfo.statusId,status.statusName FROM fileInfo INNER JOIN STATUS
ON fileInfo.statusId=status.statusId WHERE userId IN (SELECT userId FROM userInfo WHERE email=@email)
END
[/EDIT]
--Amit