title: Visual studio 2013 dataset not showing up column name for dynamic query of stored procedure
body: <p>I'm using a dynamic query in stored procedure as a tableadapter while creating a dataset in visual studio 2013. The problem is Data Column is not showing up Parameters and field for SELECT operation. Please find the screenshot:
  <img src="https://i.stack.imgur.com/BcEWl.png" alt="no parameters"></p>
  
  <p>I'm not sure if this dynamic statement will work in this case.. Anybody know any possible way to use this stored procedure as datasource in my report.
  query in stored procedure.</p>
  
  <pre><code>DECLARE @DynamicSQL nvarchar(4000)
  SET @DynamicSQL = N'SELECT * FROM ' +@TableName + 
  ' WHERE ClassName='+@OperationName+' AND (RunTime BETWEEN '+@Date1+' AND '+@Date2+')
  AND TestCaseId = ISNULL('+@TestCaseId+', TestCaseId)
   AND TestRunResult = ISNULL('+@TestRunResult+',TestRunResult) 
  
  EXECUTE sp_executesql @DynamicSQL
  </code></pre>