Catatan

Tunjukkan catatan dari 2022

C# An established connection was aborted by the software in your host machine

Imej
  The logic behind this error WSAECONNABORTED - An understandable explanation. -  https://www.chilkatsoft.com/p/p_299.asp Wikipedia Winsock -  https://en.wikipedia.org/wiki/Winsock Stackoverflow -  https://stackoverflow.com/questions/14304658/c-sharp-an-established-connection-was-aborted-by-the-software-in-your-host-machi

Server AC Recovery

PowerEdge Server : AC Recovery Last Power State Behavior - https://www.dell.com/support/kbdoc/en-my/000136861/poweredge-server-ac-recovery-last-power-state-behavior

Epoch & Unix Timestamp

Imej
  Epoch & Unix Timestamp Conversion Tools -  https://www.epochconverter.com/ How could I convert data from string to long in c# -  https://stackoverflow.com/a/51739602 How do you convert epoch time in C#?  -  https://stackoverflow.com/questions/249760/how-can-i-convert-a-unix-timestamp-to-datetime-and-vice-versa -  https://stackoverflow.com/a/2883645

Save config in Register Editor

  How to read value of a registry key c# - https://stackoverflow.com/a/18234755 How to add, modify, or delete registry subkeys and values by using a .reg file - https://support.microsoft.com/en-us/topic/how-to-add-modify-or-delete-registry-subkeys-and-values-by-using-a-reg-file-9c7f37cf-a5e9-e1cd-c4fa-2a26218a1a23

SQL Update with INNER JOIN

  Example query: update [signalling].[dbo].[Lokasi] SET eventLocation = s.qEventLocation  FROM [signalling].[dbo].[Lokasi] AS l  INNER JOIN [syncdb].[dbo].[stations] AS s ON s.stationname = l.station;

Encryption and Decryption in C#

References:  Encryption and Decryption in C#  - https://sankhadip.medium.com/encryption-and-decryption-in-c-f2de3d802e1d#:~:text=The%20Advanced%20Encryption%20Standard%2C%20or,to%20encrypt%20and%20decrypt%20messages. Encryption And Decryption Using A Symmetric Key In C# - https://www.c-sharpcorner.com/article/encryption-and-decryption-using-a-symmetric-key-in-c-sharp/ Public Key Encryption - https://www.tutorialspoint.com/cryptography/public_key_encryption.htm

LARAVEL 9

  How to Install Bootstrap in Laravel 9? https://medium.com/@laraveltuts/how-to-install-bootstrap-in-laravel-9-ef36be699bb6 How to Install Bootstrap 5 in Laravel 9 With Vite https://techvblogs.com/blog/how-to-install-bootstrap-5-in-laravel-9-with-vite Laravel Database Migration https://laravel.com/docs/9.x/authentication#starter-kits Laravel Authentication https://laravel.com/docs/9.x/authentication#starter-kits

Cannot connect WiFi. Network card fully utilized.

Imej
The problem: The machine denies connecting with WiFi. The Solution: Reset the log and disconnect the network using step as below; 1. Type netstat -a to check the network loopback. 2. Stop any application that uses the network card such as Apache XAMPP, IIS Server, MSSQL, or MySQL. Also, need to stop any services that used the network activity such as ping, and connect to the server. *Note: loopback can be monitored through Wireframe. *Note: If the machine has installed Docker Desktop, we need to stop the services. 3. Open a command prompt and type ipconfig /release to clear the established connection. 4. Type ipconfig /renew to renew the connection. 5. Okay done.

Eclipse - "Incompatible JVM. Version 1.8.0_261 of the JVM is not suitable for this product. Version: 11 or greater is required"

Imej
Error: Eclipse - "Incompatible JVM. Version 1.8.0_261 of the JVM is not suitable for this product. Version: 11 or greater is required" Solution:  https://stackoverflow.com/a/72326988/10763264 Step - 1 Go to the file location of the eclipse and open  eclipse.ini  in editable format Step - 2 Go to the java folder location where you find javaw.exe In my case :  C:\Program Files\Java\jdk-11.0.11\bin\javaw.exe Step - 3 Then paste the following before tag  -vmargs  inside  eclipse.ini  file -vm C:\Program Files\Java\jdk- 11.0 .11 \bin\javaw.exe The below image shows in brief

Error : mysql xampp Can't create IP socket: No such host is known.

Imej
Error :  Solution 1: Edit phpmyadmin config.inc.php File dir : C:\xampp2\phpMyAdmin\config.inc.php $cfg['Servers'][$i]['host'] = '127.0.0.1' Solution 2: Check windows host  File dir : C:\Windows\System32\drivers\etc\hosts

Response.redirect raises "Thread was being aborted"

Imej
The Problem: The redirect code shows runtime error "Thread was being aborted" Solution : Response.redirect raises "Thread was being aborted" - https://stackoverflow.com/a/4874895/10763264 HttpResponse.Redirect Method

FORCE TO OPEN .NET APPLICATION AS ADMINISTRATOR

  References :  https://stackoverflow.com/questions/2818179/how-do-i-force-my-net-application-to-run-as-administrator

MSSQL Timeout expired. Max pool size was reached.

Imej
mssql 'Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.' Solutions:  1)  How can I solve a connection pool problem between ASP.NET and SQL Server?  https://stackoverflow.com/questions/670774/how-can-i-solve-a-connection-pool-problem-between-asp-net-and-sql-server 2) SQL Server Connection Pooling (ADO.NET)   https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql-server-connection-pooling#adding-connections 3) d

Wireshark Dark Mode

Imej
How to open Wireshark in Dark Mode. Download the latest Wireshark software. Open a command prompt and type this command  "C:\Program Files\Wireshark\Wireshark.exe" -platform windows:darkmode=2   Yay! Wireshark Dark Mode References: 

IoT Arduino IDE - ESP32

Imej
References: Installing the ESP32 Board in Arduino IDE (Windows, Mac OS X, Linux) https://randomnerdtutorials.com/installing-the-esp32-board-in-arduino-ide-windows-instructions/

Create minimal WEB API ASP.NET

Imej
Tutorial: Create a minimal web API with ASP.NET Core https://docs.microsoft.com/en-us/aspnet/core/tutorials/min-web-api?view=aspnetcore-6.0&tabs=visual-studio Use a database with minimal API, Entity Framework Core, and ASP.NET Core https://docs.microsoft.com/en-us/learn/modules/build-web-api-minimal-database/?wt.mc_id=academic-0000-chnoring Return value JSON or XML format JSON and XML Serialization in ASP.NET Web API https://docs.microsoft.com/en-us/aspnet/web-api/overview/formats-and-model-binding/json-and-xml-serialization Deploying Web API ASP.NET Quickstart: Deploy an ASP.NET web app https://docs.microsoft.com/en-us/azure/app-service/quickstart-dotnetcore?tabs=net60&pivots=development-environment-vs The .NET Core Hosting Bundle https://docs.microsoft.com/en-us/aspnet/core/host-and-deploy/iis/hosting-bundle?view=aspnetcore-6.0 Publish .NET 5 Web API on IIS || .NET Core Hosting on IIS

Android TV & PC stick

Imej
PCG02 GLE Fanless PC Stick Intel Gemini Lake J4125 Windows 10 Pro https://store.mele.cn/collections/pc-stick/products/pcg02-gle-fanless-pc-stick-intel-gemini-lake-j4125-windows-10-pro?variant=41993279537330

ASP.NET C# Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed.

Imej
The Error: <asp:AsyncPostBackTrigger ControlID="Timer1" /> The Solutions: Change  <asp:AsyncPostBackTrigger ControlID="Timer1" /> to  <asp:PostBackTrigger ControlID="Timer1" /> Reference Solution: https://social.msdn.microsoft.com/Forums/en-US/cc3f69ee-6634-4f2c-ab97-0427825ce0e4/syswebformspagerequestmanagerparsererrorexception-the-message-received-from-the-server-could-not?forum=aspwebforms#:~:text=WebForms.-,PageRequestManagerParserErrorException%3A%20The%20message%20received%20from%20the%20server%20could%20not%20be,or%20server%20trace%20is%20enabled.

Add ProjectInstaller in Windows Service

Imej
How to create ProjectInstaller.cs class in Windows Service? On Solution Explorer, Go to Service1.cs and double click on the file to open the design view. Right-click in the Design View box and select Add Installer. The class will be generated as below. Click on serviceProcessInstaller1. Set Account : LocalSystem Build the application.

Transaction (Process ID 111) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

What's Deadlock in SQL Server? -  https://debug.to/951/transaction-was-deadlocked-on-lock-resources-with-another-process How to fix SQL Server deadlocks -  https://www.red-gate.com/products/dba/sql-monitor/resources/articles/monitor-sql-deadlock Transaction (Process ID) was deadlocked on lock resources with another process and has been chosen as the deadlock victim -  https://social.msdn.microsoft.com/Forums/en-US/0337e7ea-fc82-4cc2-8ce9-f8d3e04042e8/transaction-process-id-was-deadlocked-on-lock-resources-with-another-process-and-has-been-chosen?forum=aspsqlserver

How to log data to the Windows Event Log in C#

if (!EventLog.SourceExists(sSource)) {       EventLog.CreateEventSource(sSource, sLog); } Rujukan:  How to log data to the Windows Event Log in C#

WMPLib Media Player

Imej
Failed to AxHost. System Reflection Solution: Remove AxWMPLib and WMPLib references. Remove Media Player from Toolbar Close the tab windows. Rebuild the project. Go to Manage NuGet Package to download the new WMPLib to replace the corrupted WMPLib. Rebuild the application, add a media player on the toolbar and now we can drag and drop the media player to windows. References: https://social.msdn.microsoft.com/Forums/windows/en-US/c2a286ed-6973-4cd4-a2c7-79e5f784b71a/error-on-visual-studio?forum=winforms

Can't open IIS Manager even the service is running perfectly

Imej
 Change Run Setting to Maximized Open IIS as Administrator. On the taskbar, right-click and open Properties. Go to tab Shortcut, change Run to Maximized . Apply the setting.   Done Reference :  https://serverfault.com/a/1001197 How to Move a Lost, Off-Screen Window Back to Your Desktop

Manually force terminate starting service C#

Imej
Here is the step to manually stop and terminate service that starting & running in background Go to Services.  Right click on the service that we want to stop. Open command prompt as Administrator. write down the command as below: sc queryex " Service name " taskkill /pid PID /f Reference :  How To: Manually Force a service to stop if not responding

SignTool Error: No certificates were found that met all the given criteria

Imej
 An error occurred while signing: Failed to sign bin\Debug\app.publish\ConnectionTesting.exe. SignTool Error: No certificates were found that met all the given criteria  Error signing Project > Right click 'properties' Create new certificate here **We need to create new because the certificate sign with another name/ the certificate expired Build the project after create new signing certificate Done :-) Reference :  https://developercommunity.visualstudio.com/t/failed-to-sign-bindebugapppublishunfactorexe-signt/1318602#T-N1320498

Asal usul blog saya. Kenapa blog ni wujud?

Imej
Hi Assalamualaikum buat pelawat blog saya, Untuk post kali ini, Nurah nak share macam mana wujudnya blog ni.. Pada awalnya, blog ni wujud sebagai satu medium untuk berkongsi nota dari pensyarah saya, Cikgu Zain. Setiap tugasan dan nota untuk subjek Pangkalan Data akan di hantar ke blog ini dan setiap hantaran juga dikira sebagai markah. Jadi setiap pelajar dalam kelas kami memang digalakkan untuk menguruskan blogspot masing - masing. Begitulah ceritanya, tapi saya masih aktif membuat hantaran di blog ini supaya saya dapat merujuk kembali nota - nota lama saya dan juga dapat berkongsi ilmu kepada sesiapa yang terjumpa blog ini.

Pengalaman menyertai Worldskills Malaysia Belia 2018 Web Design

Imej
Hi pembaca, Kali ni Nurah nak berkongsi pengalaman menyertai Worldskills Malaysia Belia 2018 dalam bidang Web Design. Apa yang bestnya masuk pertandingan macam ni? Pertandingan sebegini memang bagus untuk mengasah kemahiran pelajar untuk implement kemahiran yang dipelajari untuk mencapai standard industri. Soalan yang diberikan kepada peserta memang mencabar. PENYERTAAN Nurah dapat tahu pertandingan ni dari Cikgu Ikin (Pensyarah KVKS), jadi cikgu bagi sokongan untuk saya join pertandingan ni untuk mewakili kolej. Jadi untuk sertai ni, kita perlu register di website Jabatan Pembangunan Kemahiran .  SESI PRA KELAYAKAN Selepas register nama, dalam sebulan lepas tu, pihak penganjur akan berikan soalan pra kelayakan. Peserta diberikan masa selama beberapa minggu untuk menyelesaikan soalan. waktu Nurah pergi ni.. soalannya membangunkan website resume. Untuk Web Design kali ni mengikut kreativiti masing - masing. Hari pertandingan tu, lokasi pertandingan bertempat di UTeM, Melaka. Jadi ka...

WMPLib assembly issues (Solved: Driver issues)

Imej
  File yang kena check Source code SOLUTION https://chilionyang.blogspot.com/2020/11/c-windows-media-player-control-com.html PERMANENT SOLUTION - Update graphic card driver (Intel Graphic UHD & GeForce NVIDIA) https://www.intel.com/content/www/us/en/support/intel-driver-support-assistant.html  

Handling error converting data type varchar to numeric in SQL Server

Imej
https://stackoverflow.com/questions/338075/cast-and-isnumeric  https://stackoverflow.com/a/21770230/10763264

System.Net.Sockets.SocketException: 'Only one usage of each socket address (protocol/network address/port) is normally

Imej
 System.Net.Sockets.SocketException: 'Only one usage of each socket address (protocol/network address/port) is normally Option 1 Open the Command Prompt. Type  netstat -ano | findstr ":80"  - where "80" is the port number you are searching for. Look at the last column in the results - the PID. For each PID running that you want to kill, execute  taskkill /PID <PID> /F  in the Command Prompt window (where  <PID>  is the PID that needs to be killed). Option 2 If Option 1 above doesn't work, try rebooting your machine.

PHP XML

 https://www.w3schools.com/php/func_simplexml_asxml.asp https://www.php.net/manual/en/simplexmlelement.asxml.php

Horizontal scroll with mouse wheel at Microsoft Visual Studio

Imej
References link :  https://stackoverflow.com/a/42682640 Extension VSCode :  https://marketplace.visualstudio.com/items?itemName=drewnoakes.SideScroller