[m.timoney]

I have an interesting problem,

a old .Net 1.1 application that takes an XML string then reads it into a database via a stored proc.

i need to update it to .net 3.5, unfortunately there is a feature in .net 1.1 that the app uses that have since been drops

the ability to create a typeless parameter in code.
in 1.1 you could declare a parameter with out setting the type, now it needs to have a type.

so i need to ask the SP for the types of the parameters it takes

and before anyone asks i have to do it dynamically as the data contained in the xml string varies on the schema that encoded it, so depending on which schema encoded the data a different SP needs to be called. the link between Schema and SP is in the DB as are the names of the parameters but not the types.

so is there a ways of creating an SQL command of type stored proc and then getting it to populate its parameters from the DB with out me manually getting them. this would then allow me to scroll through the parameters that already have been set up and just assign them values

[m.timoney]

I tried the prepare command and that doesn't seem to do anything

[m.timoney]

AH HA, SqlCommandBuilder.DeriveParameters()