InfoPath Dev

I have built a browser compatible InfoPath 2007 form which has a repeating table to add items.  After the user types in an item, I have an after changed event handler that looks up the item number in a database and returns a value.  This part all works fine as long as I am on the first row of the repeating table.  When I add a new row to the table and attempt the same process, my XPath values are always referencing the first row in the repeating table rather than the current row.  I have modelled my code after this article from Microsoft (http://msdn2.microsoft.com/en-us/library/bb509311.aspx) and cannot for the life of me figure out how to get the context of the current row.  Any thoughts/ideas/solutions would be greatly appreciated. 

-Chris 

C# code follows:

try

// Check if value has changed and not a table insertion

{

string connString = ("Data Source=x;User Id=y;Password=y;Initial Catalog=a;");

string sql = null;

// Get Current Row

// Get Reference to the part number

string item = xNavigator.SelectSingleNode("/my:myFields/my:Parts/my:Part/my:PartNumber", this.NamespaceManager).InnerXml;

// 1. create a command object identifying the query

// 2. set the command object so it knows to execute a query

reader = cmd.ExecuteReader();

//Set its value to whatever it needs to be

xNavigator.SelectSingleNode("/my:myFields/my:Parts/my:Part/my:PartDescription", this.NamespaceManager).SetValue(desc);

ok so, right after posting this message I figured it out.

changed:

string item = xNavigator.SelectSingleNode("/my:myFields/my:Parts/my:Part/my:PartNumber", this.NamespaceManager).InnerXml;

to