ASP.NET

27-Sep-06 4:34

Hello everyone:

I am struggling with XML (which I am really not good at), the file that I am working with is something like this:

<MotherCompany Name="MC">
 <Company Name="CompanyOne">
    <Department>
     <IsPositions>
        <Temp>
            <MoreNestedDetails></MoreNestedDetails>
        </Temp>
        <IsPerm>
            <MoreNestedDetails></MoreNestedDetails>
        </IsPerm>
        <Intern>
            <MoreNestedDetails></MoreNestedDetails>
        </Intern>
        <Other>
            <MoreNestedDetails></MoreNestedDetails>
        </Other>
      </IsPositions>
    </Department>
 </CompanyOne>
 <Company Name="CompanyTwo">
    <Department>
     <IsPositions>
        <Temp>
            <MoreNestedDetails></MoreNestedDetails>
        </Temp>
        <IsPerm>
            <MoreNestedDetails></MoreNestedDetails>
        </IsPerm>
        <Intern>
            <MoreNestedDetails></MoreNestedDetails>
        </Intern>
        <Other>
            <MoreNestedDetails></MoreNestedDetails>
        </Other>
      </IsPositions>
    </Department>
 </CompanyTwo>
 <Company Name="CompanyThree">
    <Department>
     <IsPositions>
        <Temp>
            <MoreNestedDetails></MoreNestedDetails>
        </Temp>
        <IsPerm>
            <MoreNestedDetails></MoreNestedDetails>
        </IsPerm>
        <Intern>
            <MoreNestedDetails></MoreNestedDetails>
        </Intern>
        <Other>
            <MoreNestedDetails></MoreNestedDetails>
        </Other>
      </IsPositions>
    </Department>
 </CompanyThree>
 <Company Name="CompanyFour">
    <Department>
     <IsPositions>
        <Temp>
            <MoreNestedDetails></MoreNestedDetails>
        </Temp>
        <IsPerm>
            <MoreNestedDetails></MoreNestedDetails>
        </IsPerm>
        <Intern>
            <MoreNestedDetails></MoreNestedDetails>
        </Intern>
        <Other>
            <MoreNestedDetails></MoreNestedDetails>
        </Other>
      </IsPositions>
    </Department>
 </CompanyFour>
</MotherCompany>

Now what I need to do is read the information for each Company under MotherCompany.

A - Since its so freaking nested I am confused as to how to go about collecting the information. Any ideas and suggestion?

B - I tried to use XMLReader; I was doing something like:

<br />
XmlTextReader reader = new XmlTextReader(FileNameWithPath);  <br />
while (reader.Read())<br />
{<br />
  if (reader.Name == "Company")<br />
  {<br />
    if (reader.NodeType == XmlNodeType.Element)<br />
    {<br />
      XmlReader currentNode = reader.ReadSubtree();<br />
      while (currentNode.Read())<br />
      {<br />
        if (currentNode.NodeType == XmlNodeType.Element)<br />
        {<br />
          switch (currentNode.Name)<br />
           {<br />
          case "Temp<br />
            dataCol.MethodList.Add(currentNode.Name);<br />
            break;<br />
          case "IsPerm<br />
            dataCol.MethodList.Add(currentNode.Name);<br />
            break;<br />
          case "Intern<br />
            dataCol.MethodList.Add(currentNode.Name);<br />
            break;<br />
          case "Other<br />
            dataCol.MethodList.Add(currentNode.Name);<br />
            break;<br />
          default:<br />
            break;<br />
          }<br />
        }<br />
      }<br />
    }<br />
  }<br />
}<br />

First of all my reader.ReadSubtree(); reads all the Company Elements, I thought that it would read any thing within the Company Element so I would be able to get data for seperate Company Elements depending on thier the Name attribute. How can I do that in the given scenario? Is there a better way? Like somehow skip to the elements that I need instead of worrying about the nested loops and crap?

Any help will be great and HIGHLY appreciated. Thanks.

PS: At some point I will need to go and get more details and it looks like I am keep nesting while loops for every detailed value; is there a better way of doing that?

Not Active27-Sep-06 4:43

27-Sep-06 4:43

Use XPathDocument or XmlDocument instead of the XmlTextReader, unless this is a really huge file.

XPathDocument doc = new XPathDocument("MyFile.xml");<br />
XPathNavigator nav = doc.CreateNavigator();<br />
<br />
XPathNodeIterator nodes = nav.Select("//Company");

Now you should have a collection of Company nodes to iterate through

only two letters away from being an asset

robert11027-Sep-06 4:48

27-Sep-06 4:48

Mark:

Thanks a lot for your suggestion. This document is typically more then 500 lines but the Company Nodes are not the one that increase the file size, its other junk thats embeded in it. Do you think it would be ok to use XPathDocument for such size files?

Thanks.

Not Active27-Sep-06 4:56

27-Sep-06 4:56

It should be fine as long as the file size isn't more than say 1mb

only two letters away from being an asset

robert11027-Sep-06 9:36

27-Sep-06 9:36

Well just came to find out that the file I've been working with is not an xml file instead it is an xsd file Confused | :confused:

This will explain why xmlreader was working by xpath logic was not working (yeah it was looping thorugh all the elements Blush | :O

).

Any suggestions?

robert11027-Sep-06 16:06

27-Sep-06 16:06

XPathDocument doc = new XPathDocument(FileNameWithPath);
XPathNavigator nav = doc.CreateNavigator();
XPathNodeIterator nodes = nav.Select("/MotherCompany/Compant/Department/IsPositions");
//string x = nodes.Current.GetAttribute("Name", nodes.Current.NamespaceURI);
XPathNavigator nodesNav = nodes.Current;
XPathNodeIterator ni = nodesNav.SelectDescendants(XPathNodeType.Element, false);
while(nodes.MoveNext())
{
    MessageBox.Show(nodes.Current.Name);
    //nodes.Current.GetAttribute("Name",nodes.Current.NamespaceURI);
        // MessageBox.Show(ni.Current.Name + "\n" + ni.Current.Value);
        richTextBox1.AppendText(Environment.NewLine
            + "Name:" + /*x +*/ Environment.NewLine
            + nodes.Current.Name + Environment.NewLine +
            nodes.Current.Value
            );
}

When I look in the debug mode to see what is going; this is what I get for my ni Position=0, Current={Root}, Count=0
And aparently nothing happends...
Can someone please help me read this document? I sure would appreciate it. Thanks.
Regards,Robert

Not Active28-Sep-06 2:15

28-Sep-06 2:15

XPathNodeIterator nodes = nav.Select("/MotherCompany/Compant/Department/IsPositions");
nodes.MoveNext();
XPathNavigator nodesNav = nodes.Current;

The iterator is not positioned at the start so you must move to an element before accessing anything.

only two letters away from being an asset

robert11028-Sep-06 8:27

28-Sep-06 8:27

Thanks for your help and patience with me Mark. However I still dont get any thing even after putting nodes.MoveNext().

Do you think that <xs:schema>, <xs:annotation>, <xs:appinfo> (which are at the top of the document and <MotherCompany> is nested within <xs:appinfo> ) has anything to do with it?

Appreciate your help.

Regards,
Robert

plz , send me asp.net applicatijon with c#

Jim Conigliaro27-Sep-06 10:04

Jim Conigliaro

27-Sep-06 10:04

The XmlReader probably isn't the way to go here. Load your xml into an XmlDocument and use the SelectNodes method to select the specific nodes you want, for example you could do something like this:

XmlNodeList tempPositions = myXml.SelectNodes("/Company/Department/Temp");<br />
foreach(XmlNode position in tempPositions)<br />
     tempPositions.Add(position.Name);

The best thing you could do is get familiar with XPath queries and use them to extract the specific information you need from your XmlDocument.

Jim Conigliaro
jconigliaro@ieee.org
http://www.jimconigliaro.com

jignesh_ce00727-Sep-06 4:20

jignesh_ce007

27-Sep-06 4:20

plz, i need some application for educational perpose .
plz, help me .

jignesh patel

Re: plz , send me asp.net applicatijon with c#

Not Active27-Sep-06 4:37

Re: plz , send me asp.net applicatijon with c#

27-Sep-06 4:37

static void Main(string[] args)
{
Console.WriteLine("Hello, world");
}

only two letters away from being an asset

_AK_27-Sep-06 18:59

_AK_

27-Sep-06 18:59

Best Regards,
Apurva Kaushal

Running flash file

dptalt27-Sep-06 3:43

dptalt

27-Sep-06 3:43

How can I run a flash file inside an asp .net page?

Re: Running flash file

minhpc_bk27-Sep-06 19:37

minhpc_bk

27-Sep-06 19:37

Clickety[^]

plz send some .net projects using asp.net,c#,sqlserver2000

basha.sk27-Sep-06 3:08

basha.sk

27-Sep-06 3:08

plz send some .net projects using asp.net,c#,sqlserver2000

Re: plz send some .net projects using asp.net,c#,sqlserver2000

Guffa27-Sep-06 3:12

Guffa

27-Sep-06 3:12

Why? Where to?

---
b { font-weight: normal; }

Re: plz send some .net projects using asp.net,c#,sqlserver2000

Sathesh Sakthivel27-Sep-06 3:51

Sathesh Sakthivel

27-Sep-06 3:51

r u an student or an Developer. first of all go through the "Chris" first question.

And then post ur questions.

With Regards

Satips

how to clear the text in alot off texeboxs

ashraf hakiem27-Sep-06 2:47

ashraf hakiem

27-Sep-06 2:47

i have pag to regestration this page contain alot of textbox i want to delet the value in text boxses after end regestration
thank you for help me

ashrafhakiem

Exelioindia27-Sep-06 2:52

Exelioindia

27-Sep-06 2:52

HI,

First say your are cerating an Windows based or Web based form??? and the platform you use

Know is Drop, Unknown is Ocean

ashraf hakiem27-Sep-06 3:02

ashraf hakiem

27-Sep-06 3:02

thanks dear iuse asp.net

albCode27-Sep-06 3:38

albCode

27-Sep-06 3:38

make one for loop which counts all objects in ur page and inside on loop ask if control is textbox if so delete text property of control.