Creating XSD for Sql Parameters

microsoft.public.dotnet.framework.adonet

5 Jan 2006 9:34 PM

Curtis Justus

Hello everybody,

I am working on a class that will return an XSD that will be used to verify
data entered for searching. A "search" stored procedure will be created in
the database, and a method will use DeriveParameters to get the parameters
for that stored procedure. I need to get the parameters into an XSD
document that can be used to build a parameter list in the UI and also used
to validate the data.

I suppose I could do a brute force method of saying an AnsiStringFixedLength
would equate to an appropriate XSD string. I was wondering if anybody had
some ideas, resources I could go to, or a "what in the world are you doing
that for" thought. ;-).

Thanks in advance,
cj