Take a look at the right-top corner of solution explorer. There's a message: "This project is targeting a version of .NET which is not installed" Install proper .net framework and error should gone. [EDIT] You can also downgrade .NET version to project. See: [Timed out while connecting to named pipe. Please help me? - Microsoft Q&A](https://learn.microsoft.com/en-us/answers/questions/849109/timed-out-while-connecting-to-named-pipe-please-he)

This member is spammer: [Member 16154777 - Professional Profile](https://www.codeproject.com/script/Membership/View.aspx?mid=16154777) Take a look here: [How can I sum datagrid same values in group](https://www.codeproject.com/Questions/5269868/How-can-I-sum-datagrid-same-values-in-group) - solution #2.

[19001601049 SAVITA - Professional Profile](https://www.codeproject.com/script/Membership/View.aspx?mid=15571652) Here is the "answer": [How to remove all the null key and null values from array in java](https://www.codeproject.com/Questions/5327521/How-to-remove-all-the-null-key-and-null-values-fro)

[Member 15541592 - Professional Profile](https://www.codeproject.com/script/Membership/View.aspx?mid=15541592)

Maybe this is a good moment to change that. Please...

Thank you, Paul for explanation.

Is there any chance to remove spam content from this thread: [Visual basic 6 check if DLL exists](https://www.codeproject.com/Questions/5325353/Visual-basic-6-check-if-DLL-exists)? Tons of spammy comments makes this thread unreadable. Note: i'm not talking about spammer, but his comments!

If you would like to get "working" doublebuffered datagridview component, you can download necessary files from this repository: [GitHub - losmac/DoubleBufferedDataGridView: DataGridView (DoubleBuffered = true)](https://github.com/losmac/DoubleBufferedDataGridView) Good luck!

Seems, you don't understand what this code is doing... Please, read about [Inheritance - C# Programming Guide | Microsoft Docs](https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/classes-and-structs/inheritance) and [Polymorphism - C# Programming Guide | Microsoft Docs](https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/classes-and-structs/polymorphism) Tip: Go to the designer of Main class. Find 2 lines of declaration of dataGridView1:

this.dataGridView1 = new DataGridView();
//and
private DataGridView dataGridView1;

Above code means that you've created an instance of standard DataGridView. But(!) you need to create an instance od myDataGridView!

this.dataGridView1 = new myDataGridView();
//and
private myDataGridView dataGridView1;

For further details, please see: [Inherit from Existing Controls - Windows Forms .NET Framework | Microsoft Docs](https://docs.microsoft.com/en-us/dotnet/desktop/winforms/controls/how-to-inherit-from-existing-windows-forms-controls?view=netframeworkdesktop-4.8) Good luck!

Based on this piece of code you provided, i can't tell you what is wrong. If you replaced your DataGridView control with myDataGridView, you should be able to use DoubleBuffered. An alternative... [How to: Reduce Graphics Flicker with Double Buffering for Forms and Controls - Windows Forms .NET Framework | Microsoft Docs](https://docs.microsoft.com/en-us/dotnet/desktop/winforms/advanced/how-to-reduce-graphics-flicker-with-double-buffering-for-forms-and-controls?view=netframeworkdesktop-4.8) [Control.SetStyle(ControlStyles, Boolean) Method (System.Windows.Forms) | Microsoft Docs](https://docs.microsoft.com/en-us/dotnet/api/system.windows.forms.control.setstyle?view=net-5.0)

Take a look at this article [Double Buffering a DataGridview](https://www.codeproject.com/Tips/654101/Double-Buffering-a-DataGridview) to find out out how to enable DoubleBuffered.

This was very strange. I tried to open OG's tip on Firefox and MS Edge. Both with the same result... I tried to use CTRL+F5, but it didn't help in FireFox. So, finally i followed by this instruction: [How to clear the Firefox cache | Firefox Help](https://support.mozilla.org/en-US/kb/how-clear-firefox-cache)

There's something wrong with link to OriginalGriff's tip: Transferring information between two forms, Part 2: Child to Parent Check the link: [Transferring information between two forms, Part 2: Child to Parent](http://www.codeproject.com/Tips/548131/Transferring-information-between-two-forms-Part-2-C) When you click on it, you'll be "transferred" to 404 Spoon not Found site:

Quote:

Do not try and find the page. That’s impossible. Instead only try to realise the truth

I'm using it quite often while answering QA questions. Can you fix it? BTW: other tips about transferring data between forms are OK.

[Member 14953686](https://www.codeproject.com/script/Membership/View.aspx?mid=14953686) He's posting answers with no content! See: [Member questions & answers](https://www.codeproject.com/script/Answers/MemberPosts.aspx?tab=answers&mid=14953686)

Not sure... User can be inactive for few weeks or his activity can be "normal" per week, then he start posting spamm/troll/abusive content...

Based on activity of [Member 14953681](https://www.codeproject.com/script/Membership/View.aspx?mid=14953681) i'd suggest to re-open discussion about IP lock or captcha verification for persons who post many comments/answers in a some interval of time. This member has posted much over 300 answers in 3 threads! There must be some way to lock such of spammers.

I think you're trying to resolve your issue by complicating it too much... ;) Note, that Count can accept condition to get interesting data (which works like Where). See: [Enumerable.Count Method (System.Linq) | Microsoft Docs](https://docs.microsoft.com/en-us/dotnet/api/system.linq.enumerable.count?view=netcore-3.1#System\_Linq\_Enumerable\_Count\_\_1\_System\_Collections\_Generic\_IEnumerable\_\_\_0\_\_) So...

var finalTotal = from t1 in _context.Apiapplicant
join t2 in _context.ApiApplicantHistory on t1.Id equals t2.ApiApplicantId
join t3 in _context.EntityType on t2.LastReqStatus equals t3.Id
where t1.IsDeleted == false && t2.Date != null && t1.ApiRequestNo != null
group t1
by new
{
lastReq = t2.LastReqStatus,
Year = t2.Date.Substring(0, 4),
Month = t2.Date.Substring(5, 2)
} into g
select new
{
Year = g.Key.Year,
Month = g.Key.Month,
lastReq = g.Key.lastReq,
Granted = g.Count(x=>x.t2.Name == "granted"),
Other = g.Count(x=>x.t2.Name != "granted"),
TotalCount = g.Count()
};

Sorry, but you wrote that every client application is opened on client machine. You don't have to care about other clients. So, if a single instance of client application is running on client machine, you can close it via updater. You don't even need to write custom updater. See: [How to: Specify the Location Where End Users Will Install From - Visual Studio | Microsoft Docs](https://docs.microsoft.com/en-us/visualstudio/deployment/how-to-specify-the-location-where-end-users-will-install-from?view=vs-2019) Here is interesting alternative: [Simple Auto-Update: Let your application update itself using 2 lines of code](https://www.codeproject.com/Articles/731954/Simple-Auto-Update-Let-your-application-update-i)

If you want to update only client application, the number of users connected to the database is not important. Does updater have to update database too?

This member: [Member 14857046 - Professional Profile](https://www.codeproject.com/script/Membership/View.aspx?mid=14857046) has posted over 20 spammy comments to this question: [Sql QUERY the salary of employee dealing with customer having id=4 has been doubled](https://www.codeproject.com/Questions/5261055/Sql-QUERY-the-salary-of-employee-dealing-with-cust)