vb.net - Retrieve value in XML in vb -

-

i looking more efficient way retrive “f” @agesex in following xml using vb.

the following shortened version of our xml structure:

    <gridrow xmlversion="1.0" columnnames="description|notes|detail question|detail question id">         <row>   > ...          </row>   > ...          <row>             <nodelevel>0</nodelevel>             <rowdata>cancer|@agesex=f;;|cancer - female|2320</rowdata>             <rowstyle>|||</rowstyle>         </row>     </gridrow>

here have point.

xmldoc.loadxml(topproblemlisttemplate.templatexml)             nodelist = xmldoc.selectnodes("/gridrow")              each row xmlnode in nodelist                 each item xmlnode in row.childnodes                     if item.innertext.contains("@agesex")                         dim index integer = item.innertext.indexof("@agesex=") + len("@agesex=")                          if index > 0                             dim value string = item.innertext.substring(index, 1)                         end if                     end if                 next             next

using the: xmldocument class (msdn)

imports system.xml imports system.text.regularexpressions  dim d new xmldocument d.load("file.xml") ' ... in specific case (or /gridrow/row/rowdata if want specific) ' ... select rowdata nodes in document @ least 1 level deep. dim _rownodes xmlnodelist = d.selectnodes(".//rowdata") each _rownode xmlnode in _rownodes     if new regex("@agesex=.", regexoptions.none).match(s).tostring.endswith("f")         ' ... dosomething     end if next ' ... example dim _rownodes xmlnodelist = d.selectnodes("//gridrow") each _rownode xmlnode in _rownodes     ' ... iterating on each gridrow     each _childnode xmlnode in _rownode         ' ... iterating on each row         each _itemnode xmlnode in _childnode             ' ... iterating on each item in row             dim string = _itemnode.innertext.trim         next         ' ... or can node directly         dim b string = _childnode.selectsinglenode("rowdata").innertext.trim         ' ... specify properties (assuming fictional gender):         dim g string = "female"         dim c xmlnodelist = _childnode.selectnodes("rowdata[@gender='" & g & "']")         ' ... per documentation, can match on value (the data contained in .innertext property)         dim e string = "myvalue"         dim f xmlnodelist = _childnode.selectnodes("rowdata[.='" & e & "']")     next next

examples: how to: use system.xml.xmldocument class run xpath queries in visual basic .net

as document states, lang/notation used queries is: xpath examples (msdn) supports more selective queries, if know data you're looking for.

also, xml properties defined such as:

<myitem name="myname" gender="female">value</myitem>

if gender property, easier, shown in example above, ie:

dim g = "f" : d.selectnodes(".//rowdata[@gender='" & g & "']") ;p


Comments

Post a Comment

Popular posts from this blog

c++ - OpenCV Error: Assertion failed <scn == 3 ::scn == 4> in unknown function, -

-
i read alot other solution still confused should mine... #include <opencv2/objdetect/objdetect.hpp> #include <opencv2/highgui/highgui.hpp> #include <opencv2/imgproc/imgproc.hpp> #include <iostream> #include <stdio.h> using namespace std; using namespace cv; int main(int argc, const char** argv) { //create cascade classifier object used face detection cascadeclassifier face_cascade; //use haarcascade_frontalface_alt.xml library face_cascade.load("haarcascade_frontalface_alt.xml"); //setup video capture device , link first capture device videocapture capturedevice; capturedevice.open(0); //setup image files used in capture process mat captureframe; mat grayscaleframe; //create window present results namedwindow("outputcapture", 1); //create loop capture , find faces while (true) { //capture new image frame capturedevice >> captureframe; ...
Read more

php - render data via PDO::FETCH_FUNC vs loop -

-
i've been using 2 methods render data. the first one: function name($id,$name){ return '<div id="'.$id.'">'.$name.'</div>'; } echo implode($pdo->query("select id,name user")->fetchall(pdo::fetch_func,'name')); the second one: $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); foreach($users $user){ echo name($user->id,$user->name); } i don't understand how pdo::fetch_func works. tried figure out. however, not well-documented. could please explain fetch mode? , also, 1 performs better? thank you. both methods wrong , have learn how use templates , how separate business logic presentation logic. $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); tpl::assign('users', $users); is code business logic part. then in template <?php foreach $users $row): ?> <div id="<?=$...
Read more

The canvas has been tainted by cross-origin data in chrome only -

-
uncaught securityerror: failed execute 'getimagedata' on 'canvasrenderingcontext2d': canvas has been tainted cross-origin data i getting above error in chrome. code(following) works fine in mozilla. have not corss domain issue. why above error in chrome? var wheel_canvas, wheel_context, can_w, can_h, wheel_grd; var large_radius = 160; var small_radius = 120; var wheel_canvas = document.getelementbyid('wheel_canvas'); var wheel_context = wheel_canvas.getcontext('2d'); var can_w = $(wheel_canvas).width(); var can_h = $(wheel_canvas).height(); var centerx = can_w / 2, centery = can_h / 2; var wheel_grd = null; test('#ff0000'); function test(hex) { $('#clrpicker').css({'left': 210, 'top': 210 }); inverted = hexbw(hex); $('#color_val_show').val(hex); current_color_hex_val_selected = hex; $('#color_val_show').css({'color':inverted,'background':hex}); fillgradient...
Read more