16 carolbaby

尚未进行身份认证

You could read my blog for details

等级
博文 26
排名 7k+

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

It isacommonissueofhowto handleSqlConnectiongracefully,when implementingsome generalhelpermethodslikeSqlDataReaderExecuteReader(stringconnectionString,CommandTypecommandType,stri

2008-02-22 08:29:00

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

fromSQL-Server-Performance.comBy:BorisBaliner AsmoreDBAsacrosstheplanetbeginusingSQL2005Tools,butstillmanageSQL20

2007-11-02 02:38:00

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

原文:http://sqlserver2000.databases.aspfaq.com/schema-how-do-i-find-all-the-foreign-keys-in-a-database.htmlSQLServer  HereisonequeryusingtheINFORMATION_SCHEMAviewsthatreturnsbothsidesof

2007-10-04 08:49:00

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

1)Getthewallpaperwhichfitsyourresolution.Forexample,ifbothofyourmonitorsresolutionis1440*900,youshouldlookforthewallpaperof2880*900resolution.2)Setthisimagetobackgrou

2007-09-07 13:17:00

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

TheImmediatewindowisquiteusefulinyourdebugging,butyoucanneverfinditinthemenusofVisualStudio.IdontknowwhyMicrosoftwantsto"hide"it,asitseemstheonlywaytoshowitisqu

2007-08-17 08:20:00

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

HowtocopythecontentofastandardWindowsMessageBox?Itsmucheasierthanyoucouldimage!1)ActivatethisMessageBox(ClicktheCaptionoftheMessageBox)2)PressCtrl+ConthisMessag

2007-08-17 08:15:00

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

SQLServerallowsdeveloperstoquerySQLServerandreceivedatainXMLformatviaaspecialclause:FORXML.Thisclauseprovides4differentmodesfortheXMLformatreturned:RAW,AUTO,EXPLICITa

2007-03-15 11:23:00

The automation of COM+ configuration via COMAdmin (COM)

Initialization:COMAdminCatalog.Connect("127.0.0.1"); GetCollections(COMAdminCatalogCollection):Forthe1stlevel(e.g.Applications):applicationCollection =COMAdminCatalog.GetCollection(

2007-03-14 04:17:00

Xml 查漏补缺笔记

 Specialsymbol:SylvieAronsonTheleft/rightanglebracketsshouldbereplacedwith</>inxmlnode:Sylvie<Bellie>Aronson XML&CSS:Xml:xmlversion="1.0"?>xml:styleshe

2007-02-28 09:54:00

Unicode versus ANSI

Question:SowhatisthedifferencebetweenUnicode(i386ur)andANSI(i386r)?Answer:Putsimply,aUnicodeprogramisaspecialversionthatrunsslightlyfasterthananANSIone,butonlyrunsonWi

2007-02-16 02:47:00

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

Issue:WhenIstarted todebugaCom+projectwithVC8,Isawmanyincorrect valueinthewatchwindow,andabnormalstepthroughpath ForsomeCStringvariable:WhenIwatchthem, Icannots

2006-12-22 08:19:00

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

Issue:WhenIupgradeanexeprojectfromVC7.1toVC8,itsaysupgradesucceed. ButWhenItrytocompiletheproject,itoutputsalotoferrors. ../debug/msado15.tlh(1024):errorC2327:C

2006-12-22 07:42:00

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

WhenIrunintotheissueofthewindowsinstalleronmycomputer,IjustnoticedIcannotinstallanysoftwareviawindowsinstaller.Ijustgotthemessageof“InternalError2203,C:/Windows/Insta

2006-12-13 06:50:00

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

Issue:AnATL/COMprojectcanbebuiltandregisteredsuccessfullyunderVC7.1/VS2003.AfterupgradethisprojecttoVC8/VS2005usingtheupgradewizard,itcanbebuiltsuccessfullybutcannotreg

2006-12-13 03:37:00

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

1)AllPrograms->Accessories->Entertainment->SoundRecorder2)OpentheWavfilewithSoundRecorder3)ClickFile->SaveAs,theSaveAsdialogappears.4)Choose"AllFiles(*.*)"fortheSaveas

2006-10-31 02:20:00

写了个小函数,从XML文件转换到CSV文件的

第一次用C#里面的XmlDataDocument类,发现真好用:)  publicvoidTransfer(stringinXmlFilename,stringoutCSVFilename)  {   //openorcreate   FileStreamfileCsv=newFileStream(outCSVFilename,FileMode.OpenOrCreate,F

2005-06-06 19:22:00

第一次写带参数的bat

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

2005-06-01 11:34:00

SQL Server中直接循环写入数据

构建测试表很有用,呵呵,事实上我就是老记不住SQLServer支持While循环,我总是习惯用FOR循环,结果在帮助里查半天总是找不到。  declare@iintset@i=1while@ibegin  insertintotable(colume)values(@i)  set@i=@i+1end---------------------------------------

2005-03-15 11:27:00

花了很长时间帮司文写产品介绍,司文别忘了请我吃饭

请大家选用Siwen的XNote,真的相当好用哦,www.siwen.com======================================原文=========================================SiwenXNote3.2    XNotewascreatedtogiveyouaneasyan

2005-01-25 18:39:00

Com小结(VC)

1.编写COM    接口的声明:2处            .idlfile                interfaceIPage:IDispatch{                         [id(1),helpstring("MethodUpdate")]HRESULTUpdate([in]LONGbSave);                      

2005-01-04 11:44:00
奖章
  • 领英
    领英
    绑定领英第三方账户获取
  • 持之以恒
    持之以恒
    授予每个自然月内发布4篇或4篇以上原创或翻译IT博文的用户。不积跬步无以至千里,不积小流无以成江海,程序人生的精彩需要坚持不懈地积累!