c# - Get another attribute on the same element by searching another attribute -



c# - Get another attribute on the same element by searching another attribute -

this might simplest question appologise. part of xml. want attribute "value" based on attribute "itemoid". ie when itemoid="i_medic_history_indication" value.

<formdata formoid="f_neurological_v20" openclinica:version="v2.0" openclinica:status="initial info entry"> <itemgroupdata itemgroupoid="ig_neuro_ungrouped" itemgrouprepeatkey="1" transactiontype="insert"> <itemdata itemoid="i_neuro_neuro_tendonab" value="" /> <itemdata itemoid="i_neuro_neuro_tendon" value="1" /> <itemdata itemoid="i_neuro_neuro_gaitab" value="" /> <itemdata itemoid="i_neuro_neuro_gait" value="1" /> <itemdata itemoid="i_neuro_neuro_coordinateab" value="" /> <itemdata itemoid="i_neuro_neuro_coordinate" value="1" /> <itemdata itemoid="i_neuro_neuro_sensoryab" value="" /> <itemdata itemoid="i_neuro_neuro_sensory" value="1" /> <itemdata itemoid="i_neuro_neuro_muscletoneab" value="" /> <itemdata itemoid="i_neuro_neuro_muscletone" value="1" /> <itemdata itemoid="i_neuro_neuro_motorab" value="" /> <itemdata itemoid="i_neuro_neuro_motor" value="1" /> <itemdata itemoid="i_neuro_neuro_cranialab" value="" /> <itemdata itemoid="i_neuro_neuro_cranial" value="1" /> <itemdata itemoid="i_neuro_neuro_speechab" value="" /> <itemdata itemoid="i_neuro_neuro_speech" value="1" /> <itemdata itemoid="i_neuro_neuro_behaveab" value="abnormal" /> <itemdata itemoid="i_neuro_neuro_behave" value="0" /> <itemdata itemoid="i_neuro_neuro_appearab" value="" /> <itemdata itemoid="i_neuro_neuro_appear" value="1" /> <itemdata itemoid="i_neuro_neuro_normal" value="1" /> <itemdata itemoid="i_neuro_neuro_date" value="2014-10-10" /> </itemgroupdata> </formdata>

this code. can tell bit stuck.

string neuroexampath = "//oc:formdata[@formoid='f_neurological_v20']/oc:itemgroupdata/oc:itemdata"; var neuroexamlist = doc.xpathselectelements(neuroexampath, nsmgr).reverse(); foreach (var neuroexamelement in neuroexamlist) { var patrow = patdt.newrow(); var i_neuro_neuro_normal = neuroexamelement.attribute("value").value; patrow["neuro_normal"] = i_neuro_neuro_normal; var i_neuro_neuro_appear = neuroexamelement.attribute("value").value; patrow["neuro_appear"] = i_neuro_neuro_appear; var i_neuro_neuro_appearab = neuroexamelement.attribute("value").value; patrow["neuro_appearab"] = i_neuro_neuro_appearab; patdt.rows.add(patrow); }

as can tell iterate attribute value time. need var i_neuro_neuro_normal = neuroexamelement.attribute("value").value; line have status itemoid="i_neuro_neuro_normal" , on. can set 1 attribute @ time datatable. please help. give thanks you.

it looks me want new row each itemgroupdata element, not each itemdata element. expect like:

foreach (var itemgroup in doc.root.elements("itemgroupdata")) { var row = patdt.newrow(); row["neuro_normal"] = itemgroup.extractvalue("i_neuro_neuro_normal"); row["neuro_appear"] = itemgroup.extractvalue("i_neuro_neuro_appear"); row["neuro_appearab"] = itemgroup.extractvalue("i_neuro_neuro_appearab"); patdt.rows.add(row); }

which uses new extension method:

public static string extractvalue(this xelement parent, string oid) { homecoming parent.elements("itemdata") .where(x => x.attribute("itemoid").value == oid) .first() .attribute("value") .value; }

alternatively, if you're extracting lot of attributes, build dictionary:

var values = itemgroup.elements("itemdata") .todictionary(x => x.attribute("itemoid").value, x => x.attribute("value").value);

c# linq xpath xelement xattribute

Comments

Post a Comment

Popular posts from this blog

Delphi change the assembly code of a running process -

Delphi change the assembly code of a running process - i'm trying alter address 00741fa5 has push test.009e721c . alter push test.009e71c8 . procedure callback; asm force $9e71c8 end; procedure tform2.btn1click(sender: tobject); var ppid :dword; pprocess : cardinal; begin getwindowthreadprocessid(findwindow(nil,pchar('test')), @ppid); pprocess := openprocess(process_all_access, false, ppid); injectasm(pprocess, $741fa5, 10, integer(@callback), 0); end; here injectasm function (with error checking) function injectasm(process: longword; injectaddress, injectsize, codeaddress, codesize : integer): pointer; var csize, rsize : integer; replaced : array of byte; jmp : array [0..4] of byte; jmpaddress : integer; nopv : byte; : integer; nbr: ulong_ptr; begin //injectsize must equal or greater 5, because need space our //(far) jmp wwxxyyzz instruction //if there's no space, inject in place of few instructions if injectsize ...
Read more

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) -

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) - hello have problem hibernate , jackson. have 2 pojos @entity @table(name = "users") public class user implements serializable { static final long serialversionuid = 4235637833262722256l; @id @generatedvalue private int id; @column(name = "creation_date") private date creationdate; @column(name = "first_name") private string firstname; @column(name = "last_name") private string lastname; @version @column(name = "version") private int version; @column(name = "e_mail") private string email; @column(name = "enabled") private boolean enabled; @column(name = "login") private string login; @column(name = "password") private string password; @jsonmanagedreference("role") @onetomany(mappedby = "user", cascade = cascadetype.all,fetch = fetchtyp...
Read more

C++ 11 "class" keyword -

C++ 11 "class" keyword - i've started using c++ 11 little bit more , have few questions on special uses of class keyword. know it's used declare class, there's 2 instances have seen don't understand: method<class t>(); and class class_name *var; why precede typename keyword class in first example, , keyword pointer in sec example? that known elaborated type specifier , necessary when class name "shadowed" or "hidden" , need explicit. class t { }; // love of god don't t t; t t2; if compiler smart, give these warnings: main.cpp:15:5: error: must utilize 'class' tag refer type 't' in scope t t2; ^ class main.cpp:14:7: note: class 't' hidden non-type declaration of 't' here t t; ^ if class not defined, deed forwards declaration. for example: template <typename t> void method() { using type = typename t::value_type; } method...
Read more