DataSet Designer not generating classes

9 Jan 2006 3:41 PM

Roy

I'm attempting to generate a TableAdapter for a stored procedure in my Sql
Server 2000 data source.

DataSet Designer generates most of the TableAdapters ok, but for several of
them, DataSet Designer does not generate all the classes. For example, The
following classes are not generated:

DataSet
DataTable
DataRow
ChangeEvent
ChangeEventHandler

Additonally, the generated TableAdapter is also incorrect. The partial class
name generated is: QueriesTableAdapter which has no relevance to the stored
procedure.

I'm thinking the the DataSet Designer must be attempting to determine the
stored procedure's schema or something and is failing to do so.

Here's one of the stored procedures that fail:

ALTER PROCEDURE dbo.sp_VMPFAnnouncementsGetIndividualAnnouncement
(
   @AnnouncementID INT
   ,@Headline VARCHAR(200) OUTPUT
   ,@FullText VARCHAR(7500) OUTPUT
   ,@DatePosted DATETIME OUTPUT
   ,@RetVal INT OUTPUT
)
AS

SELECT @RetVal = 0

IF NOT EXISTS(SELECT * FROM TBLVMPFAnnouncements WHERE AnnouncementID =
@AnnouncementID)
BEGIN
   SELECT @RetVal = 1
   RETURN 0
END

SELECT
   @Headline = Headline
   ,@FullText = FullText
   ,@DatePosted = DatePosted
FROM TBLVMPFAnnouncements
WHERE AnnouncementID = @AnnouncementID

Has anyone seen this problem?

Thanks!

9 Jan 2006 5:02 PM

Roy

Never mind. I resolved the problem by instantiating the QueriesTableAdapter
class.