dataset sort and combine/consolidate

[jeweladdict]

I have a dataset of items (UPC, price, quantity, name) that I would like to combine based on like items. For example, all items with the same name, I would like to combine so that the quantity and prices are changed accordingly. Are there any built in functions that will let me do this? Or do I have to create a routine which will sort the dataset, create a new set, and then go through the old dataset and combine like items and then add to the new dataset? thanks!

[jeweladdict]

I guess this would be more of a datarow combining/merging question./..

[Nader Elshehabi]

Hello

jeweladdict wrote:

Are there any built in functions that will let me do this?

Well, maybe you're talking about Stored Procedures? Anyway, here is an approach to do something like what you want -even though I don't like it but I can't really think of something better-. 1- Make a datagridview and feed it with your table 2- Sort it according by the name -if that's what you want 3- Iterate through the rows comparing each row with its previous one -except the first row of course- 4- Find similar rows and combine their values, then delete the second one NB. You don't have to make the DataGridView visible to the user Please, if someone has a better approach post. I believe there should be a better way. but this should work! Regards:rose:

[jeweladdict]

that works like a charm. Thanks!

[Nader Elshehabi]

Hello An Even much better approach is to use the DataView class instead of a DataGridView!! Sorry that such a simple solution didn't cross my mind:-O, I've been awake for almost two days now!! Regards:rose: