Nurah.lee

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

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 ...

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

  Rujukan : OpenFileDialog In C#

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

Juice Mobile App UX-UI Design

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 :-)

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

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...

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

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 ?  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/

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

 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

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

Kat sini, Lee senaraikan kaedah untuk membuat positioning (Location) di C# Windows Form. FlowLayoutPanel  TableLayoutPanel  Location Point() method  // // tableLayoutPanel1 // this.tableLayoutPanel1.ColumnCount = 1; this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 100F)); this.tableLayoutPanel1.Controls.Add(this.stationCodeTBB, 0, 1); this.tableLayoutPanel1.Controls.Add(this.pfUp, 0, 0); this.tableLayoutPanel1.Controls.Add(this.pfDown, 0, 2); this.tableLayoutPanel1.Location = new System.Drawing.Point(19, 0); this.tableLayoutPanel1.Name = "tableLayoutPanel1"; this.tableLayoutPanel1.RowCount = 3; this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 40F)); this.tableLayoutPanel1.RowStyles.Add(new System.Window...

Reference:  https://www.youtube.com/watch?v=cL3aO1QkgvM

Resepi Ais Latte ( Homemade) Bahan-bahan 1 shot espresso atau satu cawan kecil nescafe gold. 200ml susu segar Kaedah Masukkan ais didalam gelas tinggi. Masukkan susu hingga memenuhi tiga suku gelas tadi. Akhir sekali masukkan espresso. Credit : Resepi.my - https://resepi.my/resepi-ais-latte-homemade/

To add an application configuration file to a C# project 1. On the menu bar, choose Project > Add New Item. The Add New Item dialog box appears. 2. Expand Installed > Visual C# Items, and then choose the Application Configuration File template.  3. In the Name text box, enter a name, and then choose the Add button. 4. A file named app.config is added to your project. Rujukan: How to: Add an application configuration file to a C# project - https://docs.microsoft.com/en-us/visualstudio/ide/how-to-add-app-config-file?view=vs-2019

  Rujukan How to convert your laptop/desktop into a server and host internet accessible website on it: Part 1 https://afteracademy.com/blog/how-to-convert-your-laptop-desktop-into-a-server-and-host-internet-accessible-website-on-it-part-1-545940164ab9 How to convert your laptop/desktop into a server and host internet accessible website on it: Part 2 https://afteracademy.com/blog/how-to-convert-your-laptop-desktop-into-a-server-and-host-internet-accessible-website-on-it-part-2-cdb4b3633fa9

Cara - cara untuk setup sqlsrv di local dddddd ddddd ddddd Rujukan  Download driver (my version for backup purpose only) -  https://drive.google.com/file/d/1KVhUuJiO31aV4a77OVuEYFl1l7juvkse/view?usp=sharing PHP Version Support - https://docs.microsoft.com/en-us/sql/connect/php/microsoft-php-drivers-for-sql-server-support-matrix?view=sql-server-2017#php-version-support How to install an SQLSRV extension to php XAMPP -  https://stackoverflow.com/a/50648896 -  https://stackoverflow.com/a/55134712 Download Microsoft driver - https://docs.microsoft.com/en-us/sql/connect/php/download-drivers-php-sql-server?view=sql-server-ver15#download Addon notes (Tapi tak jadi pun haha) https://sarn.phamornsuwana.com/2018/10/09/installing-xampp-on-windows-10-with-sqlsrv-drivers/

  How to Migrate from MSSQL to MySQL https://severalnines.com/database-blog/how-migrate-mssql-mysql

  See the Pen jQuery Live Clock by Martynas Linkevicius ( @iiSeptum ) on CodePen .

How to Host Google Fonts on Your Own Server https://themify.me/blog/how-to-host-google-fonts-on-server

Cara mudah untuk menukar format antara SQL. MSSQL ke MySQL. Di bawah ni Lee letak rujukan.  http://www.sqlines.com/online

 Rujukan https://www.projectmanagementdocs.com/template/project-documents/system-design-document/#axzz6dGF8les2

 Solution. untick Enforce password expiration Rujukan SQL Server: “The password of the account has expired.”

*Tutorial here Rujukan How to Create Setup.exe Visual Studio 2019 https://www.youtube.com/watch?v=-oIf6lGdaik

Ringkasan Git * Nanti akan dijelaskan :) * Doakan Lee rajin untuk buat video tutorial :) Nota command Git Check if Git has already been installed git --version Add your Git username & set your email git config --global user_name "YOUR USERNAME" git config --global user_name git config --global user_email "YOUR EMAIL" git config --global user_email Check your information git config --global --list Initialize a local directory for Git version control git init Clone a repo git clone https://__________ Switch to master branch git checkout master Download the latest changes in the project git pull <REMOTE> <NAME OF BRANCH> View remote repo git remote -v Add remote repo git remote add <SOURCE_NAME><REPOSITORING _PATH>

Assalamualaikum Hai… Petang ni Lee nak kongsikan cara mudah untuk aktifkan fungsi sedia ada IIS di Windows 10. 1. Mula – mula pergi ke Control Panel dan klik pada Program > Programs and Features. Klik ‘Turn Windows features on or off’ yang berada di sidemenu. 2. Paparan seperti dibawah akan muncul. Tanda pada Internet Information Services (IIS). Enable kan semua features yang ingin digunakan (Boleh rujukan rajah di bawah).  Klik OK.  3. Untuk memastikan samada features telah aktif. Kita perlu open ‘Start’ dan search ‘IIS’ di start menu. Buka Internet Information Services (IIS) Manager. 4. Rajah di bawah merupakan paparan IIS Manager. Untuk aktifkan IIS, kita perlu klik ‘Start’ pada sidemenu Manage Website yang berada di sebelah kanan. 5. IIS telah diaktifkan. Untuk melihat paparan localhost, kita perlu klik Browse *:80 (http) di bawah menu Browse Website. Anda juga boleh akses localhost dengan cara taip ‘localhost’ di url bar di browser. 6. Langkah seterusnya, k...

Assalamualaikum korang. Hi gais. Untuk post kali ini… Lee nak kongsikan cara install MySQL di Centos 7. Sebelum tu Lee nak bagitahu yang versi MySQL 7 dan 8 agak berbeza. Cara install sama cuma part waktu nak connect tu nanti kena ubah setting sikit dekat MySQL. Ok jom kita start. 1. Mula – mula, kita kena pergi ke link https://dev.mysql.com/downloads/repo/yum/ Kita akan refer repo yang disenaraikan kat situ. Untuk reference gambar ni Lee download masa 23 March 2020. So kalau dah update ke apa ke korang boleh ikut yang macam dekat website tu. 2. Download repo guna command wget. Boleh refer kat gambar bawah ni. 3. Selesai download, perlu verify md5sum . Command rujuk rajah di bawah; Kita perlu rujuk sama ada md5 tu sama tak dengan yang di paparkan pada web. 4. Lepas kita verify, kita akan start install mysql-server. Pada directory yang ada software mysql yang kita download tadi. Kita boleh taip command sudo yum install mysql-server . 5. Setelah selesai install dan download de...