Code

Re: How to get the position of the current row

kalyan@infopath — Fri, 21 Aug 2009 19:05:26 GMT

Hi Jimmy,

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

Thanks,

Kalyan.

Re: How to get the position of the current row

Jimmy — Fri, 21 Aug 2009 06:02:42 GMT

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

Re: How to get the position of the current row

kalyan@infopath — Fri, 21 Aug 2009 02:06:57 GMT

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.

Re: How to get the position of the current row

Jimmy — Fri, 21 Aug 2009 00:37:45 GMT

Could you attach a screenshot of your data source?

Re: How to get the position of the current row

kalyan@infopath — Thu, 20 Aug 2009 22:45:20 GMT

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????

Re: How to get the position of the current row

Jimmy — Thu, 20 Aug 2009 21:51:39 GMT

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.

How to get the position of the current row

kalyan@infopath — Thu, 20 Aug 2009 18:58:20 GMT

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.