SQL Code: Transfer values to another column
16.11.2021 1137
Transfer the data
of an existing column to another column via SQL command
SQL script
USE [Demo]
GO
SQL Server Script for adding columns with data preservation
16.11.2021 993
How to add a
table with a column in SQL Servers without deleting the inventory data?
Adding Single
Columns
ALTER
Error starting des Debug Asp Core Projects
04.11.2021 2751
Error
message:
The project doesn't know how to run the profile
Solution:
Select in the new Debug Profile a real Value like IIS Express, IIS or Project
Microsoft Visual Studio: when try to debug on ASP Core, Asp Net on local
IIS Server
Windows 11 does not run on AMD processors older than 2 years
16.10.2021 1023
This PC
does not currently support the system requirements of Windows 11
The
processor is not currently supported for Windows 11
Processor: AMD Ryzen 7 1800X Eight-Core Processor
TMP 2 0 is ok
Dynamically exchange URL parameters with new value in the browser
14.10.2021 20434
The following
code in javascript exchanges the displayed URL of a web page at runtime by
adjusting the parameter with an input field
Javascript,
Browser URL, Parameter, Query
Javascript code:
function onVal
Excel code to turn the filter on and off after a cell
09.10.2021 1202
Small Excel
macro, with which you can automatically filter for the active cell via keyboard
To do this,
simply copy the code into the staff
Step 1: Alt+F11
->vba Code
Step 2: Left pane
Project >VBAProject (PERSONAL XLSB)
Step 3: Copy the
code here and paste it into the Module Module1 folder
Linq Query Linq Query: Create multiple AND and OR in one query
07.10.2021 3825
This C# code
shows how to merge a SQL Server table with LINQ according to multiple AND
conditions and multiple OR conditions
Example Linq EF
Code
C# Code EF
Entity Framework, API Controller in asp net core MVC
LINQ: Creating Multiple OR Subqueries in a WHERE Condition
07.10.2021 2463
The following
LINQ statement filters data in a Linq query with sub-sets
The filter is
referred to subqueries with ANY(value in Subdata)
Technically, this
solution also corresponds to a ForEach query, in which an OR filter is set up
in the WHERE (Filter=A OR Filter=B)
LINQ: ForEach Loop in Linq Query to create WHERE or subqueries
07.10.2021 19533
Code example for
creating multiple WHERE conditions in a LINQ query
Here it is shown
how to integrate a multiple AND link into a LINQ SQL text
this prevents
many individual queries from being sent to the sql server but only a single sql
query that combines the where condition with and into several simple
subconditions
Linq C#
Subqueries, ForEachLoop, Entity Framework EF to SQL Server
Example to upload data on javascript to asp mvc api
06.10.2021 3176
The following example shows howto upload data to an API in an Asp Core
MVC application
In ASP Core, an API (POST) is created in the controller, and in the ASP
View at runtime in the client via javascript and jquery ajax the api is called
and data is passed
|