WPF C# DataGrid Column Sort

 

Create new vue js with task Runner Razor MVC

Create new Project.

In the root of the project create the following files:
– webpack.config.js
– package.json

package.json (replace the default values within <<>>)

webpack.config.js

Open cmd and in the directory where package.json file is located. Run the following npm install

Add the following in the _layout.vbhtml file.

Now in visual studio Select ‘View’ -> ‘Other Windows’ -> ‘Task Runner Explorer’. Just run the ‘Run – Development’ task. Can even build while project is running.

Clear sql buffer and cache

Numbers Table

Reference parent datacontext binding.

Rebuild indexes

Wrong threads crash

Put the following in the viewmodelBase

Example call

Adding a foreign key

Adds foreign key in tblDisplay for lnkclientID which exists in tblClient as IDClient

 

Adding weak Link

Adds a weak link (lnkAddressID) between tbl_SUB_SubscriptionContract and tbl_SUB_Address. Conditions accepted:

– ID has to exist in tblAddress

– 0 values accepted

 

DateAdd

The DateAdd() Functions adds/subtracts a specific interval to a specified date

 

Example:

Using the DateAdd function in a loop to add 1 month to each date