XML / XSL

Try the XML tutorial at www.w3schools.com

Vishnu Narayan Mishra wrote: newRootParent.InsertAfter(newRootParent, newScreenToSupport); As the error message explains, you are adding a node as a child of itself here. Read the MSDN documentation[^] on this method if you are unsure how to use it. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

As I said, your problem is with DataGrids. This is the XML/XSL forum. In your case, your XML document is just a data source and you want to display it in a certain way. I guess you want a Master-Detail type report. So, look on Code Project and Google for your example code. I gave you keys to help your search. Also, if using a DataGrid is to complicated for you. You know you can create your own table and post it to the ASP.NET page. "We make a living by what we get, we make a life by what we give." --Winston Churchill

you have to take care that the files saved on disk are saved in utf-8 format and not in ansi (most text editors will allow you to change) Erik

Please don't double post. Choose the most appropriate forum for your question and ask there only. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

Have you looked at the Office Interop library? "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

I found the answer to my problem. If I perform the transform using the .NET framework classes instead of the SQLXML managed classes, I can use the XmlTextWriter to control the indentation. public static string ExecuteQueryAndTransform(string connectionString, string queryText, string xslPath) { string result = String.Empty; SqlXmlCommand cmd = new SqlXmlCommand(connectionString); if (!queryText.EndsWith("For XML Auto", StringComparison.CurrentCultureIgnoreCase)) { queryText += " For XML Auto"; } cmd.RootTag = "Root"; cmd.CommandText = queryText; using (Stream strm = cmd.ExecuteStream()) { XmlTextReader reader = new XmlTextReader(strm); XPathDocument xd = new XPathDocument(reader, XmlSpace.Preserve); XslCompiledTransform xslt = new XslCompiledTransform(); xslt.Load(xslPath); StringWriter stringWriter = new StringWriter(); XmlTextWriter writer = new XmlTextWriter(stringWriter); writer.Formatting = Formatting.Indented; writer.Indentation = 3; writer.IndentChar = ' '; xslt.Transform(xd, null, writer); result = stringWriter.ToString(); } } Thanks for your help anyway. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

Thank you for your reply, but I think that if I do as you mentioned it won't work the way I need to be done. The scenario is as follows. The problem is that I wrote an example for the entitites that I look for but it actually dissapeared from the post message (probably because the reference is invisible). So I have an XML doc and I search for tags in it, but some of these tags contain character entities like & #160; (actually this is single word but I separated with a space just to be visible), and I don't want process such tags that contain this kind of information, I want to skip them. The problem is that when I select the specific nodes and I look for text entries inside them I can't recognize if an entry is a character entity just because it is substituted by the actual value of it (in the previous example I think that entity represents an empty line or whatever). I think now it is clear what I want to achive. Thanks in advance!

Thanks a lot Geroge...i was looking for the same kind of solution.. thanks again Sushant Mathur Bangalore, INDIA. http://n.domaindlx.com/fun2ssh/HOME.htm

Your context node is attribute; thus, you're printing its name. You want to print out the children elements name. It you just want to print out the first child's name: Given this XML document: TestColumID Assignment Delta System.Double OutputColumn Single Adherence Delta ReportDatabaseColumnAttribute here is an example of what you are trying to do except it prints out all children names: "We make a living by what we get, we make a life by what we give." --Winston Churchill

I suggest starting by studying MSXML. In the MSDN library (msdn.microsoft.com), it's under "Win32 and COM Developement/Data Access and Storage/MSXML" This documents some software that you can download for free from MSDN downloads. Nathan

See my mod to the message. Thanks anyway.

Please don't post product advertisements like this in the forums, even for free products. If you want to advertise your product, do it the right way and purchase advertising space on the site. Scott. —In just two days, tomorrow will be yesterday. [Forum Guidelines] [Articles] [Blog]

Thanks - I sort of figured out that I must be doing it wrong as there did not seem to be a way to achieve it. So I wasn't missing something after all. 'Howard

I will assume that your $251.96 is paying both interest on the balance and part of the loan is repaid each month. So each each payment = interest + repayment I used to Excel and "Goal-Seek" to work out the nominal (annual) rate of interest, it is 234.214%. Therefore each bi-weekly payment (assuming 52 weeks in a year) is 1/26 x 234.214% which is 9.008% This is the interest part: so in first week interest is balance x 9.008% which is $225.206 Subtract this from $251.96 and you have the net repayment that month, $26.76. For bi-week 2, interest on the balance is now $2473.24 x 9.008% .. etc As to formulas I don't know if there is one, it's so long since I did all this stuff.. As you can see the interest is calculated monthly based on the remaining balance, and totals $4050.96 'Howard

ok so the : was wrong !! Thanks George.:rose: Rocky You can't climb up a ladder with your hands in your pockets.