Bo Chen Lin - 博客园

[置顶] How to show help (.CHM) in VCL.Net application?

摘要： I have tried several ways which are used to work for VCL application but no success. So I was wondering how a .Net application use help file written in CHM? By searching in CNBLOGS, I found the article 如何通过C#调用CHM帮助文件. So I wrote a test VCL.Net application which have a menu item named "PMOHelp1", its click event handler as below: 阅读全文

posted @ 2006-07-19 07:25 Bo Chen Lin 阅读(373) 评论(0) 推荐(0) 编辑

Import from Excel - Continue 1

摘要： Here comes a solution:For each import sheet:1. Copy the sheet inot a temp table in the database(SQL Server)2. Run distribution SQL scripts to distribute the data from the temp table into other existin... 阅读全文

posted @ 2006-07-14 09:07 Bo Chen Lin 阅读(587) 评论(0) 推荐(0) 编辑

Import data from Excel

摘要： After some research on the internet, I found a lot articles regarding "Import data from Excel to database". There are a few ways to transfer data from an Excel sheet to a table in a database, the only... 阅读全文

posted @ 2006-07-12 08:41 Bo Chen Lin 阅读(300) 评论(0) 推荐(0) 编辑

Subversion安装记

摘要： SubVersion 安装实验阅读全文

posted @ 2006-07-03 14:05 Bo Chen Lin 阅读(919) 评论(0) 推荐(0) 编辑

错误分析：Internal Query Processor Error: The query processor ran out of stack space during query optimization.

摘要： 1、http://support.microsoft.com/kb/q288095/Queries that contain a large number of arguments (thousands) inside an IN or a NOT IN clause, may generate a stack overflow。阅读全文

posted @ 2006-06-27 07:39 Bo Chen Lin 阅读(679) 评论(1) 推荐(0) 编辑

[Sorting Hierarchical Data in Database ] 补充

摘要：日前发现一个很好的树状数据的算法[http://www.sitepoint.com/print/hierarchical-data-database，作者Gijs Van Tulder]，想对它做些补充。在这篇文章中已对单个节点的操作做出了详细说明，但未提到对分支的操作如移动、复制和删除。在这里我试图对此作一些拓展，使之更易懂、更完善。首先，我们总结一下这个算法的精髓。这个算法实际上是把象树这样一... 阅读全文

posted @ 2005-10-28 10:15 Bo Chen Lin 阅读(526) 评论(0) 推荐(0) 编辑

CVSNT 病例一则

摘要：公司搬完家后，不知为何，用WinCVS访问CVSNT变得时好时坏，就是时快时慢，大部分时间都很慢很慢。今天终于忍无可忍，决定看一看能不能找到问题。于是在自己的机器上装一个CVSNT，看看是不是服务器有问题。折腾半天，好不容易让自己连上了，check in/check out, 再diff等等果然很快。再让同事试连一下，竟怎么也练不上！！！恼火！不试了。想到以前在server上有装过WinCVS... 阅读全文

posted @ 2005-09-22 15:11 Bo Chen Lin 阅读(682) 评论(0) 推荐(0) 编辑

发现DELPHI 2005一个有用的特性

摘要： DELPHI.NET 可以开发VCL.NET Application, 也可以开发WinForm Application。不过我发现，其实这两种Application是可以做到“你中有我，我中有你”的！也就是说在一个Application中，既可以有VCL.NET Form 也可以有WinForm Form，他们可以互相调用、传递参数。实验如下：1、建立一个VCL.NET ... 阅读全文

posted @ 2005-09-10 11:22 Bo Chen Lin 阅读(722) 评论(3) 推荐(0) 编辑

VCL.Net 之家

导航

公告