Re: reading XML - C# Discussion Boards

13-Nov-08 8:01

i am trying to read from an xml document but am not having any luck getting selectsinglenode to work

here is the code i am using

XmlDocument xml = new XmlDocument();
xml.Load(str); //str has the path to my XML doc
XmlNode xmln = xml.SelectSingleNode("/GPO/Identifier/Identifier");
//xmln is always null but xml has my xmldoc loaded in memory
string Identifier = xmln.InnerText.ToString(); //code bombs here cuz xmln is null...

here is the first few lines of the xml

<?xml version="1.0" encoding="utf-16" ?>
- <GPO xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.microsoft.com/GroupPolicy/Settings">
- <Identifier>
<Identifier xmlns="http://www.microsoft.com/GroupPolicy/Types">{89AEAFFE-E1F8-4786-8AF7-6BE2D991625E}</Identifier>

i have 20 XSD schema files that are related to the xml docs i am trying to parse but i'm new to xml and not clear on how to use the xsd's

help in either direction would be great!

Ennis Ray Lynch, Jr.13-Nov-08 8:08

13-Nov-08 8:08

Didn't you post this same question two days ago?

Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.

Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway

Most of this sig is for Google, not ego.

Planker13-Nov-08 8:26

13-Nov-08 8:26

no my last question was using xpath, and not making any progress....
I guess I will stop posting on code project...

I'm not asking someone to write this for me, I just have something new and is not working was trying to get someone to help point out what i am doing wrong so i can move forward. sorry for reposting a different but similar question.

Ennis Ray Lynch, Jr.13-Nov-08 8:36

13-Nov-08 8:36

No, it is just working with those tools is just an absolute PITA and to help most of us would have to paste it into a project and fiddle unless the error just jumps out at us. I usually just use xsd.exe to create a class from the XML file and then serialize into the class rather than xpath since it is lazier and easier in .NET.

Planker13-Nov-08 8:46

13-Nov-08 8:46

i've never used xsd.exe before this project but when i tried to create my own xsd files from the xml it complained about to many nested tables. when i found the MS xsd files i tried to create classes but it is saying something about undefined complexType.

if there is a way I can use the MS xsd files then great if not i need to figure out how to parse this xml file the hard way and i know it is going to be a PITA.

Wendelius13-Nov-08 8:40

Wendelius

13-Nov-08 8:40

Hi again,

The xml was missing some end tags so I added them to test this case. When I added a name alias on xmlns attributes it began to work. Here's the code I used. Note the aliases!

string testText = "<?xml version=\"1.0\" encoding=\"utf-16\" ?> <GPO xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:<big>Alias1</big>=\"http://www.microsoft.com/GroupPolicy/Settings\"> <Identifier> <Identifier xmlns:<big>Alias2</big>=\"http://www.microsoft.com/GroupPolicy/Types\">{89AEAFFE-E1F8-4786-8AF7-6BE2D991625E}</Identifier></Identifier></GPO>";<br />
<br />
System.Xml.XmlDocument xml = new System.Xml.XmlDocument();<br />
xml.LoadXml(testText);          <br />
System.Xml.XmlNode xmln = xml.SelectSingleNode("/GPO/Identifier/Identifier");<br />
string Identifier = xmln.InnerText.ToString();

Hope this helps you forward,

Mika

The need to optimize rises from a bad design.

My articles[^]

Planker13-Nov-08 9:12

13-Nov-08 9:12

thanks for the tip but the xml code i don't want to change it is an export that i want to import to a database

Wendelius13-Nov-08 9:21

Wendelius

13-Nov-08 9:21

Ok, then I think you should use namespace managers. Look at the second override of this method:

public XmlNode SelectSingleNode(
	string xpath,
	XmlNamespaceManager nsmgr
)

http://msdn.microsoft.com/en-us/library/h0hw012b.aspx[^]

The need to optimize rises from a bad design.

My articles[^]

netJP12L13-Nov-08 8:48

netJP12L

13-Nov-08 8:48

XmlNode root = xmlDocument.DocumentElement;
for (int i = 0; i < root.ChildNodes.Count; i++)
{
XmlNode node = root.ChildNodes[i];
if (node.Name == "NAME")
{
}
}

Re: reading XML [modified]

sph3rex13-Nov-08 8:50

sph3rex

13-Nov-08 8:50

add http://www.microsoft.com/GroupPolicy/Settings to a new xml namespace manager and use it with your node select. Something like:

XmlNamespaceManager NSM = new XmlNamespaceManager(YOURXMLDOCOBJINSTANCE.NameTable);
NSM.AddNamespace("some_random_name_like_abcd", "http://www.microsoft.com/GroupPolicy/Settings");
XmlNode whateverNode = YOURXMLDOCOBJINSTANCE.SelectSingleNode("//some_random_name_like_abcd:WhateverElement", NSM);

XPath will generally not work without specifying the namespace, when a namespace is defined.

Planker13-Nov-08 9:33

13-Nov-08 9:33

thanks, i just tried this and making some progress now

here is what i have to get the text of the whole node and the first child

XmlDocument xml = new XmlDocument();
xml.Load(str);
XmlNamespaceManager NSM = new XmlNamespaceManager(xml.NameTable);
NSM.AddNamespace("abcd", "http://www.microsoft.com/GroupPolicy/Settings");
XmlNode xmln = xml.SelectSingleNode("//abcd:Identifier", NSM);
if (xmln.HasChildNodes == true)
{
if (xmln.FirstChild.Name == "Identifier")
{
this.textBox2.Text = xmln.FirstChild.InnerText.ToString();
}
}
this.textBox1.Text = xmln.InnerText.ToString();

is there a better way to do this or should i get coding?

and thanks to everyone!!!

modified on Thursday, November 13, 2008 4:15 PM

sph3rex13-Nov-08 10:45

sph3rex

13-Nov-08 10:45

rather use /abcd:Identifier/abcd:Identifier to get only the child nodes labeled "Identifier" of the root "Identifier" node. Use the full power of XPath if you went that way ... w3 has a great tutorial on how to use them "productive" ... http://www.w3schools.com/XPath/xpath_syntax.asp[^]

Code? Yeah i love it fried together with a glass of wine.

Planker14-Nov-08 6:43

14-Nov-08 6:43

thanks for the link it has been helpful, I have another question

here is the xml i am trying to query

<GPO xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.microsoft.com/GroupPolicy/Settings">
...
<User>
<ExtensionData>
<Extension xmlns:q1="http://www.microsoft.com/GroupPolicy/Settings/FolderRedirection" xsi:type="q1:FolderRedirectionSettings">
.....settings I need to read are child nodes here.....
</Extension>
<Name>Folder Redirection</Name>
</ExtensionData>
<ExtensionData>
<Extension xmlns:q2="http://www.microsoft.com/GroupPolicy/Settings/Registry" xsi:type="q2:RegistrySettings">
.....settings I need to read are child nodes here.....
</Extension>
<Name>Registry</Name>
</ExtensionData>
</User>
</GPO>

Is there a way i can query the xsi:type value?

if not I can query the name but not sure what the best way to jump up to the settings to read them.

this xml file does not always have the same <ExtensionData> entries so i am checking for all possible cases

Planker14-Nov-08 10:12

Re: help with data reader

14-Nov-08 10:12

i figured out how to do this below is the code i used, could be cleaner if this was the only thing i was checking in the User node

XmlDocument xml = new XmlDocument();
xml.Load(str);
XmlNamespaceManager NSM = new XmlNamespaceManager(xml.NameTable);
NSM.AddNamespace("abcd", "http://www.microsoft.com/GroupPolicy/Settings");
XmlNode xmln6 = xml.SelectSingleNode("//abcd:User", NSM);

for (int i = 0; i < xmln6.ChildNodes.Count; i++)
{
XmlNode Childnode = xmln6.ChildNodes[i];
if (Childnode.Name == "ExtensionData")
{
string ExtDataTest = Childnode.ChildNodes[0].Attributes[1].Value.ToString();
string test = ExtDataTest.Substring(3, ExtDataTest.Length - 3)
}
}

help with data reader

Melanie Booysen13-Nov-08 7:47

Melanie Booysen

13-Nov-08 7:47

i have the following code that is suppose to fill a datagrid. the code works fine when queried in the database but when used in the application no results are return. please help!!!!
this is the code i used....

private void cmdCompare_Click(object sender, EventArgs e)
{

string sqlquery;

sqlquery = "select * from " + Table1 + " where not exists ( select * from " + Table2 + " where " + txt_comkey_tbl1.Text + " = " + txt_comkey_tbl2.Text + ")";

OpenDb();

dbCmd = new OleDbCommand();
dbCmd.Connection = dbConn;
dbCmd.CommandText = sqlquery;
dbCmd.CommandType = CommandType.Text;
dbReader = dbCmd.ExecuteReader();
int intSkip = 0, i = 0;

ds = new DataSet();
dbtable = ds.Tables.Add(sqlquery);

for (i = 0; i < dbReader.FieldCount; i++)
dbtable.Columns.Add(dbReader.GetName(i), dbReader.GetFieldType(i));

int intIdx = 0;

while (dbReader.Read())
{
if (intIdx >= intSkip)
{
DataRow r = dbtable.NewRow();

// Assign DataReader values to DataRow.
for (i = 0; i < dbReader.FieldCount; i++)
r[i] = dbReader[i];

dbtable.Rows.Add(r);
}

intIdx++;
}

dgTblDiff.DataSource = ds.Tables[sqlquery].DefaultView;

dbReader.Close();

}

Ennis Ray Lynch, Jr.13-Nov-08 8:07

Re: help with data reader

13-Nov-08 8:07

Use the data adapter to fill a dataset and not a datareader.

Giorgi Dalakishvili13-Nov-08 8:17

Giorgi Dalakishvili

13-Nov-08 8:17

1. Use parametrized queries instead of string concatenation. Parametrized Queries VS String Concatenation[^]
2. If you are filling DataTable why aren't you using DataAdapter instead of manually looping through datareader?

3. Ensure that the connection is initialized and don't leave it open when you no longer need it.

Giorgi Dalakishvili

#region signature
My Articles

Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^]

My blog
#endregion

Re: help with data reader

PIEBALDconsult13-Nov-08 12:59

PIEBALDconsult

13-Nov-08 12:59

Nothing jumps out at me; I just wouldn't bother with the DataSet.

Have you stepped through it in the debugger?

And what's the purpose of the intSkip?

Get Website information from IIS

Pr@teek B@h!13-Nov-08 7:44

Pr@teek B@h!

13-Nov-08 7:44

Hi,
First of all, is there a way to get list of all Web Sites from IIS?
Secondly, how can I get information such as Port, IP Address, etc., about the Web Sites?
Last, can all of this be done in c#?

Any help on this would be appreciated.

Thanks,

Prateek

Re: Get Website information from IIS

Pr@teek B@h!13-Nov-08 9:45

Pr@teek B@h!

13-Nov-08 9:45

Never Mind.
I was able to find out how to do it.

DirectoryEntry iis = new DirectoryEntry("IIS://" + Environment.MachineName + "/w3svc");

foreach (DirectoryEntry site in iis.Children)
{
	if (site.SchemaClassName == "IIsWebServer") //Web Sites have the IIsWebServer schema{
	{
		String siteName = site.Name;
		foreach (String propertyName in site.Properties.PropertyNames)
		{
			PropertyValueCollection values = site.Properties[propertyName];
			foreach (object val in values)
			{
				Console.WriteLine(propertyName + ": " + val);
			}
		}
	}
}

This will get the list of web sites on IIS and their properties. I don't know if this will work for IIS 7 right now.

Searching the inbetweens?

jas0n2313-Nov-08 6:52

jas0n23

13-Nov-08 6:52

Hi all!,

I have a weird question and some code that isn't quite right. Frown | :(

I am creating a personal project where I have an already-existing text file which consists of mainly symbols and standard text as follows:

Sample Text File contents:

<jason="human, being, boy, male, animal" />
<human="instinctive, funny, destructive" />
http://www.my_soon-to-be_homepage.com.au/
<qualities="smart, intelligent, funny" />

This file may contain X number of lines, and what I am trying to do is search for the in-betweens, what I mean by that is I want to be able to search for the keywords (human, being, person, hairy, funny, intelligent etc..) that are inbetween the symbols and then put those found keywords into a string so that i can cut, copy, paste, change them at my own will. Then I need to be able to search for a URL that is within that same text file. And then put that URL into a string so I can cut, copy, paste etc..... into a textBox.

I have some code here that searches but it doesn't work the way i want it to. I'd appreciate any samps, tutorials, advice/ or ANY help i can get from anybody. Thanks for taking the time to read this. I hope it wasn't too confusing.. Big Grin | :-D

best regards,
j.t.

j.t.

Re: Searching the inbetweens?

Ennis Ray Lynch, Jr.13-Nov-08 7:29