tag:blogger.com,1999:blog-37737284168589044142011-04-21T16:02:07.630-07:00sAiKhttp://www.blogger.com/profile/12690293164862524974noreply@blogger.comBlogger11100tag:blogger.com,1999:blog-3773728416858904414.post-77359588343642756922009-03-30T07:35:00.000-07:002009-03-30T07:50:39.705-07:00I added a dataset to my C# .NET project visually and tried adding a TableDataAdapter to it using a stored procedure which I had written previously. This stored procedure has a temp table #Attrition within it and the TableDataAdapter Configuration Wizard didn't seem to like this. I got an error Invalid object name "#Attrition". The solution that I figured for this is to use a @table variable instead of temp table. So I replaced<br /><br /><span style="font-family:courier new;">CREATE TABLE #Attrition<br />(<br />DeptID int,<br />Voluntary int<br />)</span><br /><br />with<br /><br /><span style="font-family:courier new;">DECLARE @Attrition TABLE<br />(<br />DeptID int,<br />Voluntary int</span><br /><span style="font-family:courier new;">)</span><br /><br />and also removed the following statement at the end of the procedure<br /><br /><span style="font-family:courier new;">DROP TABLE #Attrition</span><br /><br /><br />This seems to have done the trick.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/3773728416858904414-7735958834364275692?l=nutsaboutnet.blogspot.com' alt='' /></div>sAiKhttp://www.blogger.com/profile/12690293164862524974noreply@blogger.com1