Re: Count DataGridview row values and compare with an Array - C# Discussion Boards

Re: Count DataGridview row values and compare with an Array

7-Aug-23 14:21

I'm populating a Datagriview from a text file with several lines with 15 numbers each, these numbers change every day, as well as the number of lines.
Ex:
*01 05 08 09 10 12 15 16 17 18 19 20 22 24 25

*02 07 08 09 10 11 15 16 17 18 20 21 22 24 25

*01 07 08 09 10 12 13 15 17 18 19 20 21 22 25

I also have an array that generates 15 random numbers between 01 and 25,
ex: 01 02 04 05 08 09 13 15 16 17 18 19 20 22 25

I need to count how many numbers in each line are repeated with the numbers in the array.
tenho seguinte codigo, mas não me traz um resultado satisfatório.

<pre> private IDictionary<int, int> GetResultFromTextFile(IEnumerable<int> src)
        {
            var filePath = @"C:\BoaSorte\Banco\testeResultado.txt";
            var delimiter = new[] { ' ' };
            var dict = File.ReadLines(filePath)
                .Where(line => !string.IsNullOrEmpty(line))
                .Aggregate(new Dictionary<int, int>(), (d, line) =>
                {
                    var values = line
                    .Split(delimiter, StringSplitOptions.RemoveEmptyEntries)
                    .Select(x => int.Parse(x));
                    var matchCount = values.Where(v => src.Contains(v)).Count();

                    if (matchCount <= 15)
                    {
                        if (d.ContainsKey(matchCount))
                            d[matchCount]++;
                        else
                            d[matchCount] = matchCount;
                    }
                    return d;
                });

            return dict;
        }
<pre>private void button1_Click(object sender, EventArgs e)
        {
            int outVal;

            if (UltimoResultado.Any(Acertos => !int.TryParse(Acertos.Text, out outVal)))
            {
                MessageBox.Show("Valores Invalidos...");
                return;
            }
            var arr = UltimoResultado.Select(linha => int.Parse(linha.Text));
            var result = GetResultFromTextFile(arr).ToList();
            for (int i = 0; i < result.Count; i++)
            { 
                    dgHits.Rows[i].Cells["Acertos"].Value = result[i].ToString();                
            }
        }

a picture of how i'm receiving

how am i receiving

how do i need it to appear

thank you in advance for any comments

modified 20-Aug-23 23:06pm.

OriginalGriff7-Aug-23 19:56

OriginalGriff

7-Aug-23 19:56

And?
What have you tried?
Where are you stuck?
What help do you need?

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

Re: Count DataGridview row values and compare with an Array

Andre Oosthuizen7-Aug-23 22:46

Re: Count DataGridview row values and compare with an Array

7-Aug-23 22:46

Your code is storing the repeated counts as keys in the dictionary, which results in multiple repetitions being displayed in a single row in the DataGridView in your 'Acertos' cell.

You need to store the dictionary values to store the count of repetitions for each line, rather than the repeated count itself -

private IDictionary<int, int> GetResultFromTextFile(IEnumerable<int> src)
{
    var filePath = @"C:\BoaSorte\Banco\testeResultado.txt";
    var delimiter = new[] { ' ' };
    var dict = File.ReadLines(filePath)
        .Where(line => !string.IsNullOrEmpty(line))
        .Aggregate(new Dictionary<int, int>(), (d, line) =>
        {
            var values = line
                .Split(delimiter, StringSplitOptions.RemoveEmptyEntries)
                .Select(x => int.Parse(x));
            var matchCount = values.Count(v => src.Contains(v)); //Count all matches...

            if (d.ContainsKey(matchCount))
                d[matchCount]++;
            else
                d[matchCount] = 1; //Store the count of repetitions, not the repeated count...

            return d;
        });

    return dict;
}

private void button1_Click(object sender, EventArgs e)
{
    int outVal;

    if (UltimoResultado.Any(Acertos => !int.TryParse(Acertos.Text, out outVal)))
    {
        MessageBox.Show("Valores Invalidos...");
        return;
    }
    
    var arr = UltimoResultado.Select(linha => int.Parse(linha.Text));
    var result = GetResultFromTextFile(arr).ToList();
    
    for (int i = 0; i < result.Count; i++)
    {
        dgHits.Rows[i].Cells["Acertos"].Value = result[i].Value.ToString(); //Display the value, not the key...
    }
}

Edilson Lemos 20219-Aug-23 14:00

Re: Count DataGridview row values and compare with an Array

9-Aug-23 14:00

hello André Oosthuizen, Muito Obrigado por responder meu tópico.

what is happening to me is that it returns the repeated numbers of the Array [ex: 13 hits, and the number of lines with 13 hits ex: 2]
I would like only the Hits to return, each one in its respective line as in the second image,

this code is returning the amount of line as n Hits,

if (d.ContainsKey(matchCount))
               d[matchCount]++;
           else
               d[matchCount] = 1;

I need the opposite, the number of hits for each line (or Repeated from the array)

it's working, but the lines that have the same number of hits don't return anything

<pre lang="C#">if (matchCount <= 15) { d[matchCount] = matchCount; }

modified 9-Aug-23 21:14pm.

Andre Oosthuizen9-Aug-23 21:24

Re: Count DataGridview row values and compare with an Array

9-Aug-23 21:24

I think I know what you need, try the following code. I did not test it so you might need to change it to do exactly as you require -

private IDictionary<int, int> GetResultFromTextFile(IEnumerable<int> src)
{
    var filePath = @"C:\BoaSorte\Banco\testeResultado.txt";
    var delimiter = new[] { ' ' };
    var dict = new Dictionary<int, int>();

    foreach (var line in File.ReadLines(filePath).Where(line => !string.IsNullOrEmpty(line)))
    {
        var values = line.Split(delimiter, StringSplitOptions.RemoveEmptyEntries)
                         .Select(x => int.Parse(x));
        var matchCount = values.Count(v => src.Contains(v));

        if (matchCount <= 15)
        {
            if (!dict.ContainsKey(matchCount))
            {
                dict[matchCount] = 0;
            }

            dict[matchCount]++;
        }
    }

    return dict;
}

private void button1_Click(object sender, EventArgs e)
{
    int outVal;

    if (UltimoResultado.Any(Acertos => !int.TryParse(Acertos.Text, out outVal)))
    {
        MessageBox.Show("Valores Invalidos...");
        return;
    }

    var arr = UltimoResultado.Select(linha => int.Parse(linha.Text));
    var result = GetResultFromTextFile(arr).ToList();

    for (int i = 0; i < result.Count; i++)
    {
        dgHits.Rows.Add(); // Add a new row
        dgHits.Rows[i].Cells["Acertos"].Value = result[i].Value.ToString();
    }
}

Richard Deeming9-Aug-23 21:51

Richard Deeming

9-Aug-23 21:51

Andre Oosthuizen wrote:

if (!dict.ContainsKey(matchCount))
{
    dict[matchCount] = 0;
}

dict[matchCount]++;

That checks whether the dictionary contains the key; sets the value if it doesn't; gets the value; then sets the value again.

It would be more efficient to use:

dict.TryGetValue(matchCount, out int existing);
dict[matchCount] = existing + 1;

If the dictionary doesn't contain the key, the existing variable will be set to 0.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Count DataGridview row values and compare with an Array

Edilson Lemos 202110-Aug-23 6:44

Re: Count DataGridview row values and compare with an Array

10-Aug-23 6:44

André Oosthuizen, thank you very much for your attention, I will try to explain myself better,

I need to show how many hits are in each line, comparing with the numbers generated in the array,
EX: line 1 --- 10 hits,
line2 --- 8 hits,
row 3 --- 10 hits,
line 4 --- 11 hits,
line 5 --- 11 hits,
row 6 --- 7 hits.

the code I have, shows me the total lines with 10 hits,
the total lines with 11 hits,
the total rows with 7 hits, Just exemplifying
*that's not what I need.
what i need each line to have the number of hits at the end of the line itself.
I'll leave an image to try to understand.

Exemple image

modified 10-Aug-23 17:45pm.

Edilson Lemos 202110-Aug-23 16:23

Re: Count DataGridview row values and compare with an Array

10-Aug-23 16:23

I solved my problem as follows

string[] lines = File.ReadAllLines(@"C:\BoaSorte\Banco\testeResultado.txt");
            string[] line, contents, result;
            int count;
            result = textBox1.Text.Split(); 
            for (int i = 0; i < lines.Length; i++)
            {
                contents = lines[i].Split(' ');
                count = contents.Intersect(result).Count();
                line = new string[16];
                for (int j = 0; j < 15; j++)
                    line[j] = contents[j];
                line[15] = count.ToString();
                dgHits.Rows.Add(line);
            }

Thanks for the help of André Oosthuizen and Richard Deeming

Andre Oosthuizen10-Aug-23 23:15

10-Aug-23 23:15

Only a pleasure, glad you found the solution!

Sharepoint

Kevin Marois7-Aug-23 8:15

Kevin Marois

7-Aug-23 8:15

I've been tasked with reading & writing file to/from sharepoint. I've never even seen Sharepoint before.

I have a Windows app that will load files from Sharepoint, run some processing, and write the results back out to Sharepoint. They have made me an admin on it so I can set things up.

I've been Googling, but all I get are snippets with little context.

I'm going to ask some stupid questions...

How do I setup the location(s) I need?
Are there actual folders I can read/write from? How do I reference them? Like a drive letter? Or do I need an API?
Where do I go to get sharted doing this with C#?

Thanks

In theory, theory and practice are the same. But in practice, they never are.”
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.

Re: Sharepoint

Andre Oosthuizen7-Aug-23 23:15

7-Aug-23 23:15

I did some searching and I trust the following is what you might need going forward -

1) To set up your SharePoint Site, have a look at - MS Support | Create a site in SharePoint [^]

2) SharePoint uses different authentication methods, often involving OAuth tokens or username/password credentials. You'll need to confirm the authentication mechanism that your company uses. Common libraries for handling authentication include Microsoft's MSAL (Microsoft Authentication Library) or ADAL (Active Directory Authentication Library) for OAuth-based authentication. You will find more at - MS Support | With a Mismatch Error | Authentication settings in Central Administration do not match the configuration in web.config [^]
MS Learn | Overview of the Microsoft Authentication Library (MSAL)[^]
MS Azure | Active Directory Authentication Library (ADAL)[^]

3) SharePoint has REST APIs that allow you to interact with it programmatically. Alternatively, there are client libraries provided by Microsoft that can simplify the process of interacting with SharePoint using C#. The Microsoft Graph API is a newer unified API that can also be used to work with SharePoint. See more at - Lists vs. Libraries in SharePoint Online [^]

4) In SharePoint, you have libraries that act like folders. Documents are stored within these libraries.
You can access files using URLs like 'https://your_site.sharepoint.com/sites/your_site_name/your-library-name/your-file-path'.
With APIs, you'll use HTTP requests (GET, PUT, POST, DELETE) to interact with SharePoint. For C#, you can use libraries like HttpClient for making these requests. See more at - MS Support | Work with files in a document library [^]
As a high level example of how you might use 'HttpClient' to read a file from SharePoint using C# -

using System;
using System.Net.Http;
using System.Threading.Tasks;

class Program
{
    static async Task Main(string[] args)
    {
        string url = "https://<your-domain>.sharepoint.com/sites/<site-name>/<library-name>/<file-path>";
        string accessToken = "<your-access-token>";

        using (var client = new HttpClient())
        {
            client.DefaultRequestHeaders.Add("Authorization", $"Bearer {accessToken}");
            HttpResponseMessage response = await client.GetAsync(url);
            if (response.IsSuccessStatusCode)
            {
                string content = await response.Content.ReadAsStringAsync();
                Console.WriteLine(content);
            }
            else
            {
                Console.WriteLine("Error: " + response.StatusCode);
            }
        }
    }
}

Another example can be found at - How to read and write a text file from sharepoint [^]

Re: Sharepoint

Kevin Marois8-Aug-23 12:22

Kevin Marois

8-Aug-23 12:22

That's awesome. Thank you

In theory, theory and practice are the same. But in practice, they never are.”
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.

Re: Sharepoint

Andre Oosthuizen8-Aug-23 22:22

.NET 7 C# 8: using new Interface "features" ?

8-Aug-23 22:22

You're welcome. If you think it it helps you out, please give a like, thanks Kevin.

BillWoodruff6-Aug-23 0:54

6-Aug-23 0:54

These changes make me wonder if using an abstract class doesn't already offer these facilities. Would you use them ? Don't these extensions contradict the "classic" model ? Your view ?

Quote:
1. Default Implementations: As mentioned earlier, interfaces can now have default implementations of methods. This allows you to add new methods to your interfaces without breaking existing implementations.

2. Static and Instance Members: Interfaces can now contain static methods, instance methods, and operators.

3. Private and Protected Members: Interfaces can now contain private and protected members. This can be useful for providing helper methods used by the default implementations.

«The mind is not a vessel to be filled but a fire to be kindled» Plutarch

modified 6-Aug-23 10:09am.

Richard Andrew x646-Aug-23 6:14

Richard Andrew x64

6-Aug-23 6:14

These features may make sense because in a sense, they now support multiple inheritance in .NET.

If interfaces can have methods and instance members, and you can derive from multiple interfaces, then that would be a pretty close approximation of multiple inheritance.

The difficult we do right away...
...the impossible takes slightly longer.

BillWoodruff6-Aug-23 6:29

6-Aug-23 6:29

Richard Andrew x64 wrote:
a pretty close approximation of multiple inheritance.

in a way abstract classes do not ?

«The mind is not a vessel to be filled but a fire to be kindled» Plutarch

trønderen6-Aug-23 10:03

trønderen

6-Aug-23 10:03

There must be ways to use abstract classes that I never thought of.

I never saw it as a multiple-inheritance mechanism. But I am a simple-minded soul.

OriginalGriff6-Aug-23 11:09

OriginalGriff

6-Aug-23 11:09

You can't multi-inherit abstract classes, but in all versions you can inherit from a base class and multiple Interfaces.
So adding default methods to Interfaces brings them a lot closer to a class and a fair impersonation of multiple class inheritance - remember that the only real difference between a "traditional" Interface and an abstract class is that the interface contains no code but enforces what you must implement, while the class provides methods and requires implementation.

It's useful, but ... just like var and dynamic it's wide open to abuse, and going to give problems when you inherit "lazy coder" apps.

Gerry Schmitz6-Aug-23 14:38

Gerry Schmitz

6-Aug-23 14:38

Sounds like one is "attaching" new behaviour versus simply inheriting it, or promising it. Component-based architecture.

"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I

BillWoodruff6-Aug-23 15:38

6-Aug-23 15:38

imho, this "new" Interface is a long way from Fowler and Brooch's classic concept, and "programming to the interface" philosophy.

«The mind is not a vessel to be filled but a fire to be kindled» Plutarch

harold aptroot6-Aug-23 20:55

harold aptroot

6-Aug-23 20:55

Perhaps, but I do find it to be a convenient place to put methods that can be implemented entirely in terms of the rest of the interface.

Richard Deeming6-Aug-23 22:12

Richard Deeming

6-Aug-23 22:12

BillWoodruff wrote:
an abstract class

That wouldn't work for structs, since they can't have a base class (other than ValueType/Object).

IIRC, the primary use-case for static members was to allow mathematical operations on generic types. And the vast majority of types you're going to want to use that on will be structs. Smile | :)

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

BillWoodruff7-Aug-23 5:58

7-Aug-23 5:58

i'm afraid i missed how 'structs came up, here.

«The mind is not a vessel to be filled but a fire to be kindled» Plutarch