<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[xiagirl的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/xiagirl</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; xiagirl]]></copyright><item><title><![CDATA[记录SQL 中的 CASE语句、WITH AS语句 、PARTITION BY语句的用法]]></title><link>https://blog.youkuaiyun.com/xiagirl/article/details/5806911</link><guid>https://blog.youkuaiyun.com/xiagirl/article/details/5806911</guid><author>xiagirl</author><pubDate>Thu, 12 Aug 2010 14:37:00 +0800</pubDate><description><![CDATA[记录SQL 中的 CASE语句、WITH AS语句 、PARTITION BY语句的用法]]></description><category></category></item><item><title><![CDATA[设置按钮的ToolTip显示（VB.NET）]]></title><link>https://blog.youkuaiyun.com/xiagirl/article/details/5799203</link><guid>https://blog.youkuaiyun.com/xiagirl/article/details/5799203</guid><author>xiagirl</author><pubDate>Mon, 09 Aug 2010 16:25:00 +0800</pubDate><description><![CDATA[设置按钮的ToolTip显示（VB.NET）]]></description><category></category></item><item><title><![CDATA[MYSQL 获取当前日期及日期格式]]></title><link>https://blog.youkuaiyun.com/xiagirl/article/details/5077220</link><guid>https://blog.youkuaiyun.com/xiagirl/article/details/5077220</guid><author>xiagirl</author><pubDate>Fri, 25 Dec 2009 17:41:00 +0800</pubDate><description><![CDATA[MYSQL 获取当前日期及日期格式   获取系统日期：  NOW()   格式化日期：    DATE_FORMAT(date, format)               注：   date：时间字段                         format：日期格式 返回系统日期,输出 2009-12-25 14:38:59select now();输出 09-12-25 sele]]></description><category></category></item><item><title><![CDATA[Oracle 获取当前日期及日期格式]]></title><link>https://blog.youkuaiyun.com/xiagirl/article/details/5076938</link><guid>https://blog.youkuaiyun.com/xiagirl/article/details/5076938</guid><author>xiagirl</author><pubDate>Fri, 25 Dec 2009 17:09:00 +0800</pubDate><description><![CDATA[Oracle 获取当前日期及日期格式

   获取系统日期：  SYSDATE()
   格式化日期：     TO_CHAR(SYSDATE(),'YY/MM/DD HH24:MI:SS')
                      或 TO_DATE(SYSDATE(),'YY/MM/DD HH24:MI:SS')
   格式化数字：      TO_NUMBER]]></description><category></category></item><item><title><![CDATA[SqlServer2000 获取当前日期及日期格式]]></title><link>https://blog.youkuaiyun.com/xiagirl/article/details/5076778</link><guid>https://blog.youkuaiyun.com/xiagirl/article/details/5076778</guid><author>xiagirl</author><pubDate>Fri, 25 Dec 2009 16:57:00 +0800</pubDate><description><![CDATA[SqlServer2000 获取当前日期及日期格式   获取系统日期：  GETDATE()   格式化日期：    CONVERT(VARCHAR,GETDATE(),20)                      或 CONVERT(VARCHAR(20),GETDATE(),120)                注： 20 表示20位，日期格式为：yyyy-mm-dd hh:mm:s]]></description><category></category></item><item><title><![CDATA[所有连接数据库方法]]></title><link>https://blog.youkuaiyun.com/xiagirl/article/details/5020587</link><guid>https://blog.youkuaiyun.com/xiagirl/article/details/5020587</guid><author>xiagirl</author><pubDate>Wed, 16 Dec 2009 18:59:00 +0800</pubDate><description><![CDATA[所有连接数据库方法：http://www.connectionstrings.com]]></description><category></category></item><item><title><![CDATA[显示 DataGridView 的选择行数]]></title><link>https://blog.youkuaiyun.com/xiagirl/article/details/5020561</link><guid>https://blog.youkuaiyun.com/xiagirl/article/details/5020561</guid><author>xiagirl</author><pubDate>Wed, 16 Dec 2009 18:53:00 +0800</pubDate><description><![CDATA[显示 DataGridView 的选择行数控件： DataGridView 控件，name：DataGridView1           三个 Label 控件，name 分别为 ：lblStart、lbl、lblTotal初期值：Me.lblStart.Text = 1            Me.lblTotal.Text = Me.DataGridView1.Rows.Count]]></description><category></category></item><item><title><![CDATA[判断文件是否被打开]]></title><link>https://blog.youkuaiyun.com/xiagirl/article/details/5020536</link><guid>https://blog.youkuaiyun.com/xiagirl/article/details/5020536</guid><author>xiagirl</author><pubDate>Wed, 16 Dec 2009 18:48:00 +0800</pubDate><description><![CDATA[判断文件是否被打开 根据文件完整路径获取文件名         strFileName = Right(strFilePath, Len(strSrcZipedDB) - InStrRev(strFilePath, "/"))   方法一：利用进程判断  Public Sub IsFileOpen(ByVal strFilePath As String)        ]]></description><category></category></item><item><title><![CDATA[根据文件路径查看文件]]></title><link>https://blog.youkuaiyun.com/xiagirl/article/details/5020533</link><guid>https://blog.youkuaiyun.com/xiagirl/article/details/5020533</guid><author>xiagirl</author><pubDate>Wed, 16 Dec 2009 18:46:00 +0800</pubDate><description><![CDATA[根据文件路径查看文件Private Sub SearchFile()        Dim strFilePath As String        Try            strFilePath = "E:/test.xls"            //确定指定的文件是否存在。            If System.IO.File.Exists(m_strBi]]></description><category></category></item><item><title><![CDATA[将上传文件保存到指定目录]]></title><link>https://blog.youkuaiyun.com/xiagirl/article/details/5020511</link><guid>https://blog.youkuaiyun.com/xiagirl/article/details/5020511</guid><author>xiagirl</author><pubDate>Wed, 16 Dec 2009 18:38:00 +0800</pubDate><description><![CDATA[将上传文件保存到指定目录控件：一个 TextBox 控件，name：textbox1         一个 OpenFileDialog 控件，name：openfiledialog1 Private Sub SaveFile()        Dim strOldFilePath As String   //文件原路径        Dim strSaveAddress As ]]></description><category></category></item><item><title><![CDATA[动态获取 OpenFileDialog 的 Fileter 属性值]]></title><link>https://blog.youkuaiyun.com/xiagirl/article/details/5020490</link><guid>https://blog.youkuaiyun.com/xiagirl/article/details/5020490</guid><author>xiagirl</author><pubDate>Wed, 16 Dec 2009 18:31:00 +0800</pubDate><description><![CDATA[动态获取上传文件的文件类型(OpenFileDialog 的 Filter 属性值)控件： 一个 OpenFileDialog 控件，name：openfiledialog1说明：       文件类型：可从数据库获取，这里为了方便，直接用 xls,jpg,pdf,doc 替代       为支持多种类型，文件类型间用 分号(;)隔开示例： openfiledialog1.Filter = "]]></description><category></category></item></channel></rss>