General

Re: Creating a dataset before the form (xml) is saved.

golden_shiner — Thu, 24 Sep 2009 15:14:38 GMT

XPathNavigator myNav = MainDataSource.CreateNavigator();XPathNodeIterator NodeIterator = myNav.Select("/my:myFFIM_base_table/my:Species_Records/my:SpeciesGroup/my:GROUP_1MM/my:GROUP_1MM_sub", NamespaceManager);

string temp_species = String.Empty;

int temp_value = 0;

string species = String.Empty;

string CountOneM = String.Empty;

string LengthOneM = String.Empty;

string WeightOneM = String.Empty;

string BatchWeightOneM = String.Empty;

string Onecm = String.Empty;

double FinalLength = 0;

double x = 0;

double TempWeight = 0;

double FinalWeight = 0;

double intercept = 0;

double slope = 0;

while (NodeIterator.MoveNext())

{

myNode = NodeIterator.Current.CreateNavigator();

XPathNavigator group1CM = myNode.SelectSingleNode("../../my:GROUP_1CM", NamespaceManager);

XPathNavigator countOnecm = group1CM.SelectSingleNode("my:group9/my:COUNT_1CM", NamespaceManager);

CountOneM = myNode.SelectSingleNode("my:COUNT_1MM", NamespaceManager).Value;

LengthOneM = myNode.SelectSingleNode("my:TOTAL_LENGTH_1MM", NamespaceManager).Value;

WeightOneM = myNode.SelectSingleNode("my:TOTAL_WEIGHT_1MM", NamespaceManager).Value;species = myNode.SelectSingleNode("../../my:SPECIES_ID", NamespaceManager).Value;

switch (species)

{

case "139203":

DoWrite("1 cm count" + countOnecm);

temp_species = "Bluegill - BLUE";

intercept = 4.04899;

slope = 2.72044;

temp_value = EmptyFields(temp_species, CountOneM, LengthOneM, WeightOneM);

if (temp_value == 0)

{

}

else

if (Convert.ToDouble(LengthOneM) < 40 && Convert.ToDouble(WeightOneM) > 8)

{

DoWrite("SPECIES: " + temp_species);DoWrite("Weight is out of range ( length < 40mm and weight > 8 g) ");

}

else

if (Convert.ToDouble(LengthOneM) > 40 && Convert.ToDouble(LengthOneM) <80 && Convert.ToDouble(WeightOneM) > 20)

{

DoWrite("SPECIES: " + temp_species);DoWrite("Weight is out of range ( length 40mm-80mm and weight > 20g) ");

}

else

CheckRatio(temp_species, intercept, slope, LengthOneM, WeightOneM, CountOneM);

break; ....

thanks again.

Re: Creating a dataset before the form (xml) is saved.

Jimmy — Thu, 24 Sep 2009 14:17:48 GMT

Would you mind sharing more of your code? Without that, I can only repeat what I've said above.

Re: Creating a dataset before the form (xml) is saved.

golden_shiner — Thu, 24 Sep 2009 13:45:33 GMT

Thank you for your reply. That seems to work except I can only access the values of the first row repeatedly. In other words it does run multiple times through the rows of data, but only gives me the values of the first row. Any ideas to why is that? Thank you very much.

Re: Creating a dataset before the form (xml) is saved.

Jimmy — Sat, 19 Sep 2009 02:43:19 GMT

Just use relative XPath selection like in my earlier post.

So visualizing that your XPathNavigator is positioned at the my:GROUP_1MM_sub node, you have to use ".." to move up several levels of the data source tree before going down again:

XPathNavigator group1CM = myNode.SelectSingleNode("../../my:GROUP_1CM", NamespaceManager);

The first .. refers one step up the tree to the GROUP_1MM node; the second refers another step up to the SpeciesGroup node, and then my:GROUP_1CM moves back down the tree again.

Then you can from there continue going down the tree to get the values you want:

XPathNavigator count1cm = group1CM.SelectSingleNode("my:group9/my:COUNT_1CM", NamespaceManager);

Re: Creating a dataset before the form (xml) is saved.

golden_shiner — Thu, 17 Sep 2009 17:31:34 GMT

I have another question, how do I reference the values of COUNT_1CM, TOTAL_LENGTH_1CM under GROUP_1CM/group( in the data source shown above) before going to the next species ?? so basically running through all the 1mm 1cm and 2cm values before going to the next specie. Thank you very much for the help.

Re: Creating a dataset before the form (xml) is saved.

golden_shiner — Tue, 15 Sep 2009 20:33:46 GMT

I am so sorry I missed that detail. BUT, it works as you suggested . THANK YOU VERY MUCH!!!!!!!!! I am so releived, it was driving me crazy.

Re: Creating a dataset before the form (xml) is saved.

Jimmy — Tue, 15 Sep 2009 19:43:02 GMT

The trouble is that you're using

"/my:myFFIM_base_table/my:Species_Records/my:SpeciesGroup/my:SPECIES_ID"

instead of

"../../my:SPECIES_ID"

like I suggested

Re: Creating a dataset before the form (xml) is saved.

golden_shiner — Tue, 15 Sep 2009 18:36:37 GMT

XPathNavigator myNav = MainDataSource.CreateNavigator();

XPathNodeIterator NodeIterator = myNav.Select("/my:myFFIM_base_table/my:Species_Records/my:SpeciesGroup/my:GROUP_1MM/my:GROUP_1MM_sub", NamespaceManager);

string species = String.Empty;

string CountOneM = String.Empty;

string LengthOneM = String.Empty;

string WeightOneM = String.Empty;

string BatchWeightOneM = String.Empty;

double FinalLength = 0;

double x = 0;

double TempWeight = 0;

double FinalWeight = 0;

while (NodeIterator.MoveNext())

{

myNode = NodeIterator.Current.CreateNavigator();

species = myNode.SelectSingleNode("/my:myFFIM_base_table/my:Species_Records/my:SpeciesGroup/my:SPECIES_ID", NamespaceManager).Value;

CountOneM = myNode.SelectSingleNode("my:COUNT_1MM", NamespaceManager).Value;

LengthOneM = myNode.SelectSingleNode("my:TOTAL_LENGTH_1MM", NamespaceManager).Value;WeightOneM = myNode.SelectSingleNode("my:TOTAL_WEIGHT_1MM", NamespaceManager).Value;

switch (species)

{

case "139203":

if (CountOneM == "" && LengthOneM != "" && WeightOneM != "")

{

DoWrite("Missing number of fish");

}

else

if (CountOneM != "" && LengthOneM != "" && WeightOneM == "")

{

DoWrite("Missing Weight value");

} ......

this is one of the ways I have tried to get species ID . Thank you again for the help.

Re: Creating a dataset before the form (xml) is saved.

Jimmy — Tue, 15 Sep 2009 17:25:09 GMT

Then something's not quite right with your code. Could you attach an actual screenshot of your datasource, and the actual code you have tried so far, including the part to retrieve the specieID?

Re: Creating a dataset before the form (xml) is saved.

golden_shiner — Tue, 15 Sep 2009 17:09:19 GMT

The issue is that it always gives me the first specieID, it does not move to the next one.

Re: Creating a dataset before the form (xml) is saved.

Jimmy — Tue, 15 Sep 2009 15:18:05 GMT

I'm still not sure exactly what the problem is. Are you saying you don't have access to the Species ID when you find a weight/length ratio that violates the constraint?

If so, you should be able to get at the current id within that while loop with something like:

myNode.SelectSingleNode("../../my:Species_ID", NamespaceManager);

Re: Creating a dataset before the form (xml) is saved.

golden_shiner — Tue, 15 Sep 2009 14:57:12 GMT

ok, so the data source of this part of the form looks something like this:
Repeating section:

-Species Record
     Species_ID
        -Group_1mm
         -Group_1mm_sub
                  count
                   length
                   weight
       -Group_1cm
          -Group_1cm_sub
                   count
                   length
                   weight

For each specie I have to check the weight/length ratio and then I write out to a txt file if not correct ratio.

The code below is what I have been using. the problem is, it goes through "count" length" "weight" for all the species. I need to check those values specie by specie so when I write out to the file I am ponting the values to the right specie.

XPathNavigator myNav = MainDataSource.CreateNavigator();
XPathNodeIterator NodeIterator = myNav.Select("/my:myFFIM_base_table/my:Species_Records/my:SpeciesGroup/my:GROUP_1MM/my:GROUP_1MM_sub", NamespaceManager);

while (NodeIterator.MoveNext())
                        {
                            myNode = NodeIterator.Current.CreateNavigator();
                            CountOneM = myNode.SelectSingleNode("my:COUNT_1MM", NamespaceManager).Value;
                            LengthOneM = myNode.SelectSingleNode("my:TOTAL_LENGTH_1MM", NamespaceManager).Value;
                            WeightOneM = myNode.SelectSingleNode("my:TOTAL_WEIGHT_1MM", NamespaceManager).Value;
                }

Thanks!

Re: Creating a dataset before the form (xml) is saved.

Jimmy — Tue, 15 Sep 2009 14:15:13 GMT

You should be able to use XPath to accomplish any validation that you need. If you could provide a diagram of your data source and an example of what kind of validation you are trying to perform, one of us can show you an example of the sort of code to use.

Re: Creating a dataset before the form (xml) is saved.

golden_shiner — Tue, 15 Sep 2009 13:51:14 GMT

I appreciate the quick reply. Xpath was my first choice actually, but the reason I am using datasets is that I need to check values in repeating sections. The repeating section includes repeating rows and one single field which are related and I need to check them that way. When I used Xpath all the rows (from all the repeating sections we accessed at the same time) which does not help me. So I need help in either reading each section seperately using Xpath or using ReadXml() by pointing to the current form. Thank You!!!

Re: Creating a dataset before the form (xml) is saved.

Qazi Anis — Tue, 15 Sep 2009 06:46:35 GMT

hi,

if u r going to do it at savign time ,

you can use folloiwing code to check the values

XPathNavigator xntemp = null;

XPathNavigator xnDoc = null;

xnDoc = this.MainDataSource.CreateNavigator();

xntemp = xnDoc.SelectSingleNode("/my:myFields/my:fieldToBeChecked", this.NamespaceManager);

if ( xntemp.toString().equals("WhatEverYouWant"))

{

//write your code here

}