DataSet Designer not generating classes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Back
Top