FredGrit

2025年10月9日

WPF Epplus export 10M+ items in excel with multiple sheets batch by batch

摘要： Install-Package Epplus; private async Task ExportAsExcelCommandExecuted(object? obj) { try { await PopulateStatusMsg($"Start exporting"); exportedIdx 阅读全文

posted @ 2025-10-09 19:49 FredGrit 阅读(24) 评论(0) 推荐(0)

2025年10月8日

C# access mysql and retrieve data via dapper batch by batch

摘要： Install-Package Mysql.Data; Install-Package Dapper; using Dapper; using MySql.Data.MySqlClient; using System.Data; using System.Diagnostics; namespace 阅读全文

posted @ 2025-10-08 21:30 FredGrit 阅读(17) 评论(0) 推荐(0)

WPF Prism IRegionManager, IContainerRegistry implements IOC, IModule implements module management,IEventAggregator implements message broadcast via Publish,Subscribe,PubSubEvent<T>

摘要： //Install-Package for the whole solution Get-Project -All | Install-Package Prism.Wpf; Get-Project -All | Install-Pacjage Prism.DryIoc; The whole stru 阅读全文

posted @ 2025-10-08 17:02 FredGrit 阅读(20) 评论(0) 推荐(0)

WPF Visual Studio Install-Package for whole solution instead of one project via command in Nuget package console

摘要： Get-Project -All| Install-Package Prism.DryIoc PM> Get-Project -All |Install-Package Prism.DryIoc; Restoring packages for D:\C\WpfApp29\WpfApp29\WpfAp 阅读全文

posted @ 2025-10-08 14:03 FredGrit 阅读(23) 评论(0) 推荐(0)

WPF Prism.Wpf RegionManager

摘要： Install-Package Prism.Wpf; Install-Package Prism.DryIOC; <Window x:Class="WpfApp28.Views.MainWin" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/ 阅读全文

posted @ 2025-10-08 13:44 FredGrit 阅读(19) 评论(0) 推荐(0)

2025年10月7日

MySQl accessed by ssh in win11

摘要： 1.Open PowerShell via administrator role,then run to confirm whether the ssh has been installed in win11 ssh -V 2.Access mysql via ssh, prerequisite y 阅读全文

posted @ 2025-10-07 21:28 FredGrit 阅读(24) 评论(0) 推荐(0)

MySQL InnoDB all data is stored in the PRIMARY key (clustered index). Each row in the table is physically ordered by the PRIMARY KEY

摘要： 'CREATE TABLE `t1` ( `id` int NOT NULL AUTO_INCREMENT, `firstname` varchar(100) NOT NULL DEFAULT '''', `lastname` varchar(100) NOT NULL DEFAULT '''', 阅读全文

posted @ 2025-10-07 20:50 FredGrit 阅读(51) 评论(0) 推荐(0)

WPF Prism.Wpf Prism.DryIOC integrate modules into MainWindow, invoke other project as dll

摘要： Install-Package Prism.DryIOC; Install-Package Prism.Wpf; //App.xaml <prism:PrismApplication x:Class="WpfApp26.App" xmlns="http://schemas.microsoft.com 阅读全文

posted @ 2025-10-07 17:24 FredGrit 阅读(24) 评论(0) 推荐(0)

2025年10月6日

Windows install RabbitMQ via PowerShell as administrator role

摘要： //Run PowerShell as Administrator role //Run below commands respectively //First command Set-ExecutionPolicy Bypass -Scope Process -Force; [System.Net 阅读全文

posted @ 2025-10-06 16:28 FredGrit 阅读(15) 评论(0) 推荐(0)

2025年10月5日

WPF ContentControl Content Binding

摘要： Install-Package Microsoft.Extensions.DependencyInjection; Install-Package CommunityToolkit.mvvm; <Window x:Class="WpfApp25.Views.MainWin" xmlns="http: 阅读全文

posted @ 2025-10-05 22:09 FredGrit 阅读(23) 评论(0) 推荐(0)

公告