Catatan

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.