Click here to Skip to main content

Submit your article

Visual Studio 2017

VS2017

Great Reads

Using Roslyn for Compiling Code into Separate Net Modules and Assembling them into a Dynamic Library

by Nick Polyak

Dynamically compile and assemble code snippets into a dynamic assembly

Deep Dive into OWIN Katana

by kusnaditjung

Web specification and framework

Slack Chatting with your rPi

by Marc Clifton

Talk to your rPi over a Slack channel, getting status, controlling devices, and running shell (bash) commands and viewing the console output posted back to your Slack channel

Build My Own 3D Graphics Engine Step By Step

by Mr. xieguigang 谢桂纲

How to build my own 3D graphics engine from ZERO step by step

Latest Articles

VSLauncherX - Better Recent List (and More) for Visual Studio

by Andreas Saurwein

Better recentlist, solutions and projects management for Visual Studio, not replacing the start window

Resize and Rotate Shapes in GDI+

by Andy De Filippo

Draw a shape-like editor implementing the use of anchors to resize and rotate a selection rectangle

Using Roslyn for Compiling Code into Separate Net Modules and Assembling them into a Dynamic Library

by Nick Polyak

Dynamically compile and assemble code snippets into a dynamic assembly

A Database Initialiser for SQLite and NPoco

by Private Dobbs

How to initialise a database and then automatically keep it up to date with version releases

All Articles

Visual Studio 2017

How do I create a viewer in C#?

30 May 2018 by #realJSOP

Your variable names need work. Calling a file name open is bad practice. It should be called something like filename. string filename = openFileDialog1.FileName; string content = string.Empty; try { using (StreamReader reader = File.OpenText(filename)) { content =...

VS2017 and preprocessor symbols

22 May 2022 by #realJSOP

I'm in the middle of working on a .Net Framework (4.7.2) app, and tried to use a library that had some preprocessor symbols in it to handle .Net framework vs .net core usage. I discovered that the built-in preprocessor symbols do not appear to...

How to resolve compiler warning C6001

10 Jul 2022 by 0x01AA

Not really a solution, but maybe a little help to confirm your doubts ... In case the warning is really exactly on the line if(values!= NULL) in the catch block, I'm with you, I don't see a reason for that warning. This because: In case values...

Universal SMTP Code to Send Emails in .NET Apps

8 Aug 2017 by Afzaal Ahmad Zeeshan, Iqra Ali

Since I wrote an article previously, I had been asked on various occasions to share the code on Yahoo! or Bing, etc. I wanted to write an article, with the code, which covers all of those vendors as well.

Why I am getting error in xamarin in visual studion 2017

17 Nov 2018 by Aitzaz Ahsan

Learning Entity Framework (Day 4): Understanding Entity Framework Core and Code First Migrations in EF Core

9 Oct 2018 by Akhil Mittal

Entity framework core, code first migrations and data annotations in EF Core

entity-framework

Continuous Integration and Deployment (CI/CD) of ASP.NET Core Application on Azure Web App using Jenkins – Day 4

28 Nov 2019 by Akhil Mittal

In this article, we’ll learn the CI/CD of ASP.NET Core application on Azure using Jenkins Azure Pipeline.

Continuous Integration and Deployment (CI/CD) of ASP.NET Core Application on Azure Web App using Jenkins – Day 3

28 Nov 2019 by Akhil Mittal

In this article, we’ll focus on Azure Active Directory and Service Principal and integrate Jenkins with Azure Service Principal before we move on to CI/CD of ASP.NET Core application on Azure using Jenkins Azure Pipeline.

Formify - Forms Made Fast

27 Dec 2018 by Alessio Aronica

Generate forms from MVC models in one simple line of code

Fast Binary Serializer with Compile-Time Members and Version Check

29 Oct 2019 by Alexander Lednev

This is a fast binary serializer with compile-time members and version check

Sprache.Calc: Building Yet Another Expression Evaluator

9 Mar 2019 by AlexeyYakovlev

This paper demonstrates a technique of building Sprache parsers using grammar inheritance.

VSLauncherX - Better Recent List (and More) for Visual Studio

27 Sep 2023 by Andreas Saurwein

Better recentlist, solutions and projects management for Visual Studio, not replacing the start window

Insert or update gridview row value with textbox value

12 Jul 2018 by Andrew Baylis

Two immediate problems: i) You check row by row and if that particular row doesn't match, you add a new row. ii) The adding a new row happens inside the iteration of the row collection - very bad move! Possible solution var found = false; foreach (DataGridViewRow row1 in dgvmaingrid.Rows) ...

Resize and Rotate Shapes in GDI+

9 Dec 2021 by Andy De Filippo

Draw a shape-like editor implementing the use of anchors to resize and rotate a selection rectangle

Data Visualizations And Bezier Curves

8 Aug 2018 by asiwel

Data modelling and visualization using longitudinal Bezier curves

machine-learning

data-visualization

CNTK Model Concurrency Demonstration

1 Oct 2018 by asiwel

How to Deploy Trained Models Concurrently

artificial-intelligence

machine-learning

How do I get my stored procedure call in MVC to return data?

30 Oct 2017 by Atlapure Ambrish

I would run SQL profiler and check what query/call is being fired when you call db.sp_docsstatus(true).OfType().ToList() The I would run the same query on DB manually and see still I am getting expected data/behavior.

I have a connection problem in C#

13 Nov 2018 by Aydin Homay

Hi, The information that you provided is not enough and to complicated. You are referring to several problems. Let`s make progress step-by-step. Follow my solution and leave comments I will read and change/improve the solution according to your progress until we get it solve. Ok? So first,...

C# Debug vs. Release Builds and Debugging in Visual Studio – from Novice to Expert in One Blog Article

19 Apr 2018 by Ben Hall (failingfast.io)

Most articles and documentation about the 'out of the box' C# Debug and Release build configurations were written prior to Roslyn. I take a fresh look at what you now get under the covers in 2018.

.NET-Compiler-Platform

Adding EntityFrameworkCore Support to .NET Core Project

13 Aug 2019 by Benktesh Sharma

Demonstrate how to add EF support in .NET Core project

entity-framework

How do I change the border colour of a textbox in C#?

4 May 2018 by BillWoodruff

1. Put a Panel on your Form, set its BackgroundColor property to the border color you want. Set the Panel's Padding property to the size of the border you want. 2. Paste the TextBox inside the Panel. Set its Dock property to Fill. You can manipulate the BorderStyle property of both Panel and...

What would be the for loop alternative for the following foreach loops?

29 May 2018 by BillWoodruff

Never try to modify an iterator variable; never try to modify a collection you are enumerating in the enumerator. If what you are after is an array of strings made from stripping line endings as you parse the lines of a file: 1. handle any style of line-break: char[] lineEndings = new...

How do I attach an image with my question?

6 Jan 2022 by BobbyStrain

Need help with VS 2017 project. What I have tried: I need to show the project file structure.

C++ Object Relational Mapping (ORM)- Eating the Bun - Part 1 of N

20 Apr 2019 by BrainlessLabs.com, sibani.p

Creating a simple ORM for C++ on-top of SQL database

C++ audio mixing and WAV file & AudioFile classes

8 Dec 2018 by CalicoSkies

Mixing audio from multiple WAV files to a single WAV file. Includes a C++ class for reading and writing WAV audio files, derived from an AudioFile class for future support of other audio file formats.

Data Virtualization using DataGrid

30 Oct 2018 by Carsten Breum

Data Virtualization example with a pagesize and async data request

VS 2017 forms corruption (all forms in project)

7 Oct 2019 by Charles T. Blankenship

This is beyond odd ... the following corruption has occurred to all of the forms files when I view a form in either Visual Studio 2012 and VS 2017. All of the controls on the form appears in the lower design area (I really don't know what that area of a VS2017 forms designer is so I cannot be...

Vs2005 <summary> can'ot show integrity(vs2005里面，方法的注释合起来之后，只显示...)

18 Jan 2018 by CHill60

Localisation of XML Summary Documentation is a known issue and there have been requests made for it to be incorporated into VS (I may be a little behind the times on this now) One solution is suggested here ... XML Comment Localization | Surviveplus.net[^] If that doesn't work for you there...

How can I get the count of stored icons into a file?

3 Feb 2018 by CHill60

I would create a new function (Single purpose and all that). You might be able to adapt the concepts on this CP article Extract icons from EXE or DLL files[^] (sorry it's C#) or this MSDN one Extracting Icons Using win32 API ExtractIconEx[^]

How do I embed a dictionary in visual basic?

6 Apr 2018 by CHill60

Check out these resources Cambridge Dictionaries Online API Developer Hub[^] Using Word's spellchecker in C#[^] How to: Programmatically Check Spelling in Documents[^]

How to add MS access 2007 driver as pre-requisiste in setup project

17 Dec 2018 by CHill60

A simple search found me this … How to include Access 2007 as a prerequisite[^]

Installed SQL server data tools still it neither shows up in the project templates nor in the start menu

17 Sep 2019 by CHill60

I found the following ssis - Is it possible to install SQL Server Data Tools in Visual Studio 2017 Community?[^] (despite the SSIS in the title it is actually referring to SSDT) It suggests that a complete reinstall of Visual Studio would be the solution. Another link suggests installing it...

Improve your code with visual studio

24 Apr 2020 by CHill60

I think what you are looking for are "Code Snippets" Have a look at Snippets in Visual Studio Code[^] Code snippets - Visual Studio | Microsoft Docs[^]

Reportviewer DLL's again

16 Jun 2020 by CHill60

In my comment I got the wrong component Win not Web d'oh. Here is the link to the Winforms 10.1358.0 package NuGet Gallery | Corrected.Microsoft.ReportingServices.ReportViewerControl.Winforms 150.1358.0[^] but note there is a more recent...

TicTacToe - MiniMax Without Recursion

12 Dec 2018 by Christ Kennedy

An exhaustive search of all game-states used to trace Mini-Max decisions from End game up through to Start game

artificial-intelligence

Sprite Editor 2019: My Little Gymnast

24 Jan 2019 by Christ Kennedy

Draw multiple sprites of different appearances with a single instance of classSprite

WPF IValueConverter/IMultiValueConverter Helper Class

2 Apr 2018 by Clifford Nelson

Presents a class to help create flexible value and multi-value converters that use the ConverterParameter to specify return values for true and false results using the ?: operator

WPF Exclusive CheckBox Behavior with GroupName

17 Oct 2017 by Clifford Nelson

A Behavior is presented that will ensure that only one CheckBox (ToggleButton) will be checked with the same GroupName within the visual tree of the control to which this behavior is attached.

WPF Behavior to close a Popup with MouseLeave

3 Apr 2018 by Clifford Nelson

Normally a popup will stay open until explicitly closed. The Behavior will close the Popup if the mouse is clicked within or outside the Popup area or leaves the Popup area.

WPF Behavior to Ensure a ToggleButton/CheckBox is Selected

4 Apr 2018 by Clifford Nelson

This behavior will require that for any Group of ToggleButton/Checkbox controls that are associated together, the user cannot set all to not IsChecked.

Why this code works in visual studio 2017 even when I used return statement with digit something different than zero?

18 Jul 2018 by CPallini

Quote: it is said that in return if we put 'return 0' this means that code is alright and if we put any other integer that means there is some problem. That is true, but is just a convention. On process termination, you have to explicitely request the OS for the return code, in order to check...

I started the simplest of C projects in visual studio and it fails

19 Feb 2019 by CPallini

Embedding Python is not the simplest C project. You have to carefully follow the steps presented in a up-to-date tutorial.

Azure web service and crystal reports nightmares !

15 Jun 2018 by D6Designs

Hi All ... My first post so please bear with me .... I have VS 2017 Pro 64 bit on and 64bit PC trying to publish a web app to an Azure Web Service with CR 13.0.3500.0 ... have problem after problem .. the usual set of Could not load file or assembly CrystalDecisions.ReportAppServer.CommLayer...

Azure web service and crystal reports nightmares !

15 Jun 2018 by D6Designs

Thanks for the pointer. I checked and yes I can see not everything is going up. It's become obvious I can't do this with a web service as there's no way of installing the run time so i've had to go to a cloud service with storage and now all working. :)

An issue with cstring with MFC based dialogs migrating from VS 2008 32 bit to VS 2017 64 bit

1 Aug 2019 by D_code_writer

Hey Guys, I have an interesting question regarding migrating a 32 bit MFC project on VS 2008 to 64 bit on VS 2017. The problem revolves around the following example code CMyDialog *dlg; CString myString; dlg = new CMyDialog(NULL); myString = _T("test"); dlg->m_dlg_string = myString; ...

An issue with cstring with MFC based dialogs migrating from VS 2008 32 bit to VS 2017 64 bit

1 Aug 2019 by D_code_writer

Hey Guys, I figured out a work around that worked. Where it fell down in the was the assignment in the variables. Getting them from the dialog was fine. Here is the code snippet, CMyDialog dlg; CString MyString; MyString = _T("test"); dlg.SetState_m_dlg_string(MyString) // Write a void...

How do I call the main function in C#?

3 May 2018 by dan!sh

You do not explicitly call Main method. That is the default entry point for your application which framework will call. The errors you have mentioned tell that there nothing called PdfSloutions.Form1. Either there is nothing called Form1 in that namespace or if it is, it not public.

VS 2017 setup deployment package failing

9 Jan 2019 by danash

--Trying to build a setup project with VS 2017. I'm getting 3 dialog boxes showing, Microsoft SQL Server 2008 Management studio Please Wait While Windows Configures Microsoft SQL Server Management Studio 2008 --Then this dialog flashed up Microsoft SQL Server 2008 Management studio 0:Watson...

VS 2017 setup deployment package failing

9 Jan 2019 by danash

The Solution. I went ahead and uninstalled every mention of SQL Server 2008 from my system. After scratching my head for a loooong time I noticed the one dialog box that stated. Microsoft SQL Server 2008 Management studio 0:Watson 1:1304 2 Stream SupportFiles 3:streamBinary ToDisk 4.5...

How do I prevent my VB.NET output (.exe) file from being copied?

11 Apr 2018 by DanielBrownAU

Short version: You can’t (Well not easily and not worth the time) A possible solution could be to have a 'home base' server which the client software can communicate with and check if it is a valid install/license. If not, the software could disable itself or if the install is valid, continue...

Build an ASP.NET Wiki to Explain TDD

17 Nov 2018 by Daniele Fontani

TDD & BDD explained with examples

What to do with existing installshield LE projects in VS2017?

6 Dec 2017 by Dave Kreskowiak

Only InstallShield is going to open up those older projects. You can get InstallShield Express from here[^]. Keep in mind, it's not free but a trial.

Visual studio 2017 textbox text displaying incorrectly during run time.

13 Jun 2018 by Dave Kreskowiak

If this is just the standard TextBox and you didn't create your own or add your own painting code, it's not a bug in the TextBox. This looks more like a problem with your video card driver.

I draw lines on the desktop and want to remove the old ones to make a rotation look in lines?

8 May 2019 by Dave Kreskowiak

If your code is drawing the lines, you have to constantly update the positions of the endpoints of the lines and redraw the lines using these new values. There is really no such thing as "erasing" those lines. You have to draw the area under where you drew your lines and then draw your new...

How do I code a many to one datagridview

13 Apr 2021 by Dave Kreskowiak

You never mentioned what line throw the exception. The problem is you're assuming something has a valid object when it doesn't. You're creating a new DataAdapter, but you never set up the SelectCommand with a connection object. Just opening...

Print VS form showing control names

27 Jun 2022 by Dave Kreskowiak

There is no built-in option to do that. I don't know of any extension to VS that would do that. At the very least, you'd have to write the extension to do that yourself.

VS 2017 windows forms - back button remember last data in textboxes

18 Oct 2023 by Dave Kreskowiak

private void Back_Click(object sender, EventArgs e) { Form1 back1 = new Form1(); back1.Show(); this.Hide(); } Assuming this is the code that's called when you click the back button in your app, your code is creating a new instance of...

Visual studio 2017 windows forms C# - password from windows user password

3 Nov 2023 by Dave Kreskowiak

Like Richard already said, I told you how to validate credentials against the machines local account database that does not use shelling out to "NET USE". It is not called "in Windows services". That phrase means something completely different...

Visual studio 2017 windows forms C# - password from lusrmgr.mfc

30 Oct 2023 by Dave Kreskowiak

An "admin license," whatever that is, has nothing to do with this. You're completely misunderstanding the Windows security system and directory. You cannot check an entered password against what you perceive to be a plain text password in the...

Asynchronous Multicast Callbacks in C

29 Jan 2019 by David Lafreniere

Simplify passing data between threads with this portable C language callback library.

A Fixed Block Memory Allocator in C

24 Dec 2018 by David Lafreniere

Unique allocator features improve performance and protect against heap fragmentation faults on any C or C++ project.

Month-Name Ordering

18 Sep 2017 by David Wincelberg

Sort by month name in database tables, filenames or strings

When database created in ASP.NET CORE 1.1 code first in visual studio 2017

29 May 2017 by David_Wimbley

The following comments are what i've seen in my experience. Quote: I made my model classes and AppContext class for Database, but my Database created only when i made Migration, Your database gets created when you take an action against the DB. For example, simply running your application...

Error when I want to deploy SSIS package in vs 2017

21 Aug 2021 by Davood Riazi

Hi, When I want to deploy the SSIS package in vs 2017 and I got the below error message. Can someone guide me on how to resolve this issue? Thanks, TITLE: SQL Server Integration Services ------------------------------ An error occurred during...

Error when I want to deploy SSIS package in vs 2017

21 Aug 2021 by Davood Riazi

I solved the problem : fist I renamed the SSIDB database to SSIDB2 as below script : USE SSISDB GO ALTER DATABASE SSISDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO ALTER DATABASE SSISDB MODIFY NAME = SSISDB2 GO ALTER DATABASE SSISDB2 SET...

How do I code a many to one datagridview

13 Apr 2021 by Derek Carpenter 2021

I have declared two table. One is called Artists and has columns like ArtistID, ArtistDisplayName, ArtistFirstName etc. The second table is called MusicBoxsets and has columns like MusicBoxsetIndex, MusicBoxsetArtistIndex etc ...

C#: Integer Range Helper

2 Jun 2019 by DiponRoy

Utility class and model to manage range related operations

My Favorite Filter Queries SQL, C#, Entity Framework, Lambda Expression

15 Jul 2019 by DiponRoy

Conditinal filter query example in SQL, Lambda Expression, C#

entity-framework

How do I assign a foreach iteration variable?

27 May 2018 by Dirk Bahle

You have to use an equivalent for (int i=0; i

A Custom WPF ScrollViewer

7 Dec 2018 by Dirk Bahle

Making better use of the available UI space.

Visual Studio Design Patterns Add-in/Extension

3 May 2017 by dmihailescu

A Visual Studio add-in that inserts some commonly known OO patterns into your working project and searches your highlights online.

Reportviewer DLL's again

15 Jun 2020 by dnibbo

Hi Does anyone know where I can download the latest reportviewer.winforms dll? I have to .common dll v15.0.0.0 but cant find the winform one to go with it. It does not appear to be in nuget! Thanks What I have tried: googled as always, tried...

The "SMAT" Subsystem for C++

6 Apr 2020 by Doctor Autonomy

A surprisingly easy way to avoid memory leaks with new/delete allocations in C++

How to add MS access 2007 driver as pre-requisiste in setup project

17 Dec 2018 by DoingWork

I want to Add MS Access Driver x64 and x86 in Pre-Requisite list for Setup Project in Visual Studio. What I have tried: I have already installed drivers but they don't show in Pre-Requisite List

How to read/write data to serial port in xamarin.android ?

20 Apr 2023 by DoingWork

Dear All I am new in Xamarin.Android A device is connected to My Android smart phone using OTG function. I want to access it via Serial port by Xamarin c# (Visual Studio 2017). Please guide me. Thanks in Advance for your help What I have tried: I have read topics on UsbManager, UsbDevice and...

CQRS - Hosting an Event Sourcing System on Microsoft Orleans

20 May 2017 by Duncan Edwards Jones

How Microsoft Orleans can facilitate a very highly scalable CQRS and event sourcing based system

Simple Event Sourcing Demo in C#

24 Oct 2017 by Emmanuel Nuyttens

Example on how to use Event Sourcing in C#

Visual studio 2017 crash on startup show some dependent package error

31 May 2018 by Er. Puneet Goel

When I am trying to launch VS 2017, is throwing some missing package error stating "Something went wrong". Error Log: [2544:0006][2018-06-01T11:21:08] Error 0x80131500: The dependent package of 'Microsoft.VisualStudio.Product.Enterprise,version=15.7.27703.2018' cannot be found:...

Visual studio 2017 crash on startup show some dependent package error

31 May 2018 by Er. Puneet Goel

T wasn't able to launch or Repair but after a long and exhausted research, I silly thing worked for me. I choose to modify option and then again modify to repair selected packages. Once Done everything looks good.

Flexible C# Command Line Parsing via Attributes

4 Apr 2018 by Eric Lynch

A flexible command line parsing class that uses C# attributes and reflection to discover syntax

How do I load and convert multiple XML files from a folder?

15 May 2018 by F-ES Sitecore

Use DirectoryInfo.GetFiles to access files based on filename. https://msdn.microsoft.com/en-us/library/4cyf24ss(v=vs.110).aspx

How do I use trim for datagrid in C#?

16 May 2018 by F-ES Sitecore

You can only "Trim" on a string variable, the error you are getting suggested that "Value" is an object. How you deal with this depends on what is in the cell. The solution might be SourcePageFile = SourceFolder + "\\pg-" +...

How to create onclick event for ASP.NET button in C# ASP.NET code behind visual studio 2017

26 Nov 2018 by F-ES Sitecore

You have to make sure you attach to the click event on page load. In fact you'll probably have to do all of your ButtonFinish code on page load // Make sure this code is in your page_load event. Also give the button an ID Button ButtonFinish = new Button() { Text = "Finish" };...

Dropdown list didn't show data in partial view view in ASP.NET MVC 5 vs 2017

31 Dec 2018 by F-ES Sitecore

The issue in your code as posted is that your partial view is iterating through a SelectList so "item" is going to be a SelectListItem. You then access "value" and "text" @item.text However the proper properties are "Value" and "Text", and c# is case...

C# Knob Control using Windows Forms

11 Dec 2019 by Fabrice Lacharme

Yet another Knob Control in C#

Fast and Practically ‘perfect’ Partition Problem Solution

1 Nov 2018 by Fedor Naumenko

A combined solution of the generalized partition problem, which allows to quickly get the good quality result

Angular Fundamentals - Building an Angular 7 Application with .NET Core 2.2 (Global Weather) - Part 1

5 Feb 2020 by Fred Song (Melbourne)

Demonstrating a series of Angular fundamentals through an Angular 7 application.

Angular 7 with .NET Core 2.2 - Global Weather (Part 2)

10 Mar 2019 by Fred Song (Melbourne)

Angular 7 with .NET Core 2.2 - Global Weather (Part 2)

Creating a Visio Add-In in VS2017

4 Mar 2018 by Gaston Verelst

How to create a Visio Add-in in VS2017

Office-Automation

Creating Multiple Identical VMs in Microsoft Azure

27 Jan 2019 by Gaston Verelst

In this post, I show how to create an image from a VM in Microsoft Azure, and use this to create identical VMs.

Tic Tac Toe Using AI –The Easy Way

27 Jan 2019 by George Swan

A simple invincible implementation of Tic Tac Toe

artificial-intelligence

How to Make a Sliding SplitView in UWP (C#)

9 Oct 2017 by Georgeutc

Adding sliding functionality to UWP XAML SplitView

Expression-blend

C# visualstudion windows form graphics chart

15 Mar 2019 by Gerry Schmitz

Looks like your "chart" is going "out of scope" if you created it "by code" as above. Define your chart "at the class level" as a "private or public" member so that different parts of your program can "see" chart and not just the method that first created chart (as a "local" variable).

C# one form two tables

1 Oct 2020 by Gerry Schmitz

Where you have "loadResult", you just have a "result"; representing either "load" or "history" (#3) Then you have 2 public methods: one that takes a "load number" (#1) and another that takes a "history number" (#2). You call #1 or #2 depending...

I have timing issues in C# and EWS

1 Aug 2017 by Graeme_Grant

Just another thought, without knowing if the app and the storage server are in remote locations to each other, or are on the same server, it could be simply a network lag issue causing a transient issue. If the two are remote to each other, then you may need a better retry mechanism. Here is a...

Trouble with clickonce

5 Apr 2019 by Graeme_Grant

I have written an article on this topic. Hope it helps: Silent ClickOnce Installer for Winform & WPF in C# & VB[^]

C# Poisson Cumulative Distribution for large Lambdas

8 Apr 2020 by Gunnar S

Implementation of the Poisson Cumulative Distribution function for large Lambdas

Xamarin Forms: Check and Request for Permissions

11 Jan 2019 by Harshit Gindra

Check and request for Permissions in Xamarin Forms mobile application

C# windows form SQL dateadd et like

26 Feb 2019 by Herman<T>.Instance

IF a DATE-field IS NULL it cannot be a filled date. SO the filled dates are excluded in your WHERE clause Perhaps: AND (Date_MES IS NULL OR Date_MES BETWEEN (DATEadd(dd, -7, CAST( date1 As DAteTime) AND CAST( date1 As DAteTime)) as part of your query