<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[旺财]]></title><description><![CDATA[旺财是条狗]]></description><link>https://blog.youkuaiyun.com/adminlhb</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; adminlhb]]></copyright><item><title><![CDATA[注册OLEDB]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/7941068</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/7941068</guid><author>adminlhb</author><pubDate>Tue, 04 Sep 2012 10:51:42 +0800</pubDate><description><![CDATA[regsvr32 msjetoledb40.dll]]></description><category></category></item><item><title><![CDATA[（转）二进制与八卦]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/6653340</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/6653340</guid><author>adminlhb</author><pubDate>Tue, 02 Aug 2011 12:06:55 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[【转载】C# 字符转换]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/6635216</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/6635216</guid><author>adminlhb</author><pubDate>Tue, 26 Jul 2011 16:23:08 +0800</pubDate><description><![CDATA[字符转ASCII码：public static int Asc(string character)  {   if (character.Length == 1)   {    System.Text.ASCIIEncoding asciiEncoding = new Syste]]></description><category></category></item><item><title><![CDATA[MSDEV.EXE 版本]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/6568188</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/6568188</guid><author>adminlhb</author><pubDate>Sun, 26 Jun 2011 09:03:00 +0800</pubDate><description><![CDATA[MSDEV.EXE  6.0.8168.2 编译时没有反应MSDEV.EXE  6.0.9782.2 编译没有问题 ]]></description><category></category></item><item><title><![CDATA[Update]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/6277455</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/6277455</guid><author>adminlhb</author><pubDate>Fri, 25 Mar 2011 12:43:00 +0800</pubDate><description><![CDATA[Update   Tbl1SET  Fld1=X.Fld1From Tbl2 W, Tbl2 XWHERE  W.id=X.id]]></description><category></category></item><item><title><![CDATA[获取Access数据表的方法]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/5907377</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/5907377</guid><author>adminlhb</author><pubDate>Sun, 26 Sep 2010 14:44:00 +0800</pubDate><description><![CDATA[获取数据表的方法： 方法一：直接用ado的OpenSchema()方法打开adSchemaTables，建立一个schema记录集 Const adSchemaTables = 20 adSchemaColumns = 4 dim Conn,db dim ConnStr db="temp.mdb" 'ACCESS数据库的文件名，请使用相对于网站根目录的的绝对路径 ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPat]]></description><category></category></item><item><title><![CDATA[（转）SQL查询慢的48个原因分析]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/5173843</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/5173843</guid><author>adminlhb</author><pubDate>Mon, 11 Jan 2010 13:20:00 +0800</pubDate><description><![CDATA[转自：http://topic.youkuaiyun.com/u/20100109/09/70f82fb7-eabc-4140-9573-5f8395e0f62e.html查询速度慢的原因很多，常见如下几种： 　　1、没有索引或者没有用到索引(这是查询慢最常见的问题，是程序设计的缺陷) 　　2、I/O吞吐量小，形成了瓶颈效应。 　　3、没有创建计算列导致查询不优化。 　　4、内存不足 　　5、网络速度慢 ]]></description><category></category></item><item><title><![CDATA[（转）sql语句递归查询和删除问题]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/4545078</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/4545078</guid><author>adminlhb</author><pubDate>Sat, 12 Sep 2009 09:17:00 +0800</pubDate><description><![CDATA[SQL code if object_id(tb) is not null   drop table tb gocreate table tb(id int,name varchar(50),parentId int)goinsert into tb select 1 ,   工具,   0  union alls]]></description><category></category></item><item><title><![CDATA[（转）模拟QQ截屏]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/4526693</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/4526693</guid><author>adminlhb</author><pubDate>Mon, 07 Sep 2009 10:28:00 +0800</pubDate><description><![CDATA[QQ确实太占资源了， 物理内存和虚拟内存加起来大概有40多M，不过他提供的屏幕截图功能却是不错，能方便的选取能所感兴趣的区域图片，本文试图用VB模拟这一功能，当然功能还是要比QQ截屏少一点，但基本的功能以完备。       截屏原理：QQ截屏应该时先把当前屏幕的内容拷贝到一个窗体，并且这个窗体和屏幕一样大，然后再对这个窗体上的图片进行处理，因此在使用QQ截屏的时候你会发现托盘区那个网络链接的图]]></description><category></category></item><item><title><![CDATA[（转）如何使用ADOX/DAO刷新/更新/删除并重定义链接表]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/4521984</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/4521984</guid><author>adminlhb</author><pubDate>Sat, 05 Sep 2009 11:07:00 +0800</pubDate><description><![CDATA[方法一： 如何使用ADOX刷新链接表  Public Sub NewLinkedExternalTableMdb() 　　 　　 strTargetDB: 被链接的数据库路径名 　　 strProviderString: 连接字符串 　　 strSourceTbl: 被链接的源表名称 　　 strLinkTblName: 要重设链接的链接表的名称 　]]></description><category></category></item><item><title><![CDATA[MSDN：OpenSchema 方法 (ADO)]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/4500348</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/4500348</guid><author>adminlhb</author><pubDate>Sun, 30 Aug 2009 19:43:00 +0800</pubDate><description><![CDATA[从提供者获取数据库纲要信息。语法Set recordset = connection.OpenSchema (QueryType, Criteria, SchemaID)返回值返回包含纲要信息的 Recordset 对象。Recordset 将以只读、静态游标打开。参数QueryType   所要运行的纲要查询类型，可以为下列任意常量。Criteria   可选。每个 ]]></description><category></category></item><item><title><![CDATA[VfpOledb 打开视图]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/4102766</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/4102766</guid><author>adminlhb</author><pubDate>Thu, 23 Apr 2009 11:23:00 +0800</pubDate><description><![CDATA[    Cn.ConnectionString = "Provider=VFPOLEDB.1;Data Source=c:/学生管理.dbc;"    Cn.Open    Cn.Execute "SET ENGINEBEHAVIOR 70"   SQL Group by 在8.0中为向标准SQL     Rs.Open "Select * from sview", Cn, adOpenFo]]></description><category></category></item><item><title><![CDATA[(转) 导入/导出 Excel 的基本方法]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/4071084</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/4071084</guid><author>adminlhb</author><pubDate>Mon, 13 Apr 2009 22:44:00 +0800</pubDate><description><![CDATA[/*=================== 导入/导出 Excel 的基本方法 ===================*/ 从Excel文件中,导入数据到SQL数据库中,很简单,直接用下面的语句: /*===================================================================*/ --如果接受数据导入的表已经存在 insert into ]]></description><category></category></item><item><title><![CDATA[转贴 'MSVBVM60.DLL ]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/4003198</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/4003198</guid><author>adminlhb</author><pubDate>Thu, 19 Mar 2009 08:24:00 +0800</pubDate><description><![CDATA[MSVBVM60.DLL Declare Sub rtcBeep Lib "msvbvm60.dll" () Declare Sub rtcDoEvents Lib "msvbvm60.dll" () Declare Function rtcTrimBstr Lib "msvbvm60.dll" (ByVal lpString As Long) As String Declare Functio]]></description><category></category></item><item><title><![CDATA[(转)解密存储过程]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/3995016</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/3995016</guid><author>adminlhb</author><pubDate>Mon, 16 Mar 2009 16:54:00 +0800</pubDate><description><![CDATA[CREATE  PROCEDURE sp_decrypt(@objectName varchar(50))ASbeginset nocount onbegin trandeclare @objectname1 varchar(100),@orgvarbin varbinary(8000)declare @sql1 nvarchar(4000),@sql2 varchar(8000),@sql3 n]]></description><category></category></item><item><title><![CDATA[（转）SHELL SORT]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/3516105</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/3516105</guid><author>adminlhb</author><pubDate>Sun, 14 Dec 2008 21:47:00 +0800</pubDate><description><![CDATA[        SHELL SORT    Written by Sanchit Karve AKA born2c0de    born2c0de AT hotmail DOT com    Translated to .net by Margus Martsepp AKA m2s87    Sub shellsort(ByRef A() As Integer, ByVal max A]]></description><category></category></item><item><title><![CDATA[（转）排序算法]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/3516085</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/3516085</guid><author>adminlhb</author><pubDate>Sun, 14 Dec 2008 21:43:00 +0800</pubDate><description><![CDATA[Private Sub BubbleSortNumbers(varray As Variant)      Dim cnt1 As Long   Dim cnt2 As Long   Dim tmp As Long   Dim counter As Long      Label12.Caption = "Working..."      For cnt1 = UBound(varray) To ]]></description><category></category></item><item><title><![CDATA[(转贴) B树]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/3111678</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/3111678</guid><author>adminlhb</author><pubDate>Mon, 20 Oct 2008 19:34:00 +0800</pubDate><description><![CDATA[B 树、 B- 树、 B+ 树、 B* 树都是什么 B树       即二叉搜索树：       1.所有非叶子结点至多拥有两个儿子（Left和Right）；       2.所有结点存储一个关键字；       3.非叶子结点的左指针指向小于其关键字的子树，右指针指向大于其关键字的子树；       如：B树的搜索，从根结点开始，如果查询的关键字与结点的关键字相等，那]]></description><category></category></item><item><title><![CDATA[（转）VFP文件结构－微软MSDN]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/3091020</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/3091020</guid><author>adminlhb</author><pubDate>Fri, 17 Oct 2008 12:17:00 +0800</pubDate><description><![CDATA[ 备注文件的结构（.FPT）请参阅备注文件包含一个头记录以及任意数目的块结构。头记录中包含指向下一个自由块的指针以及以字节为单位表示的块大小。块的大小是在创建文件时由 SET BLOCKSIZE 命令确定的。头记录从文件位置 0 开始并占用 512 个字节。命令 SET BLOCKSJZE TO 0 设置块大小为 1。头记录之后是包含块标头与备注文本的各个块。表文件包含有用于引用备]]></description><category></category></item><item><title><![CDATA[VB ActiveDll 后期绑定]]></title><link>https://blog.youkuaiyun.com/adminlhb/article/details/2743700</link><guid>https://blog.youkuaiyun.com/adminlhb/article/details/2743700</guid><author>adminlhb</author><pubDate>Thu, 31 Jul 2008 10:14:00 +0800</pubDate><description><![CDATA[CreateObject(工程名.类别) ]]></description><category></category></item></channel></rss>