Dim myCurrentRowIndex As Integer = Me.BizServiceCalls1.CurrentRowIndex '-- here do whatever you want with this BO and move the position as you like. '-- Now go back to the old record Me.BizServiceCalls1.MoveAbsolute(myCurrentRowIndex)
I did the above but in just TESTING the Dim statement I kept getting 0 for the value of myCurrentRowIndex. I thought that can not be because I am not on record 1. Well as I spent more time on my code I really was on record 1 and not where I wanted to be. So Edhy, you helped me again and I found one of my logic errors. A great christmas gift. Thank you so much.
But the following I did not know about so this will be very helpful down the road.
' Also keep in mind that if you need to loop the BO you can take advantage of the ' BO.GetEnumerable() method that will allow you to loop and keep the CurrentRowIndex ' unchanged after finishing the lopping. Here is an example: For Each boRecord As bizServiceCalls In Me.BizServiceCalls1.GetEnumerable() '-- Now you are looping each record in the BO instance Me.BizServiceCalls1 boRecord.Apt_No = "3-D" boRecord.Notes = "This is a note sample" Next '-- Now if you try to use the bo instance Me.BizServiceCalls1 it will be in the same ' CurrentRowIndex as before you started the GetEnumerable() loop.
Dim myCurrentRowIndex As Integer = Me.BizServiceCalls1.CurrentRowIndex '-- here do whatever you want with this BO and move the position as you like. '-- Now go back to the old record Me.BizServiceCalls1.MoveAbsolute(myCurrentRowIndex) ' Also keep in mind that if you need to loop the BO you can take advantage of the ' BO.GetEnumerable() method that will allow you to loop and keep the CurrentRowIndex ' unchanged after finishing the lopping. Here is an example: For Each boRecord As bizServiceCalls In Me.BizServiceCalls1.GetEnumerable() '-- Now you are looping each record in the BO instance Me.BizServiceCalls1 boRecord.Apt_No = "3-D" boRecord.Notes = "This is a note sample" Next '-- Now if you try to use the bo instance Me.BizServiceCalls1 it will be in the same ' CurrentRowIndex as before you started the GetEnumerable() loop.