generate xslt from .net code

[smidee]

Hi guys,

I am a new member here and also new to dot net. I am trying to generate XSLT from dot net (C#) code by taking mapping rules from the database.

For example, let's say I have 2 columns in my table representing the 2 XML files, one has the input XML fields and the other has output XML fields.
Like FirstName should be mapped to Fname and LastName should be mapped to lname. So the column 1 has FirstName, LastName and column 2 has Fname and lname.

I need to write a dot net code which may be on the click of a button generates the XSLT to do the above mapping by taking the rules from the database. Any thoughts on how this can be done?

I am taking a look at the XMLTransform methods, in dot net etc. Without hard coding information, how can this be done?

I am relatively new to dot net and XML , just learning, any inputs would be greatly appreciated, at least a starting idea.
I also posted this is dot net forum. Hope there is a savior!!!!
Thanks,

Smidee

[dorinbogdan]

Welcome to TheScripts TSDN....

You can build XSL code through C# or edit as a text file manually.
But the XSL code depends on your project requirements.
Please take a look at this short tutorial.

God bless you,
Dorin.

[smidee]

Thanks for the prompt reply, but I still did not get an idea how to do it. Let me rephrase my question, Instead of constantly changing the XSLT code manually, each time a new mapping rule comes, I want to programatically be able to generate XSLT based on mapping rules existing in the database as mentioned before.

Like the mapping rules should be taken from the DB and in a C# form , if I click submit button, it should generate the XSLT code for me in a text file or any file.

Just some initial thoughts, or an idea about how to go about this would be great!!

Thanks again,
sd

Welcome to TheScripts TSDN....

You can build XSL code through C# or edit as a text file manually.
But the XSL code depends on your project requirements.
Please take a look at this short tutorial.

God bless you,
Dorin.

[dorinbogdan]

There is no standard for it, it's your choice about how to implement the functionality.
I would use a XSL dynamic string built through code, instead of an XSL file.

See also this link and this one.

[smidee]

There is no standard for it, it's your choice about how to implement the functionality.
I would use a XSL dynamic string built through code, instead of an XSL file.

See also this link and this one.

Sorry about the constant questions.
According to what you said, building a dynamic string means writing the whole XSL code as a string and using it. But I do not want to hard code the XSLT, but want to generate it programatically by code using the mapping rules from DB at the click of a button and write it to a text file or XSL file.

Do you know of any dot net API which does this? Please provide some psedo code as a reference if possible.

Thanks a ton,
smidee

[dorinbogdan]

Yes, you should write it programatically by code, not hard-code it, so that it will be based at runtime on current rules. I know no API or class that can write XSL code for you. For this, you just must know the rules.
Other solution would be to write one XSL for each rule, if the rules can be predicted / known at design-time.

[smidee]

ok, could you please provide even a 3, 4 lines sample code, even pseudocode, I am not familiar with the dot net capabilities. S

So should I be using the XML APIs in dot net for constructing an XSLT (as XSLT "is" an XML). If you get a chance, a very small sample code or pseudocode would be really useful to understand your point right away. Thanks so much for the help so far!!

Thanks.

[dorinbogdan]

I don't have .Net samples, but I think that you could find with google.
Also, Koders is a good source of samples.

peace on you,
Dorin.