Sunday, February 19, 2012

Generate .chm files from Stored Procedure Comments

Hi everyone,

I need to create a .chm file from the Comments given in Stored Procedure.My Stored Procedure looks like this :

This is the Header Block of Stored Procedure :

/*
Name :s_Get_Audit
Author :sidheshwar Description : This stored procedure will return rows for Function Report
Notes :
Date : 08 Nov 2006
Input parameterSleep :
@.LocID
@.DeptID
@.DeptMgrID
@.UnitMgrID
@.RACFID
@.From_Date
@.To_Date

VariableSleep : None
Output parameterSleep : None
Usage : EXEC s_Get_Audit
@.LocID = 0,
@.DeptID = 0,
@.DeptMgrID = 0,
@.UnitMgrID = 0,
@.RACFID = 0,
@.From_Date = '12/05/2006',
@.To_Date = '12/06/2008'
DTS
History
MM/DD/YYYY Developer Change/Comment
-
11/08/2006 Sidheshwar N Created
--*/

I need to write C# Application to generate .cmh from the above Stored Procedure

In short i m creating a Database Objects Manual.

Thanks in Advance

Sidheshwar.

In SQL Server we only use CHM files for the F1 topics. Books Online uses a new help product called dexplorer. The HTML Help SDK you're looking for is here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/htmlhelp/html/vsconHH1Start.asp

No comments:

Post a Comment