Contact US

Question

linq drill down statement

deejayAr (TechnicalUser)

(OP)

2 Dec 13 14:42

How can I write this to linq

first I'm doing
XElement root = doc.MainDocumentPart.GetXDocument().Root;
then
var query = from c in root.Descendants(W.p) select c;
then
foreach (XElement p in query)
{
XElement pElement = p.Descendants(w + "pStyle").FirstOrDefault() ;
if (pElement != null)
{
string spElement = pElement.Attributes(w + "val").FirstOrDefault().Value as string;
if (strStylesAll.Contains(spElement))
{
if (strStyles.Contains(spElement))
{
strReferenceNumber = strReferenceNumber + 1;
}
else
{ strReferenceNumber = strReferenceNumber; }

strStylesname.Add(spElement + "p" + " " + strReferenceNumber);
// addtoTable(spElement, strReferenceNumber)

}
}}

I know it looks ugly and not
any help would be nice

MakeItSo (Programmer) · Answer 1 · 2013-12-03 04:12:26

Please be a little clearer.
You say "How can I write this to linq " - but you are already using linq in this code!
Please tell what exactly your code is doing and what it isn't doing and what it is supposed to do.

Cheers,
MakeItSo

“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.

Moregelen (Programmer) · Answer 2 · 2013-12-03 09:49:53

Also, post all of the code, and put it in code tags. It is a whole hell of a lot harder to figure out what you are doing or want to do when the code is missing information and hard to read.

Moregelen (Programmer) · Answer 3 · 2013-12-03 10:06:52

The code is very hard to read and you have missing pieces I had to guess at, but when I indent your code properly it looks like this:

CODE

XElement root = doc.MainDocumentPart.GetXDocument().Root;

var query = from c in root.Descendants(W.p) select c;

foreach (XElement p in query)
{
	XElement pElement = p.Descendants(w + "pStyle").FirstOrDefault() ;
	if (pElement != null)
	{
		string spElement = pElement.Attributes(w + "val").FirstOrDefault().Value as string;
		if (strStylesAll.Contains(spElement))
		{
			if (strStyles.Contains(spElement))
			{
				strReferenceNumber = strReferenceNumber + 1;
			}
			else
			{
				strReferenceNumber = strReferenceNumber;
			}

			strStylesname.Add(spElement + "p" + " " + strReferenceNumber);
			// addtoTable(spElement, strReferenceNumber)

		}
	}
}

Its really hard to be sure given there are missing pieces about what you are doing, but this 'should' do the same thing.. I think...

CODE --> C#

var query = from c in doc.Root.Descendants(W.p)
            where c.Descendants(w + "pStyle").FirstOrDefault() != null
            select c.Descendants(w + "pStyle").FirstOrDefault().Attribute(w + "val");
 
foreach (XAttribute attr in query)
    if (strStylesAll.Contains(attr.Value))
    {
        if (strStyles.Contains(attr.Value))
            strReferenceNumber++;
        strStylesname.Add(attr.Value + "p " + strReferenceNumber);
    }

Come Join Us!

Posting Guidelines

linq drill down statement

linq drill down statement

linq drill down statement

RE: linq drill down statement

RE: linq drill down statement

RE: linq drill down statement

CODE

CODE --> C#

Red Flag This Post

Red Flag Submitted

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Join Tek-Tips^® Today!

Contact US

Come Join Us!

Posting Guidelines

linq drill down statement

linq drill down statement

linq drill down statement

RE: linq drill down statement

RE: linq drill down statement

RE: linq drill down statement

CODE

CODE --> C#

Red Flag This Post

Red Flag Submitted

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Join Tek-Tips® Today!

Join Tek-Tips^® Today!