11 2020 档案

C# export generic data via Microsoft.Office.Interop.Excel vs NPOI,the latter is much faster 40 times than the former
摘要：using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using Excel = Microsoft.Office.Int 阅读全文
posted @ 2020-11-30 20:24 FredGrit 阅读(119) 评论(0) 推荐(0) 编辑
Set the single datagridcell enable or disable according to another property in the selected row
摘要：This will set the activity of single cell in datagrid,instead of the whole column with same header. It toggle the validity of the single cell in seper 阅读全文
posted @ 2020-11-27 21:40 FredGrit 阅读(104) 评论(0) 推荐(0) 编辑
c# insert data bulkly into mysql per 10000 or 1000
摘要：CREATE TABLE `person5` ( `Id` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `Name` longtext, `PId` int NOT NULL, PRIMARY KEY (`Id` 阅读全文
posted @ 2020-11-25 17:37 FredGrit 阅读(153) 评论(0) 推荐(0) 编辑
C# MySql Dapper
摘要：using System.Text.Json;using MySql.Data.MySqlClient; using Dapper;using System.IO; static void MySQLDemo() { string selectSQL = "select * from salesor 阅读全文
posted @ 2020-11-24 20:50 FredGrit 阅读(449) 评论(0) 推荐(0) 编辑
C# Serialize object via System.Text.Json
摘要：using System.Text.Json; static void TextJsonDemo() { var obj = new { Id = 1, Name = "Fred", Age = 33, Org = new[] { new { Id=1, Name="MS" }, new { Id= 阅读全文
posted @ 2020-11-24 20:29 FredGrit 阅读(109) 评论(0) 推荐(0) 编辑
WPF UnityContainer traditional using Microsoft.Practices.Unity;
摘要：1.Install-Package Unity -Version 4.0.1 2. using Microsoft.Practices.Unity; using WpfApp9.IModels; using WpfApp9.Models; using WpfApp9.ViewModel; names 阅读全文
posted @ 2020-11-17 15:55 FredGrit 阅读(98) 评论(0) 推荐(0) 编辑
C# MySQL ADO.Net Dapper query dynamic IDictionary<string,object>
摘要：using MySql.Data.MySqlClient; using Dapper; static void MySqlDapperDemo() { string connString = "Server=localhost;Port=3306;Database=firstSchema;Uid=U 阅读全文
posted @ 2020-11-09 15:11 FredGrit 阅读(242) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示