Click here to Skip to main content
15,906,645 members
Home / Discussions / C#
   

C#

 
GeneralRe: Existence of “Add” Function causes WCF to Fail Pin
OriginalGriff8-Feb-21 4:01
mveOriginalGriff8-Feb-21 4:01 
GeneralRe: Existence of “Add” Function causes WCF to Fail Pin
Bernhard Hiller8-Feb-21 4:03
Bernhard Hiller8-Feb-21 4:03 
AnswerRe: Existence of “Add” Function causes WCF to Fail Pin
Gerry Schmitz8-Feb-21 4:45
mveGerry Schmitz8-Feb-21 4:45 
QuestionHow to avoid progress bar freeze when calculations are performed in background? Pin
Alex Dunlop7-Feb-21 8:18
Alex Dunlop7-Feb-21 8:18 
GeneralRe: How to avoid progress bar freeze when calculations are performed in background? Pin
harold aptroot7-Feb-21 8:24
harold aptroot7-Feb-21 8:24 
GeneralRe: How to avoid progress bar freeze when calculations are performed in background? Pin
Alex Dunlop7-Feb-21 16:24
Alex Dunlop7-Feb-21 16:24 
AnswerRe: How to avoid progress bar freeze when calculations are performed in background? Pin
Gerry Schmitz7-Feb-21 10:19
mveGerry Schmitz7-Feb-21 10:19 
AnswerRe: How to avoid progress bar freeze when calculations are performed in background? Pin
Luc Pattyn7-Feb-21 17:18
sitebuilderLuc Pattyn7-Feb-21 17:18 
QuestionWinForm launching a console application Pin
picasso22-Feb-21 18:32
picasso22-Feb-21 18:32 
AnswerRe: WinForm launching a console application Pin
Gerry Schmitz2-Feb-21 18:36
mveGerry Schmitz2-Feb-21 18:36 
GeneralRe: WinForm launching a console application Pin
Dave Kreskowiak2-Feb-21 18:42
mveDave Kreskowiak2-Feb-21 18:42 
GeneralRe: WinForm launching a console application Pin
Gerry Schmitz3-Feb-21 6:20
mveGerry Schmitz3-Feb-21 6:20 
GeneralRe: WinForm launching a console application Pin
Dave Kreskowiak3-Feb-21 6:39
mveDave Kreskowiak3-Feb-21 6:39 
GeneralRe: WinForm launching a console application Pin
Gerry Schmitz3-Feb-21 6:59
mveGerry Schmitz3-Feb-21 6:59 
GeneralRe: WinForm launching a console application Pin
Dave Kreskowiak3-Feb-21 7:13
mveDave Kreskowiak3-Feb-21 7:13 
GeneralRe: WinForm launching a console application Pin
Gerry Schmitz3-Feb-21 7:28
mveGerry Schmitz3-Feb-21 7:28 
AnswerRe: WinForm launching a console application Pin
Dave Kreskowiak2-Feb-21 18:40
mveDave Kreskowiak2-Feb-21 18:40 
AnswerRe: WinForm launching a console application Pin
OriginalGriff2-Feb-21 19:48
mveOriginalGriff2-Feb-21 19:48 
GeneralRe: WinForm launching a console application Pin
trønderen3-Feb-21 3:58
trønderen3-Feb-21 3:58 
GeneralRe: WinForm launching a console application Pin
OriginalGriff3-Feb-21 5:13
mveOriginalGriff3-Feb-21 5:13 
AnswerRe: WinForm launching a console application Pin
TimWallace8-Feb-21 18:03
TimWallace8-Feb-21 18:03 
QuestionHow to sum up values of duplicate keys in a dictionary? Pin
Alex Dunlop2-Feb-21 6:37
Alex Dunlop2-Feb-21 6:37 
I have 5 column in a spreadsheet (DevExpress spreadsheet). The first four columns are string values. The fifth column is integer (numeric). I joined those first four columns and put it as KEYs in a list, then collected the fifth column entries as VALUEs in an another list. I used these two lists to create a dictionary.
Now, I want to sum values related to each duplicate keys. As you now, dictionary object throw an exception for duplicate keys. How can I sum those values related to each duplicate keys?
I tried this:
C#
IWorkbook workbook = spreadsheetControl.Document;
            Worksheet worksheet = workbook.Worksheets.ActiveWorksheet;
            CellRange range = worksheet.GetDataRange();
            int LastRow = range.BottomRowIndex;
            var keys = new List<string>();
            var values = new List<int>();

            for (int i = 0; i < LastRow + 1; i++)
            {
                keys.Add(string.Join(",", worksheet.Cells[i, 0].DisplayText, worksheet.Cells[i, 1].DisplayText,
                    worksheet.Cells[i, 2].DisplayText, worksheet.Cells[i, 3].DisplayText));
                values.Add((int)worksheet.Cells[i, 4].Value.NumericValue);
            }
            var mydic = new Dictionary<string, int>();
            for (int i = 0; i < keys.Count; i++)
            {
                try
                {
                    mydic.Add(keys[i], values[i]);
                }
                catch (Exception)
                {
                    if (mydic.ContainsKey("f,a,r,d") == true)
                    {
                        MessageBox.Show("Duplicate");
                    }
                }
            }

I need to replace
C#
if (mydic.ContainsKey("f,a,r,d") == true)
                    {
                        MessageBox.Show("Duplicate");
                    }
with another code. Confused | :confused:

modified 2-Feb-21 12:48pm.

AnswerRe: How to sum up values of duplicate keys in a dictionary? Pin
Dave Kreskowiak2-Feb-21 12:35
mveDave Kreskowiak2-Feb-21 12:35 
GeneralRe: How to sum up values of duplicate keys in a dictionary? Pin
Alex Dunlop3-Feb-21 5:39
Alex Dunlop3-Feb-21 5:39 
GeneralRe: How to sum up values of duplicate keys in a dictionary? Pin
Dave Kreskowiak3-Feb-21 6:36
mveDave Kreskowiak3-Feb-21 6:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.