C# How to manipulate key value of dictionary dynamically

Question

C# How to manipulate key value of dictionary dynamically

T.Zacks 3,996

I have to store data in dictionary where key value will be excel spreadsheet row number. I am working with 3rd party spreadsheet control where I am storing TunerDto data with all spreadsheet cell tag of first column but I found 3rd party has some bug. so delete any row from spreadsheet then other row's cell tag becomes null which causing issue for me.

so for work around purpose I think I need remove dependency from cell tag of spreadsheet control and maintain this info in dictionary where dictionary key value will be spreadsheet row number because spreadsheet row number is unique.

I am storing data in dictionary where key value is excel spreadsheet row number and value field is my class instance of TunerDto class.

this way I am storing data into dictionary now.

TunerDto _rowref = new TunerDto();
CellRange usedRange = worksheet.Range[cutrows];
for (int i = 0; i < usedRange.RowCount; i++)
{
    Cell currentCell = usedRange[i, 0];
    if (currentCell.Tag != null)
    {
        _rowref = currentCell.Tag as TunerDto;
        dictRowReference.Add(usedRange[i, 0].RowIndex.ToString(), _rowref);
    }
}

The problem is suppose my spreadsheet has 10 rows with data and suddenly user cut 2nd & 3rd row and paste those rows after 5th rows. this change need to adjust or impact row number in dictionary too. so how could I do this?

Should I use dictionary for this purpose or should I use any other collection ? dictionary lookup is very first.

If user cut 2nd & 3rd row and paste after 5th rows then how could I change row number of dictionary which is the key value in dictionary ?

please guide me how to handle this scenario with dictionary or any better data structure / collection for this purpose?

looking for suggestion and concept. Thanks

Jack J Jun 25,296 Reputation points

2022-04-26T07:50:08.327+00:00

@T.Zacks , Based on your description, I have some questions to confirm with you.
First, I want to know if all the TunerDto class is the same in your dictionary. Is it related to your excel row?
If user cut 2nd & 3rd row and paste after 5th rows then how could I change row number of dictionary which is the key value in dictionary ?

Second, if the 2nd & 3rd row is cut in your excel file, how do you set the current 2nd & 3rd row in your dictionary, Skip directly or still count 2 and 3？
T.Zacks 3,996 Reputation points

2022-04-26T15:00:58.223+00:00

TunerDto will be a instance which hold different data for each cell of first column.

if user cut 2nd & 3rd and paste after 5th row then by code i need to remove 2nd & 3rd row's data from dictionary and update row number in dictionary from 4th position to 10th position because row number from 4th position will be starting from 2nd and 10 will be 8th. again after paste i need to reshuffle row number value in dictionary.

i am not able to develop a such routine. can you please come up with any solution. thanks
AgaveJoe 30,126 Reputation points

2022-04-26T15:18:46.93+00:00

Contact the 3rd party spreadsheet control owners for assistance or read the documentation so you understand how the control works. It seems to me that the 3rd party spreadsheet control should have something equivalent to a change event. You get to add your custom sync or refresh code to the event handler.

But more importantly, why are you creating duplicate data in a dictionary that needs to be synced with the 3rd party spreadsheet control in the first place? Can't you use the 3rd party spreadsheet control as the authoritative data source?

1 answer

Your answer

Jack J Jun 25,296 Reputation points

2022-04-26T07:50:08.327+00:00

@T.Zacks , Based on your description, I have some questions to confirm with you.
First, I want to know if all the TunerDto class is the same in your dictionary. Is it related to your excel row?
If user cut 2nd & 3rd row and paste after 5th rows then how could I change row number of dictionary which is the key value in dictionary ?

Second, if the 2nd & 3rd row is cut in your excel file, how do you set the current 2nd & 3rd row in your dictionary, Skip directly or still count 2 and 3？
T.Zacks 3,996 Reputation points

2022-04-26T15:00:58.223+00:00

TunerDto will be a instance which hold different data for each cell of first column.

if user cut 2nd & 3rd and paste after 5th row then by code i need to remove 2nd & 3rd row's data from dictionary and update row number in dictionary from 4th position to 10th position because row number from 4th position will be starting from 2nd and 10 will be 8th. again after paste i need to reshuffle row number value in dictionary.

i am not able to develop a such routine. can you please come up with any solution. thanks
AgaveJoe 30,126 Reputation points

2022-04-26T15:18:46.93+00:00

Contact the 3rd party spreadsheet control owners for assistance or read the documentation so you understand how the control works. It seems to me that the 3rd party spreadsheet control should have something equivalent to a change event. You get to add your custom sync or refresh code to the event handler.

But more importantly, why are you creating duplicate data in a dictionary that needs to be synced with the 3rd party spreadsheet control in the first place? Can't you use the 3rd party spreadsheet control as the authoritative data source?

Answer 1

Bruce (SqlWork.com) 78,006 Volunteer Moderator

because a dictionary uses a hash table, there is no order. if you want to change the key, its a delete and then add.

if you can not detect the cut, then you probably should just rebuild the dictionary from scratch and consider it a cache,

T.Zacks 3,996 Reputation points

2022-04-30T16:28:05.903+00:00

if i rebuild the dictionary every time then what will be benefit of caching dictionary ? please guide me. thanks

Share via

C# How to manipulate key value of dictionary dynamically

1 answer

Your answer