C#

 1. Login kasir part1 

https://www.youtube.com/watch?v=X5CTzugo0tA

2. Membuat keypress dan key down

http://csharp.net-informations.com/gui/key-press-cs.htm

3. Membuat maxsimaze

this.WindowState = FormWindowState.Maximized;

4. Mengatasi form not close 

https://www.youtube.com/watch?v=pXCjFRFOF9A

4. membuar sistem role 

https://www.youtube.com/watch?v=mtnIvYbO2NY

5.crud 

https://www.youtube.com/watch?v=v283Kb80RjE

6. key press with f2

private void Form1_Load(object sender, EventArgs e)
{
    this.KeyPreview = true;
    this.KeyDown += new KeyEventHandler(Form1_KeyDown);
}

void Form1_KeyDown(object sender, KeyEventArgs e)
{
    if (e.KeyCode.ToString() == "F1")
    {
        MessageBox.Show("F1 pressed");
    }
}

7. cara agar index select 
index.select();

8. textbox number only 
https://www.delftstack.com/howto/csharp/how-to-make-a-textbox-that-only-accepts-numbers-in-csharp/

9. pasing value return form
https://stackoverflow.com/questions/5233502/how-to-return-a-value-from-a-form-in-c

10. tambah data data grid view tanpa  database
https://www.inettutor.com/programming-tutorial/c/add-data-in-datagridview-rows-without-database/
https://www.youtube.com/watch?v=Uoz4NS15lj8

11. parsing data gridview integer
https://stackoverflow.com/questions/24590132/retrieving-number-value-from-datagridview-c-sharp

12. sum data gridview 
https://www.youtube.com/watch?v=D4zhJQo2k6A

13. Mengatasi duplicate data
https://www.youtube.com/watch?v=6Ea1XGTjFnI

14. direct find data database 
https://www.youtube.com/watch?v=Zgu_PF0tFf0

15. insert datepicker database
https://stackoverflow.com/questions/29181975/how-to-insert-date-into-sql-database-date-column-using-datetimepicker
16. save data grid view 
https://www.inettutor.com/programming-tutorial/c/save-datagridview-rows-into-database/

17. celat data grid view tanpa hapus header 
https://techstrology.com/clear-gridview-data-source-except-header/

18. Auto Capslock textbox
https://stackoverflow.com/questions/59636365/c-sharp-textbox-auto-caps-lock-on

19. time clock 
https://www.youtube.com/watch?v=Qkuo3fm5ngA

20. select datagrid with value
dataGrid1.SelectedCells[0].value;
21. select cellclick datagrid 
https://www.youtube.com/watch?v=V4IQQt5PIxo
22. clear selected 
 dgv.ClearSelection();
23. disable heading click 
https://www.codeproject.com/Questions/630097/How-to-disable-column-heading-is-clicked-of-DataGr
24. if texbox
https://www.delftstack.com/howto/csharp/csharp-check-if-textbox-is-empty/#:~:text=IsNullOrEmpty()%20function%20has%20a,box%20is%20empty%20or%20not.
25. hapus data grid view agar tidak error 
 if ( dgv2.RowCount > 0)
            {
                int index = dgv2.CurrentCell.RowIndex;
                dgv2.Rows.RemoveAt(index);
            }

26 multiline textbox
https://www.youtube.com/watch?v=yvCaMf9SgJ4

27. direct print with txt
https://docs.microsoft.com/en-us/dotnet/api/system.drawing.printing.printdocument?redirectedfrom=MSDN&view=dotnet-plat-ext-6.0

28. startup directtory 
https://www.codeproject.com/Questions/613133/Csharp-How-to-set-startup-path

29. write to text file 
https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/file-system/how-to-write-to-a-text-file

30. string format duuble dan number
https://www.csharp-examples.net/string-format-double/
https://www.code-sample.net/CSharp/Format-Number

31. konversi angka rupiah
https://www.idwebgit.com/2018/08/konversi-angka-ke-format-rupiah-vice.html

32. parsing data another form 
https://www.c-sharpcorner.com/UploadFile/834980/how-to-pass-data-from-one-form-to-other-form-in-windows-form/

33. close form 
https://stackoverflow.com/questions/14381705/how-to-close-form

34. call fungsi another form 
https://www.overclock.net/threads/calling-a-function-from-another-form-c.1411342/

35. Install rdlc report 
https://rani-irsan.blogspot.com/2021/10/installing-rdlc-report-in-visual-studio.html

36. Setting report viewer net 6
https://www.youtube.com/watch?v=Ul6r0GZXgsg
this.Controls.Add(value: this.reportViewer1);

37. report rdlc 
https://www.youtube.com/watch?v=-Mzd_JLS-Gs&t=233s

38. report rdlc with param
https://www.youtube.com/watch?v=WGKzFKgeoo8

39. sum rdlc 
https://www.youtube.com/watch?v=cb3_TQqaN8w

40 . Multiple table detail report  rdlc
https://www.youtube.com/watch?v=QmgmGIn0mZY&t=27s

41.  Header rdlc row  group rdlc
https://www.youtube.com/watch?v=VopbE17pPCc&t=600s

42. sinkronisasi with prosedure 
https://www.youtube.com/watch?v=RbLvYDckiDQ
https://www.spjeff.com/2018/01/01/tsql-sync-tables-with-easy-stored-procedure/

CREATE PROCEDURE [dbo].[Sync] AS 
--Insert new rows
PRINT 'INSERT'
INSERT INTO [States]
([Name])
SELECT 
[Name]
FROM [States-Temp]
WHERE [Name] NOT IN (SELECT [Name] FROM [States])
--Delete excess rows
PRINT 'DELETE'
DELETE FROM [States] 
WHERE [Name] NOT IN (SELECT [Name] FROM [States-Temp])
--Update matching rows
PRINT 'UPDATE'
UPDATE t2 
SET t2.Abbr = t1.Abbr,
t2.Population = t1.Population,
t2.Capital = t1.Capital
FROM [States] AS t2
INNER JOIN [States-Temp] AS t1 
ON t2.[Name]=t1.[Name]
GO
43. belajar get post update
https://www.youtube.com/watch?v=Yi-O-HBGPeU
https://www.kindsonthegenius.com/how-to-create-rest-api-in-net-using-c-and-visual-studio/

44. belajar get to datagridview
https://stackoverflow.com/questions/23763446/how-to-display-json-data-in-a-datagridview-in-winforms

45. json dumy get post
https://jsonplaceholder.typicode.com/

46. json to database 
https://www.aspsnippets.com/questions/884087/Deserialize-JSON-string-from-API-and-save-into-database-using-C-and-VBNet-in-ASPNet/

47. Unable to convert MySQL date/time value to System.DateTime
https://stackoverflow.com/questions/2934844/unable-to-convert-mysql-date-time-value-to-system-datetime

48. rollback mysql
https://www.codeproject.com/Questions/5165619/How-to-roll-back-changes-in-Csharp
https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqltransaction.rollback?view=dotnet-plat-ext-6.0

49. enable desable form
https://social.msdn.microsoft.com/Forums/en-US/4ebd5faf-80ac-4b4f-99bc-f11b4ded1483/c-enable-disable-form?forum=csharplanguage

50. short cut visual studio
https://vslive.com/Blogs/News-and-Tips/2015/04/5-VS-Keyboard-Shortcuts.aspx#:~:text=If%20you%20select%20a%20block,U%20will%20uncomment%20the%20code.

51. bunifu.ui win form ( untuk dapat tampilan ui )

https://github.com/mike024wk/BunifuCrack
52. just color picker
https://annystudio.com/software/colorpicker/


Komentar