- 博客(7)
- 收藏
- 关注
RSS订阅转载 SQL月度统计
select Convert ( VARCHAR(7),CreateTime,120) as Date ,sum(Money) as M FROM [LBAmmeterDB].[dbo].Am_Task where OperateType=4 and Status=1 group by Convert ( VARCHAR(7), CreateTime, 120) 转载于:...
2019-07-16 19:08:00
199
转载 SetCurrentCellAddressCore 函数的可重入调用
绑定数据在线程中 private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { if (DialogResult.OK == MessageBox.Show("是否要修改", "", MessageBoxButtons.OKCanc...
2015-12-09 14:00:00
618
转载 Sql 按日期带条件统计
select convert(char(8),[UseTime],112) dt,sum([UseMoney]) 合计,sum(case when [S_Number]=2 then UseMoney else 0 end ) as '状态2', sum(case when [S_Number]=3 then UseMoney else 0 end ) as '状态3'from [T...
2015-11-17 17:05:00
210
转载 C#验证邮箱,电话,手机,数字,英文,日期,身份证,邮编,网址,IP类等常用函数封装
#region 验证邮箱验证邮箱 /**//// <summary> /// 验证邮箱 /// </summary> /// <param name="source"></param> /// <returns></returns> public static bool IsEmail(string ...
2015-09-17 13:50:00
187
转载 用c#监控网络流量
usingSystem; usingSystem.Text; usingSystem.Net; usingSystem.Net.Sockets; usingSystem.Runtime.InteropServices; namespaceUpdateTester ...{ /**//**//**////<summary> ///Monit...
2015-03-01 14:57:00
433
转载 WAV和PCM文件转换的程序
using System; using System.IO; using System.Text; using System.Windows.Forms; using System.Runtime.InteropServices; namespace Train.wav2pcm { public partial class frmMain : Form ...
2015-01-27 17:31:00
194
转载 一些 SQLite技巧
SQLite自增ID自段 使用方法为 INTEGER PRIMARY KEY AUTOINCREMENT 如: CREATE TABLE 21andy(id INTEGER PRIMARY KEY AUTOINCREMENT,21andy VARCHAR ( 100 ) NOT NULL ,dateDATE); 注意是AUTOINCREMEN...
2015-01-03 12:06:00
110
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人