<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/privates</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; privates]]></copyright><item><title><![CDATA[将Excel转换成CSV]]></title><link>https://blog.youkuaiyun.com/privates/article/details/17379673</link><guid>https://blog.youkuaiyun.com/privates/article/details/17379673</guid><author>privates</author><pubDate>Tue, 17 Dec 2013 16:53:54 +0800</pubDate><description><![CDATA[需要添加引用：Microsoft.Office.Interop.Excelusing Excel = Microsoft.Office.Interop.Excel;调用：SaveAsExcel(@"D:\TEST.xls",@"D:\TEST.CSV"); /// /// 将Excel转换成CSV /// /// Excel路径 /// CSV要保存的路径 public static void S]]></description><category></category></item><item><title><![CDATA[根据年月日得到日期是星期几]]></title><link>https://blog.youkuaiyun.com/privates/article/details/7656351</link><guid>https://blog.youkuaiyun.com/privates/article/details/7656351</guid><author>privates</author><pubDate>Tue, 12 Jun 2012 15:57:22 +0800</pubDate><description><![CDATA[string CaculateWeekDay(int y, int m, int d)
    {
        if (m == 1) { m = 13; y--; }
        if (m == 2) { m = 14; y--; }
        int week = (d + 2 * m + 3 * (m + 1) / 5 + y + y / 4 - y / 100 +]]></description><category></category></item><item><title><![CDATA[div中文字超过指定字符长度即换行]]></title><link>https://blog.youkuaiyun.com/privates/article/details/7656348</link><guid>https://blog.youkuaiyun.com/privates/article/details/7656348</guid><author>privates</author><pubDate>Tue, 12 Jun 2012 15:56:44 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[让文本框只能输入数字和一位小数点]]></title><link>https://blog.youkuaiyun.com/privates/article/details/7656341</link><guid>https://blog.youkuaiyun.com/privates/article/details/7656341</guid><author>privates</author><pubDate>Tue, 12 Jun 2012 15:55:36 +0800</pubDate><description><![CDATA[onpaste="return false"：禁止粘贴]]></description><category></category></item><item><title><![CDATA[程序中进程的读取、关闭]]></title><link>https://blog.youkuaiyun.com/privates/article/details/7656309</link><guid>https://blog.youkuaiyun.com/privates/article/details/7656309</guid><author>privates</author><pubDate>Tue, 12 Jun 2012 15:53:09 +0800</pubDate><description><![CDATA[根据进程名判断进程是否存在 ：
  /// 
        /// 判断进程是否存在
        /// 
        /// 进程名
        /// 存在值变为>0
        /// 
        private bool GetProgram(string procName, out int count)
        {]]></description><category></category></item><item><title><![CDATA[SQL 行列转换]]></title><link>https://blog.youkuaiyun.com/privates/article/details/7618635</link><guid>https://blog.youkuaiyun.com/privates/article/details/7618635</guid><author>privates</author><pubDate>Thu, 31 May 2012 10:00:21 +0800</pubDate><description><![CDATA[数据列转换成行。
其中一列需要转换成行，因为列的值不确定所以用动态执行SQL 
@sql对象拼写出要转换行的列的值。
 
DECLARE @sql VARCHAR(1000)
SELECT @sql = ISNULL(@sql + ',', '') + [ADVERTISE_NAME] FROM [TBL_ADVERTISE_MASTER]
SELECT @sql
EXEC(']]></description><category></category></item><item><title><![CDATA[网页输出中文文档名乱码解决方式]]></title><link>https://blog.youkuaiyun.com/privates/article/details/7288112</link><guid>https://blog.youkuaiyun.com/privates/article/details/7288112</guid><author>privates</author><pubDate>Thu, 23 Feb 2012 17:58:54 +0800</pubDate><description><![CDATA[string fileName = DateTime.Now.ToString("yyyyMMdd") + "中文名.xls";

            string UserAgent = Request.ServerVariables["http_user_agent"].ToLower();
            if (UserAgent.IndexOf("firefox") =]]></description><category></category></item><item><title><![CDATA[根据年月日得到日期是星期几]]></title><link>https://blog.youkuaiyun.com/privates/article/details/7288102</link><guid>https://blog.youkuaiyun.com/privates/article/details/7288102</guid><author>privates</author><pubDate>Thu, 23 Feb 2012 17:54:15 +0800</pubDate><description><![CDATA[string CaculateWeekDay(int y, int m, int d)
    {
        if (m == 1) { m = 13; y--; }
        if (m == 2) { m = 14; y--; }
        int week = (d + 2 * m + 3 * (m + 1) / 5 + y + y / 4 - y / 100 +]]></description><category></category></item><item><title><![CDATA[ORDER BY CHARINDEX 语法]]></title><link>https://blog.youkuaiyun.com/privates/article/details/7267749</link><guid>https://blog.youkuaiyun.com/privates/article/details/7267749</guid><author>privates</author><pubDate>Fri, 17 Feb 2012 14:29:43 +0800</pubDate><description><![CDATA[根据检索条件把检索结果排序。
1、order by中包含的条件在其他数据之前：
select * from 表名
where 列名 in ('条件1','条件2','条件3','条件4')
order by charindex(列名, '条件1,条件2,条件3')

 
2、order by中包含的条件在其他数据之后：
select * from 表名
where 列名 in (]]></description><category></category></item><item><title><![CDATA[.NET面试常见题目]]></title><link>https://blog.youkuaiyun.com/privates/article/details/7265021</link><guid>https://blog.youkuaiyun.com/privates/article/details/7265021</guid><author>privates</author><pubDate>Thu, 16 Feb 2012 16:18:08 +0800</pubDate><description><![CDATA[一、一列数字规则如下:1、1、2、3、5、8、13、21、34..........求第30位数是多少，用递归算法实现
public class demo {

    /**
     * 实现方法
     * @param i
     * @return
     */
    public static int Foo(int i) {
        if (i]]></description><category></category></item><item><title><![CDATA[NPOI 生成Excel 的——常用]]></title><link>https://blog.youkuaiyun.com/privates/article/details/7074777</link><guid>https://blog.youkuaiyun.com/privates/article/details/7074777</guid><author>privates</author><pubDate>Thu, 15 Dec 2011 16:58:44 +0800</pubDate><description><![CDATA[把自己常用的整理了出来，(*^__^*) 嘻嘻……
有关文件输出文件名乱码的问题
有设置Excel中的一些样式问题
有直接保存Excel的
 
更多NPOI的实例说明：http://www.cnblogs.com/tonyqus/archive/2009/04/12/1434209.html   这个可是别个大虾滴。
 
using System;
using System.Col]]></description><category></category></item><item><title><![CDATA[常用指令]]></title><link>https://blog.youkuaiyun.com/privates/article/details/6152810</link><guid>https://blog.youkuaiyun.com/privates/article/details/6152810</guid><author>privates</author><pubDate>Wed, 19 Jan 2011 15:58:00 +0800</pubDate><description><![CDATA[可以添加或者修改 C:/WINDOWS/system32/drivers/etc中的hosts文件中的内容]]></description><category></category></item><item><title><![CDATA[读取.csv文件数据]]></title><link>https://blog.youkuaiyun.com/privates/article/details/6079389</link><guid>https://blog.youkuaiyun.com/privates/article/details/6079389</guid><author>privates</author><pubDate>Thu, 16 Dec 2010 10:50:00 +0800</pubDate><description><![CDATA[using System.IO;private void UploadFile()    {        try        {            if (!FileUpload1.HasFile)            {                Response.Write("文件不存在");                return;            }            string fileExtension = Path.GetExtension(FileUpload1]]></description><category></category></item><item><title><![CDATA[GridView 生成Excel]]></title><link>https://blog.youkuaiyun.com/privates/article/details/6064751</link><guid>https://blog.youkuaiyun.com/privates/article/details/6064751</guid><author>privates</author><pubDate>Thu, 09 Dec 2010 10:13:00 +0800</pubDate><description><![CDATA[private void ExportResult()    {        try        {                        string filename = "text.xls";            HttpContext.Current.Response.Clear();            HttpContext.Current.Response.Charset = "";            HttpContext.Current.Response.AppendH]]></description><category></category></item><item><title><![CDATA[trigger  and  cursor]]></title><link>https://blog.youkuaiyun.com/privates/article/details/6060131</link><guid>https://blog.youkuaiyun.com/privates/article/details/6060131</guid><author>privates</author><pubDate>Tue, 07 Dec 2010 11:15:00 +0800</pubDate><description><![CDATA[创建触发器创建一个基于table_name表的 添加/修改/删除 触发的事件操作定义游标读取数据打开游标循环游标中的数据赋值到变量在游标循环中处理数据结束后关闭游标并释放游标资源。语法：CREATE TRIGGER trigger_nameON table_nameFOR INSERT/UPDATE/DELETEASBEGIN       SET NOCOUNT ON;       DECLARE  @val1 NVARCHAR(50),@val2 NVARCHAR(50)       DECLARE @c]]></description><category></category></item><item><title><![CDATA[FileUpload图片上传 以及图片下载]]></title><link>https://blog.youkuaiyun.com/privates/article/details/6043010</link><guid>https://blog.youkuaiyun.com/privates/article/details/6043010</guid><author>privates</author><pubDate>Mon, 29 Nov 2010 15:49:00 +0800</pubDate><description><![CDATA[ private void UpImg()    {        string image = picFile.PostedFile.FileName;        string imageType = image.Substring(image.LastIndexOf(".") + 1).ToUpper();        if (imageType == "JPG" || imageType == "JPEG" || imageType == "GIF" || imageType == "PNG" ]]></description><category></category></item><item><title><![CDATA[GridView生成.csv文件]]></title><link>https://blog.youkuaiyun.com/privates/article/details/6037947</link><guid>https://blog.youkuaiyun.com/privates/article/details/6037947</guid><author>privates</author><pubDate>Fri, 26 Nov 2010 17:32:00 +0800</pubDate><description><![CDATA[string filename=DateTime.Now.ToString()+".csv";int rowCount = gridViewDL.Rows.Count + 1;int colCount = gridViewDL.Columns.Count;string[] arr = new string[colCount];StringWriter fileWriter = new StringWriter();//标题设置arr[0]="";arr[1]="";arr[2]="";fileWriter.]]></description><category></category></item><item><title><![CDATA[.net 自带 发邮件]]></title><link>https://blog.youkuaiyun.com/privates/article/details/6037942</link><guid>https://blog.youkuaiyun.com/privates/article/details/6037942</guid><author>privates</author><pubDate>Fri, 26 Nov 2010 17:30:00 +0800</pubDate><description><![CDATA[using System.Net.Mail;    ///     /// 发送邮件程序    ///     /// 发送人邮件地址    /// 发送人显示名称    /// 发送给谁（邮件地址）    /// 标题    /// 内容    /// 邮件登录名    /// 邮件密码    /// 邮件服务器    /// ]]></description><category></category></item></channel></rss>