InfoPath Dev

Hi all,

            I need to get the current row number using the "e.Site........" . Is this possible??  or else how to get the position of the current row in the changed event control of a repeating table.

Thanks in advance,

Kalyan.

 You should be able to use e.Site.Evaluate("count(preceding-sibling::repeatingFieldName)", NamespaceManager);

This will return an object value that you can cast to a double, and after that, to an int if you want to.

 Hi Jimmy,

I tried that Convert.ToDouble(e. Site.Evaluate("count(preceding-sibling::LINE_NO)",NamespaceManager));

Here LINE_NO is my repeating control Name. But it was getting "0.0" into that in each and every row of the table. I tried converting into int it was giving "0".

I tried with e.Site.Select("../LINE_NO",NamespaceManager).CurrentPosition also. This was also giving the same value "0".

  By using e. Site.Evaluate("count(preceding-sibling::LINE_NO)",NamespaceManager); what you want me to  expect the result if i convert it into double and then into int. Is that the current row number????

 Could you attach a screenshot of your data source?

Thanks for quick reply,

Here is my data source.(Not the exact one, i am not supposed to show that,sorry for that). Here is the structure of my datasource,

- myFields

  - queryFields

    - tns: Method1

       -  : Structure

          -  item (REPEATING NODE)

                        Field1

                        Field2 

                        Field3 

                        Field4 

                        LINE_NO (This is the control where i am writing my changed event and where i should get my row number) 

                        Field6 

                        Field7 

                        Field8 

                        Field9 

  - dataFields

      - tns: Method 2

                      retrieve Data

This is the structure of my datasource Jimmy, Can you please help on how to get the current row number using  "e.Site".

Thanks in Advance,

Kalyan.

 Please try Convert.ToDouble(e. Site.Evaluate("count(../preceding-sibling::item)",NamespaceManager));

Hi Jimmy,

            It worked this time, thank you very much for your sugession.

Thanks,

Kalyan.