How to close SqlConnection via DataReader. 如何通过DataReader关闭SqlConnection

It is a common issue of how to handle SqlConnection gracefully, when implementing some general helper methods likeSqlDataReader ExecuteReader(string ...

2008-02-22 08:29:00

阅读数 1047

评论数 0

SQL 2000 to SQL 2005: Where Have All the Old Features Gone?

from By : Boris Baliner   As more DBAs across the planet begin using SQL 2005...

2007-11-02 02:38:00

阅读数 1289

评论数 0

How do I find all the foreign keys in a database? 如何找到一个数据库中的全部外键(FK)?

原文: Server  Here is one query using the INF...

2007-10-04 08:49:00

阅读数 1339

评论数 1

How to set a single wallpaper/background across dual monitors 如何设置双显示器的背景图片贯穿

1) Get the wallpaper which fits your resolution. For example, if both of your monitors resolution is 1440*900, you should look for the wallpaper of 2...

2007-09-07 13:17:00

阅读数 1427

评论数 0

Show Immediate Window in VS. 显示Visual Studio中的Immediate窗口

The Immediate window is quite useful in your debugging, but you can never find it in the menus of Visual Studio.I dont know why Microsoft wants to &q...

2007-08-17 08:20:00

阅读数 2285

评论数 1

Copy message box text to the clipboard. 复制Windows标准消息框中的文本

How to copy the content of a standard Windows MessageBox?Its much easier than you could image!1) Activate this MessageBox (Click the Caption of the M...

2007-08-17 08:15:00

阅读数 1393

评论数 1

Details of "FOR XML" sql clause in SQL-Server

SQL Server allows developers to query SQL Server and receive data in XML format via a special clause: FOR XML. This clause provides 4 different modes...

2007-03-15 11:23:00

阅读数 1262

评论数 0

The automation of COM+ configuration via COMAdmin (COM)

Initialization:COMAdminCatalog.Connect(""); Get Collections (COMAdminCatalogCollection):For the 1st level (e.g. Applications):appl...

2007-03-14 04:17:00

阅读数 1722

评论数 0

Xml 查漏补缺笔记

 Special symbol:Sylvie Aronson The left/right angle brackets should be replaced with </> in xml node:Sylvie <Bellie> Aro...

2007-02-28 09:54:00

阅读数 1286

评论数 1

Unicode versus ANSI

Question: So what is the difference between Unicode (i386ur) and ANSI (i386r)?Answer: Put simply, a Unicode program is a special version that runs sl...

2007-02-16 02:47:00

阅读数 1195

评论数 0

Com+ debug issue: incorrect watch value and abnormal step through path

Issue:When I started  to debug a Com+ project with VC8, I saw many incorrect value in the watch window, and abnormal step through path For some CStri...

2006-12-22 08:19:00

阅读数 1204

评论数 0

Upgrade Issue: Compile error C2327 with import dll under VC8/VS2005

Issue:When I upgrade an exe project from VC7.1 to VC8, it says upgrade succeed. But When I try to compile the project, it outputs a lot of errors.  ....

2006-12-22 07:42:00

阅读数 2072

评论数 0

How to fix windows installer error: C:/Windows/Installer/xxxxxxx.ipi

When I run into the issue of the windows installer on my computer, I just noticed I can not install any software via windows installer. I just got th...

2006-12-13 06:50:00

阅读数 2787

评论数 0

Upgrade Issue: Register fails after build ATL project under VC8/VS2005

Issue: An ATL/COM project can be built and registered successfully under VC7.1/VS2003. After upgrade this project to VC8/VS2005 using the upgrade wiz...

2006-12-13 03:37:00

阅读数 1420

评论数 0

Convert Wav file to MP3 via Windows Sound Recorder. 利用windows的录音机将wav文件转成MP3

1) All Programs -> Accessories -> Entertainment -> Sound Recorder2) Open the Wav file with Sound Recorder3) Click File -> Save As, the Sa...

2006-10-31 02:20:00

阅读数 1478

评论数 3


第一次用C#里面的XmlDataDocument类,发现真好用:)  public void Transfer(string inXmlFilename, string outCSVFilename)  {   // open or create   FileStream fileCsv = ne...

2005-06-06 19:22:00

阅读数 2460

评论数 1


呵呵,工作了这么多年,还真没写过:)这次尝试一下...------------------------------------------------------------功能:拷贝一些相关的文件,远程路径需要根据版本号来拼出。if "%1"=="" go...

2005-06-01 11:34:00

阅读数 1820

评论数 0

SQL Server中直接循环写入数据

构建测试表很有用,呵呵,事实上我就是老记不住SQL Server支持While循环,我总是习惯用FOR循环,结果在帮助里查半天总是找不到。  declare @i intset @i=1while @ibegin  insert into table (colume) values(@i)  se...

2005-03-15 11:27:00

阅读数 1021

评论数 0


请大家选用Siwen的XNote,真的相当好用哦,原文=========================================Siwen XNote 3.2       XNote w...

2005-01-25 18:39:00

阅读数 790

评论数 0


1.编写COM    接口的声明:2处            .idl file                interface IPage : IDispatch{                         [id(1), helpstring("Method Update&q...

2005-01-04 11:44:00

阅读数 978

评论数 3

取消 删除