Comments by maheshk_blr (Top 22 by date)

No, I am reading the date from database, which comes in (dd-mm-yyyy) format, I need to convert that to (MM/dd/yyyy) format, I am reading the data from database using Oracle data reader and date is stored as a string in db.

This works but problem is it does not change the date separator, my incoming date contains - as date separator(dd-mm-yyyy), I need / as date separator(MM/dd/yyyy).
Can u please help in this?

I am using oracle and reading data using oracle data reader, in DB, date field is varchar2

I am using OracleDataReader and not sure whether I can get string from that.

Thanks for the explanation, I was getting below error when I was trying with append child method, "The node to be removed is not a child of this node".
I will try with your suggestion again.

Thanks, It solved my problem

Thanks for your answer.
Is it possible to do this using XMLDocument? because I am doing some other operations with this xml using xmldocument and would like to have my xml in a single object (if possible)

I can do that, but If tomorrow any xml tag name changes then I need to modify the c# code.
If I do with XSLT, I can just change the tag name in XSLT and dont need to change the C# code.
That is the reason, I want to use the XSLT.

Thanks, nice approach

Thanks,

Below is my scenario, in which I needed the above. If you can suggest me some better way, please

I am getting an XML file form a source (assume it is a folder), which I need to validate against an XSD file, I am using below code to do that.

List<string> arrerrors = new List<string>();
XDocument doc = XDocument.Load("My XML Path");
XmlSchemaSet schemas = new XmlSchemaSet();
schemas.Add(null, "My XSD Path");
bool errors = false;

doc.Validate(schemas, (o, e) => {
arrerrors.Add(e.Message);
errors = true;
});

Please note that my XSD has a namespace, which XML does not have and I am trying to manually add it (for that I have asked the above question). If I dont add the namespace to XML, XDocument.Validate() fails to validate the xml. after manually adding the namespace to XML I am getting the xml validated against the XSD.

Since I am very new to XML and XSD, I am not very sure whether my approach is good or not.

Can u please suggest?

Thank you very much for your time and help.

Thanks, this helped me to resolve my problem, below is the code I have written.

XDocument doc = XDocument.Load(My XML File Path);

XElement rootElement = doc.Element(doc.Root.Name);
XAttribute att = new XAttribute("xmlns", "Namespace name");
XAttribute att1 = new XAttribute("xmlns", "");
rootElement.Add(att);

XElement[] allElements = doc.Elements().ToArray();

foreach (XElement ele in allElements.Nodes()) {
ele.Add(att1);
}

StringWriter sw = new StringWriter();
XmlTextWriter xtw = new XmlTextWriter(sw);
doc.WriteTo(xtw);
MessageBox.Show(sw.ToString());

I would like to remove foreach from the above code segment, yet achieve the same results, is that possible?

Thanks, I tried your solution, but getting below error.

"The 'http://www.w3.org/2001/XMLSchema:all' element is not supported in this context"

The errors variable just tells whether the xml got validated against the xsd or not.
The value of errors variable changes to true in this case, but I want the full error message.

Thanks for a very nice answer

Thanks

I only know, How to send automatic emails using 'MailMessage' object, I have no idea of working with .eml templates.

Thank you very much for a very nice explanatory answer.