Catatan

Tunjukkan catatan dari Disember, 2020

Ionic 2/Ionic 3 - How to delete pages and remove app module references

 https://www.techiediaries.com/ionic-delete-pages/

Cara setup Gitlab

Imej
TUTORIAL 2021 *NEW VERSION GITLAB To ease developer to do git things, We need to generate access key for our machine. For the security reason, just the linked key machine can access git through SSH. How to generate SSH for your machine ID 1) Go to User Settings > SSH Keys 2) Refer picture above. To generate keygen, we need to open command prompt and type...      ssh-keygen -t ED25519SSH -C "your email address" 3) Enter the directory we want to save the publish key and enter the password. 4) Go to the directory where we save the publish key. Open the file using text editor (Notepad, VS Code) 5) Open using text editor and copy all the key. 6) Enter the key on Gitlab setting 7) Done TUTORIAL 2020 1) Generate SSH     a) Buka terminal, taip ; ED25519 SSH          ssh-keygen -t ed25519 -C "email@gmail.com"     b) taipkan password     c) Buka gitBash          cat ~/.ssh/id_ed25519.pub | clip ...

C# Escaping string character

Escaping string using @ string path = @"C:\Program Files\Microsoft Visual Studio 10.0\"; On mssql escaping character using ESCAPE  WHERE mycolumn LIKE '%\_%' ESCAPE '\' SELECT isTrack.id AS [translated_pf], platformno FROM stationtrack INNER JOIN isTrack ON isTrack.name = stationtrack.track WHERE stationcode = 'KL' AND isTrack.id LIKE '%KL\_%' ESCAPE '\' ORDER BY platformno ASC; References Why does using an Underscore character in a LIKE filter give me all the results - https://stackoverflow.com/a/19588588/10763264 Escaping in C#: characters, strings, string formats, keywords, identifiers -  https://www.codeproject.com/Articles/371232/Escaping-in-Csharp-characters-strings-string-forma

C# OpenFileDialog

  Rujukan : OpenFileDialog In C#

C# : SqlParameterCollection.Add(string, object)' is obsolete

Imej
'SqlParameterCollection.Add(string, object)' is obsolete: 'Add(String parameterName, Object value) has been deprecated. Rujukan :  https://stackoverflow.com/a/31731109/10763264   SqlParameterCollection.Add Method

Design references

Imej
Juice Mobile App UX-UI Design

C#: Add icon to Windows

Imej
Hai assalamualaikum. Kali ini, Lee nak share cara untuk tukar icon pada Windows Form di .NET C# 1. Klik pada 'Icon' di panel 'Properties' di sebelah kanan. 2. Pilih icon untuk dijadikan icon pada form. Klik 'Open'. 3. 'Icon' akan berubah. Itu sahaja perkongsian dari Lee. Semoga bermanfaat :-)

Windows Server : Install PHP and mysql

Rujukan :  A Complete Guide to Installing MySQL and PHP with IIS How to Host PHP on Windows With IIS

C# Error : Creating Window Handle (Not Solve)

Imej
Try solution 1. Guna  Invoke((MethodInvoker)delegate v this.Invoke((MethodInvoker)delegate {   //call your method here  });  private void ultraButton1_Click(object sender, EventArgs e) {   Task.Factory.StartNew(() => myMethod1());  }  void myMethod1() {   //my logic   this.Invoke((MethodInvoker)delegate {     ultraDesktopAlert1.Show($"my message header", "my message");   }); }  Rujukan : “Error Creating Window Handle” 2. Sebab timer Rujukan :  High ram load and “Error creating window handle” exception 3. Before adding handlers for events , First remove them RemoveHandler objReportViewer.LocalReport.SubreportProcessing, AddressOf SubReportProcessing AddHandler objReportViewer.LocalReport.SubreportProcessing, AddressOf SubReportProcessing Rujukan :  Error creating window handle 4. Kena Dispose Graphic / Pen OK, everyone is focused on the Pen. That's not the problem in the c...

SQL Server Indexes

Imej
Apa itu Indexing ?  Contoh coding USE [syncdb] GO SET ANSI_PADDING ON GO /****** Object: Index [train_map] Script Date: 08-Dec-20 16:26:35 ******/ CREATE NONCLUSTERED INDEX [train_map] ON [dbo].[displayfallbackdata] (   [DisplayId] ASC,   [ExpectedDeparture] DESC,   [State] ASC  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]  GO Sumber Rujukan Clustered and Nonclustered Indexes Described CREATE INDEX (Transact-SQL) CREATE INDEX Syntax - w3school Top 10 questions and answers about SQL Server Indexes d

C# BackgroundWorker

Imej
1. Masukkan BackgroundWorker ke dalam Windows Form. Search BackgroundWorker di Toolbox. Double click pada BackgroundWorker. 2. Invoke Cross-thread BackgroundWorker - Cross-thread operation not valid 3. Start and Stop BackgroundWorker private void btnStart_Click(object sender, RoutedEventArgs e) { worker.RunWorkerAsync(); } private void btnCancel_Click(object sender, RoutedEventArgs e) { worker.CancelAsync(); } Sumber BackgroundWorker - Cross-thread operation not valid -  https://stackoverflow.com/a/39009632/10763264 How to use a BackgroundWorker? -  https://stackoverflow.com/a/6481328/10763264 Cancelling the BackgroundWorker -  https://www.wpf-tutorial.com/misc/cancelling-the-backgroundworker/

Apa itu VPS (Virtual Private Server) ?

Imej
 Apa itu VPS ?  Apa itu VPS ?  Apa itu VPS ? Sumber rujukan :  Prinsip dan Cara Kerja VPS yang Perlu kamu Ketahui Sebelum jadi Anak IT -  https://www.jagoanhosting.com/blog/prinsip-dan-cara-kerja-vps/   Apa Itu VPS? Definisi dan Cara Kerja Virtual Private Server -  https://www.jagoanhosting.com/blog/apa-itu-vps/

Apa itu OOP ? Encapsulation, Inheritance, Polyorphism dan Abstrak Class

Imej
Mengenal OOP : Encapsulation, Inheritance, Polyorphism dan Abstrak Class Sumber : Mengenal OOP : Encapsulation, Inheritance, Polyorphism dan Abstrak Class - https://www.jagoanhosting.com/blog/mengenal-oop-encapsulation-inheritance-polyorphism-dan-abstrak-class/ Slide apa itu OOP ? - https://www.slideshare.net/mobile/irabasyiroh/pengertian-inheritance-pewarisan-dalam-oop

C# Change variable in opened form from another form

 List rujukan delegate Source : Change a variable on a already open form Visual C# -  https://social.msdn.microsoft.com/Forums/windows/en-US/fc734145-5247-4348-867f-1ab636a30871/change-a-variable-on-a-already-open-form-visual-c?forum=winforms Using Delegates to Communication Between Windows Forms -  https://www.c-sharpcorner.com/article/using-delegates-to-communication-between-windows-forms/ C# .NET Delegates and Events - https://www.c-sharpcorner.com/UploadFile/puranindia/C-Sharp-net-delegates-and-events/ More info : Event and Delegate in C# -  https://medium.com/@ibrahimyengue/event-and-delegate-in-c-1b6516002833

C# Timer : Run function in interval time

Apa itu Timer function di dalam .NET C#? ~ ~ ~ Contoh code public Form1() {  InitializeComponent(); timer1 = new Timer();  timer1.Tick += new EventHandler(timer1_Tick);  timer1.Interval = 5000; // in miliseconds timer1.Start(); } Rujukan Execute specified function every X seconds -  https://stackoverflow.com/a/6169305/10763264 C# - how do you stop a timer? -  https://stackoverflow.com/a/4563738/10763264