I created a DataAdapter, source from store procedure. Why I always get an error if the store procedure have the temporary table ? The error is : Invalid object name : #temptable

Below the script of store procedure

create procedure usp1
(@date1 datetime,
@date2 datetime)

as

create table #temptable
(product_code char(3) null,
product_name varchar(60) null,
createddate datetime)

insert #temptable
select product code, product_name, createddate from product where createddate >= @date1 and createddate <= @date2

select * from #temptable