Hello,

In Visual Studio .NET's database project, when creating Yukon SP's, I saw there was a ExecuteResultSet object, but it was marked obsolete. So, is there a way to return a large resultset to the caller of the stored procedure? How do you implement code to return a select statement created in the database project?

Thanks,

Brian

__________________
Brian

Use this code to return Select statement results in a database project –

  Dim DA As New SqlDataAdapter("SelData", SqlConnection1)
  'SelData - Stored Proc
  DA.SelectCommand.CommandType = CommandType.StoredProcedure
  DA.TableMappings.Add("TBL1", "DS")
  Dim DS As New DataSet
  DA.Fill(DS, "DS")