- 博客(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
211
转载 SetCurrentCellAddressCore 函数的可重入调用
绑定数据在线程中 private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { if (DialogResult.OK == MessageBox.Show("是否要修改", "", MessageBoxButtons.OKCanc...
2015-12-09 14:00:00
636
转载 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
226
转载 C#验证邮箱,电话,手机,数字,英文,日期,身份证,邮编,网址,IP类等常用函数封装
#region 验证邮箱验证邮箱/**//// <summary>/// 验证邮箱/// </summary>/// <param name="source"></param>/// <returns></returns>public static bool IsEmail(string ...
2015-09-17 13:50:00
198
转载 用c#监控网络流量
usingSystem;usingSystem.Text;usingSystem.Net;usingSystem.Net.Sockets;usingSystem.Runtime.InteropServices;namespaceUpdateTester...{/**//**//**////<summary>///Monit...
2015-03-01 14:57:00
453
转载 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
208
转载 一些 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
125
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人