Stored Procedure returns Empty table to DATAREADER C#

See more:

C#

ASP.NET

hi,

I have used an StoredProcedure to return some records from an table. Hence i tried to saved it in an temp table and return those records from temp table to my application side.

I have tried as above but i got only EMPTY datareader with certain fields(columns) i have generated for temp table in SP.

Here is my SP,

ALTER procedure [dbo].[SP_SELECT_BILLDELETE]
As
Begin
SET NOCOUNT ON
IF EXISTS
(
SELECT *
FROM tempdb.dbo.sysobjects
WHERE ID = OBJECT_ID(N'tempdb..#MyTempTable')
)
BEGIN
DROP TABLE #MyTempTable
END
--Here i have Created an TempTable
select * into #MyTempTable from BillDelete where CONVERT(date,billdate,101) = CONVERT(date,GETDATE(),101) union
select * from WBillDelete  where CONVERT(date,billdate,101) = CONVERT(date,GETDATE(),101)

return
End

Here is my C# code to retrieve records from SP

sqlcon.Open();
               sqlcom = new SqlCommand("SP_SELECT_BILLDELETE", sqlcon);
               sqlcom.CommandType = CommandType.StoredProcedure;

               sqldr = sqlcom.ExecuteReader();
               if(sqldr.Read()) //Here it passed this condition and get into it
               {
                   dtable = new DataTable();

                   dtable.Load(sqldr); //Here i'm getting structure alone with no records
               }

               return dtable;