Hi Atanas,   Thanks for your solution.  I ran your zipped up app. and it is prtty much what I was looking for thank you very very much.  There is one small thing I wanted to ask. Once the row is filled can we move the focus to the new row? Also, the add row seems to contain the last appoinment id, can we also get rid of that?

It seems like in your sample, it is adding a new row.  Not appending to the row you just typed the AppoinmentId in.

I am also adding my databinding process.

I have a model PurchaseAdviceWizardDataView I also have a BindingList<PurchaseAdviceWizardDataView>(); I then do this this.gridLoanResult.SetDataBinding(_context.PurchaseAdviceListView, null);

It seems like unless I do the last line in my case I do not get the result view.

Hi Atanas,

Thanks again for your continued support. I think it makes sense to just remove the last active row. It almost seems like the row is getting added by the Ultragird as you start typing to a row and since the its bound to that data and I am gussines it automatically updates it. So, its always in sync with that. It would be great if that worked the other way round, without having to bind it each time. I could be wrong. So, to simplify, since I already know the current index (arow) im just calling the removeat before the add

_context.PurchaseAdviceListView.RemoveAt(currrow);
_context.PurchaseAdviceListView.Add(loandata);

It would be nice to have a replace I suppose.

Since the problem I am having now is, if the row with the same num(id) exists, then instead of add, i need to do update.

So, its like this...

User enters the num(id) in the row[curr].col[0], the system checks if this id exists in the db. it then gets the data and populates the rest of the columns for that same row. OK

User enters another num in the next row, system checks if it exists in the current grid, if it exists then remove the row and don't allow the user to enter another of the same. OK

User updates an existing row, system still finds that the num exists (even though its the same row so its an update) it removes it. So, I guess I need to also check if its the same index or not. What is the best way to do that?

The things get more complicated, because, I have a view which is a subset of another model. Which consists of multiple of those views (grouped by batch). This whole thing is mimicking a wizard like view (with next, previous, add etc).

It would be nice, if I would just display the bigger list and simply group by batch number and when user clicks next it increases the filter and shows the next batch. so the user will feel like they are navigating through batches (shows one batch view each time).

Then I don't need this smaller view model and persisting will be easy.

I also was wondering…

1. How to make the col of a row readonly once it has been populated from db or other means.  This may prevent the issue where once they have entered a num the system will not want to search for that num again.  And then I can just update the data when its coming from the same row from rest of the columns… not sure if that make sense.
2. When I tab off from row I want to persist the data to another model. What event should be ideal?

 Thanks again.

Hi Atanas,

Thanks so much for your reply.  I will give a details reply.  But, for now I wanted to let you know that you are absolutey correct about the binding.  However, I think the updated data is not available (or does not bing with the source) during keydown event.  Am I wrong?

Hello Joy,

The updated data doesn’t need to bind with the source because we have already binded our UltraGrid with the BindingList and thus each data from the list is binded with the grid. So, when we change the id of the row and press TAB the KeyDown event fires and the changes that occur in the row are visualized in the grid.

I hope that this information will help you.

Please do not hesitate to contact me if you have any further question.

Thanks Atanas. 

Is there any way I can decoreae my view properties so they don't get added to the grid automatically?  What is the best way to handle this?

You have a great weekend!

this.ultraCombo1.SyncWithCurrencyManager = true;

Hi Atanas,

Hope you are doing well.

I am trying to use UltraCombo, which i believe is a part of the grid family.  When I used a regular windows combobox I was able to bind it with a BindingList.  I also bound few other text controls with that and when I selected new values in the regular combobox it also changed all the values in all other controls that were bound to the same BindingList.

But, when I used the UltraCombo (with multicolums) selecting a row does not change the other controls.  What is the way to achive this with UltraCombo?

Hello Joy,

Thanks for the reply.

Do not hesitate to contact me if you have any additional questions.

Thank you for using Infragistics Components.

Hi Atanas,

Sorry for the long delay.  I have been away and just getting back.  I think for what you have given me enough to solve the issues I had.  I will surely post any updates I may have.  Your informations greatly helped.

Thanks again.

Hello Joy,

I am just checking about the progress of this issue. Let me know If you need my further assistance on this  issue?

Thank you for using Infragistics Components.