摘要: C# winform写入和读取TXT文件 string str; str=this.textBox1.Text; StreamWriter sw = new StreamWriter(Application.StartupPath +"\\txtwriter.txt", false); sw.Wri 阅读全文
posted @ 2016-12-14 13:56 Mr.Jiang.K 阅读(1022) 评论(0) 推荐(0) 编辑
摘要: SELECT OutBoundLinId, STUFF((SELECT distinct ';' + RecCode FROM FI_ARReceivableSheets tleft join FI_ARReceiSheetLines t2 ON t.ReceivableSheetId = t2.R 阅读全文
posted @ 2017-05-26 17:19 Mr.Jiang.K 阅读(247) 评论(0) 推荐(0) 编辑
摘要: 一、XML与DataSet的相互转换的类 using System; using System.Collections.Generic; using System.Text; using System.Data; using System.IO; using System.Xml; namespac 阅读全文
posted @ 2016-12-13 10:23 Mr.Jiang.K 阅读(994) 评论(0) 推荐(0) 编辑
摘要: http://www.cnblogs.com/jhxk/articles/1639384.html#undefined 阅读全文
posted @ 2016-10-25 16:42 Mr.Jiang.K 阅读(374) 评论(0) 推荐(0) 编辑
摘要: select SUBSTRING('123,abcdefg',charindex(',','123,abcdefg',0)+1,LEN('123,abcdefg')-charindex(',','123,abcdefg',0)) select SUBSTRING('123,abcdefg',0,ch 阅读全文
posted @ 2016-08-01 17:41 Mr.Jiang.K 阅读(146) 评论(0) 推荐(0) 编辑
摘要: SQL 语句日期用法及函数 --DAY()、MONTH()、YEAR()——返回指定日期的天数、月数、年数; select day(cl_s_time) as '日' from class --返回天 select '月'=month(cl_s_time) from class --返回月 sele 阅读全文
posted @ 2016-08-01 17:35 Mr.Jiang.K 阅读(727) 评论(0) 推荐(0) 编辑