Reportviewer and Temp Variables

Reportviewer and Temp Variables

kick it on DotNetKicks.com   While working with report viewer and Stored procedures which uses temporary variables
you might have got the problem of not getting schema in dataset. To resolve this issue use Table variables to return table instead of returning usine table varaibles
like select * from #temp

e.g of Table variable

Declare @x Table (ID bigint identity(1,1), Name varchar(50))

Insert into @x (Name) values('Satalaj More')

Select * from @x

********************

Table variables work similar to temporory variables you can get more details about temporory variable and

table variable at here http://www.codeproject.com/KB/database/SQP_performance.aspx

-Satalaj

Tags:

gridview add new rowGridview select emailTemporary disposable emailasp.net Gridview checkboxGridView EditNo Visual Studio template information found See the application log in Event Viewer for more detailsCould not allocate space for object dboSORT temporary run storageHow are you using session variables in Asp.net with C#.netGridView RowLinq Inner JoinJquery Gridview Dropdownlist Selected Change Enable Disable Controls

Author

My name is Satalaj, but people call me Sat. Here is my homepage: . I live in Pune, PN and work as a Software Engineer. I'm former MVP in ASP.net year 2010.
Disclaimer: Views or opinion expressed here are my personal research and it has nothing to do with my employer. You are free to use the code, ideas/hints in your projects. However, you should not copy and paste my original content to other web sites. Feel free to copy or extend the code.
If you want to fight with me, this website is not for you.
 

I'm Satalaj.