Hi all,
I'm developing an open source public domain product called Stored Procedures
Class Generator I plan to publish at Code Project. This product generates
one class per stored procedure in a SQL Server 2000/2005 database. It
includes an item template, a standard file based editor, and a custom tool.
The editor loads stored procedure metadata from the specified database,
allows the developer to modify and specify some data, and saves it in a xml
file with .sps extension (this file is part of the project), then the custom
tool generates the code in vb or cs.
All seem to work properly, but there are some minor details I would like to
fix:
(1) I'd like Solution Explorer shows a custom icon for .sps files, but I'm
not be able to specifiy this icon. I don't know how to do it.
Best regards:
Jesús López
VB MVP
Jesús López - 19 Feb 2006 16:29 GMT
Visual Studio uses the same icon as Windows Explorer, so you can get it by
writting in the registry something similar to:
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\StoredProceduresFile]
@="Stored Procedures"
"FriendlyTypeName"="Stored Procedures File"
[HKEY_CLASSES_ROOT\StoredProceduresFile\DefaultIcon]
@="\"PathToTheIconFile\""
[HKEY_CLASSES_ROOT\StoredProceduresFile\shell]
[HKEY_CLASSES_ROOT\StoredProceduresFile\shell\open]
[HKEY_CLASSES_ROOT\StoredProceduresFile\shell\open\command]
@="\"Path to executable file" \"%1\""
[HKEY_CLASSES_ROOT\.sps]
@="StoredProceduresFile"
Regards:
Jesús López
VB MVP