Diff for "WorkBook" UserPreferences
 
Help Info Print View Search Diffs Edit
 À妽º   Ã£±â   Freeboard   Subjectless   Images   ÃÖ±Ù±Û 

Differences between version dated 2004-10-25 12:01:02 and 2006-05-10 15:05:44 (spanning 92 versions)
Deletions are marked like this.
Additions are marked like this.

ÀÛ¾÷ ³ëÆ®.

[[HTML(<table border=0 cellpadding=0 cellspacing=0 width="100%"><tr>)]]

[[HTML(<td valign="top">)]]

ÀÛ¾÷ ³ëÆ®. ¹®µÎ»ðÀÔ¹æ½ÄÀ¸·Î °»½Å(¸Ç À§ÀÇ ³»¿ëÀÌ °¡Àå ÃÖ±Ù ³»¿ëÀÓ)

 

===== ¿ÀÈÄ 2:29 2006-05-10 =====

comshare viewmanager

 %winnt%\eqlsrvr.ini ; ¼­¹ö ConnectionString ¹× ±âŸµîµî ¼³Á¤ [Channels]

 viewmanagerÀÇ applicationÀº sql anal. database¿¡ ÇØ´ç.

        viewmanagerÀÇ database´Â sql anal.ÀÇ cube¿¡ ÇØ´ç

 

===== ¿ÀÈÄ 10:27 2006-03-04 =====

sprintf(a, "%02.2X", 12); // hex °ª µÎ ÀÚ¸®·Î º¸¿©ÁÖ°í ½ÍÀ» ¶§

 

===== ¿ÀÈÄ 4:45 2006-02-23 =====

[http://www.c-sharpcorner.com/Internet/CreatingWebServerInCSIMA.asp Creating your own Web Server using C#]

[http://www.webreference.com/programming/asp_net/index.html Creating your own Web Server using C# #2]

 

°£´ÜÇÑ À¥ ¼­¹ö¸¦ ¸¸µå´Â ¹ý¿¡ ´ëÇÑ ¾ÆƼŬ. ³ªÁß¿¡ ½á¸ÔÀ» µ¥°¡ ÀÖÀ» °Íµµ °°Àºµ¥..

 

===== ¿ÀÀü 11:51 2006-02-02 =====

Oracle¿¡¼­ ¹®ÀÚ¿­ ÇÕÄ¡´Â ÇÔ¼ö : concat(a, b)

 

===== ¿ÀÈÄ 9:09 2006-01-18 =====

mac address¸Æ ¾îµå·¹½º °¡Á®¿À´Â ¹æ¹ý¿¡ ´ëÇÑ ¸µÅ©

http://tangentsoft.net/wskfaq/advanced.html#macaddr

http://support.microsoft.com/default.aspx?scid=kb;en-us;118623

 

 

[[HTML(</td>)]]

[[HTML(<td width=25>&nbsp;</td>)]]

[[HTML(<td width=1 bgcolor=#aaaaaa><img src=/images/blank.gif width=1></td>)]]

[[HTML(<td width=25>&nbsp;</td>)]]

 

[[HTML(<td valign="top">)]]

 

===== '''ÇÏÀ§ ¸µÅ©''' =====

°³ÀÎ ÇÁ·ÎÁ§Æ®

 * [Dolphin]

 * [EEL]

 

´Ù¸¥ Workbook

 * [MSSqlWorkBook]

 * [FlashWorkBook]

 * [.NetWebServiceWorkBook]
 * [PocketPCWorkBook]
 * [GP32WorkBook]
 * [PalmWorkBook]
 

Archive

 * WorkBook2003

 * WorkBook2004

 * WorkBook2005

 

¹ä¹úÀÌ°ü·Ã

 * [À߸Ա¸Àß»ì¾Æº¸¼¼] ; ¾Æ¸¶ 2003³â 6¿ù Á¾·á·Î ÃßÁ¤.. -_-a
 * [RegressionAnalyzingGrapher] 2004.5.25. ~ 2004.7.1.
 * [DataLoggerManager] 2004.9.30. ~

----

===== ¿ÀÀü 11:53 2004-10-25 =====

Visual Studio .NET Bootstrapper

http://msdn.microsoft.com/vstudio/downloads/tools/bootstrapper/

 

Visual Studio .NET 2003 Hosted Experience

http://msdn.microsoft.com/vstudio/tryit/

 

Visual Basic 2005 Express Edition Beta

http://lab.msdn.microsoft.com/express/vbasic/default.aspx

 

Introducing the Visual Basic .NET Power Pack

http://msdn.microsoft.com/vbasic/default.aspx?pull=/library/en-us/dv_vstechart/html/vbpowerpack.asp

 

Visual Basic At The Movies

http://msdn.microsoft.com/vbasic/atthemovies/

 

Windows Mobile > Tools and Downloads

http://msdn.microsoft.com/mobility/windowsmobile/downloads/

 

Smart Client Development

http://msdn.microsoft.com/smartclient/

 

Visual Basic Dev

http://msdn.microsoft.com/vbasic/default.aspx

 

GotDotNet User Sample: Cave Man Hank (.net compact framework)

http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=aef48b4c-9345-4138-ac75-0248bc5b7691

 

ASP.NET Web: The Official Microsoft ASP.NET Site

http://www.asp.net/

 

===== ¿ÀÈÄ 2:43 2004-10-22 =====

M$°è¿­ ¼­¹ö ºÎÇÏ Åë°è ¾Ë¾Æº¸±â

¼º´É¸ð´ÏÅ͸µÀ» È°¿ëÇÏ´Â ¹æ¹ý

http://mudmania.org/reiot/PerformanceMonitoring

 

Web Application Stress ToolÀÇ ÀÌ¿ë

http://support.microsoft.com/default.aspx?scid=kb;KO;231282

http://www.microsoft.com/downloads/details.aspx?FamilyID=e2c0585a-062a-439e-a67d-75a89aa36495&DisplayLang=en

 

mrtg

http://mrtg.co.kr/

http://snmpboy.msft.net/default.aspx

 

log ºÐ¼®

http://awstats.sourceforge.net

 

http://gotdotnet.com ´å³Ý °ü·Ã

http://www.debuglab.com/ µð¹ö±×·¦

 

.NET: Visual Basic .NET

Getting Started with Visual Basic .NET

http://msdn.microsoft.com/library/en-us/dnaa/html/getstart_vbasic.asp

Printed pages 19

 

Getting Started with Visual C# .NET

http://msdn.microsoft.com/library/en-us/dnaa/html/getstart_vcsharp.asp

Printed pages 20

.NET: Visual C++.NET

 

Getting Started with Visual C++ .NET

http://msdn.microsoft.com/library/en-us/dnaa/html/getstart_vcppn.asp

Printed pages 20

Other

 

Getting Started with Visual C++

http://msdn.microsoft.com/library/en-us/dnaa/html/getstart_vcpp.asp

Printed pages 20

 

===== ¿ÀÈÄ 12:54 2004-10-13 =====

[http://zdnet.co.kr/techupdate/lecture/dotnet/0,39024986,39130808,00.htm ´å³Ý ÇÁ·ÎÁ§Æ®¸¦ Á¤º¹Ç϶ó - ¨ç ÀÌ·¡¼­ ¾ÈµÇ´Â°Å±º!]

 

[http://www.codeworks.it/net/VBNetRs232.htm Serial Communication with VB.Net]

[http://www.gotdotnet.com/Community/UserSamples/Default.aspx?query=serial GotDotNet User Samples - serial]

[http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=8aaa0158-95b6-49a7-bb20-93391fc4c196 GotDotNet User Sample: RS232-Serial comunication class (update)]

[http://www.zen13120.zen.co.uk/Blog/2004/09/serial-rs232-communications-in-net.html The Moth - Serial (RS232) communications in .NET]

 

===== ¿ÀÈÄ 10:25 2004-09-08 =====

http://www.microsoft.com/korea/windowsserversystem/virtualserver/evaluation/rceval.asp

Microsoft Virtual Server 2005, Enterprise Edition RC ¹öÀü ÆäÀÌÁö.

 

Virtual pc°¡ windows 2003À¸·Î ³Ñ¾î°¡¸é¼­, À̸§±îÁö ¹Ù²ãÄ¡·Á´Â ¸ð¾ç.

¼­¹ö Çϳª ¸¶·ÃÇؼ­ ¹º°¡ Á» Çغ¼±î...

 

===== ¿ÀÈÄ 9:56 2004-09-03 =====

bstr to char

{{{

#include <comdef.h>

 

...

 

CString strLine;

_bstr_t bstrText( strText );

strLine.Format( "%s", LPCSTR( bstrText ) );

}}}

 

===== ¿ÀÀü 9:50 2004-08-20 =====

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q186133

How to dynamically number rows in a SELECT Statement ; °£´ÜÈ÷, oracleÀÇ rownum °°Àº °ÍÀ» ¾²±â À§ÇÑ ²Ç¼ö

 

===== ¿ÀÈÄ 6:00 2004-08-19 =====

atl¿¡¼­ objectsafety¸¦ ±¸ÇöÇÏ´Â°Ç ´Ü¼øÈ÷ ´ÙÀ½ÀÇ ÀÎÅÍÆäÀ̽º¸¦ »ó¼Ó¹Þ¾ÆÁÖ¸é ³¡ :

{{{

public IObjectSafetyImpl<CKioPhotoPaymentCtrl, INTERFACESAFE_FOR_UNTRUSTED_CALLER | INTERFACESAFE_FOR_UNTRUSTED_DATA>

}}}

===== ¿ÀÈÄ 2:22 2004-08-17 =====

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaxctrl/html/msdn_abcsmfc.asp

The ABCs of MFC ActiveX Controls (ActiveX Controls Technical Articles)

 

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaxctrl/html/msdn_signmark.asp

Signing and Marking ActiveX Controls

 

Upload:helpers.zip

{{{

ObjectSafety °ü·Ã ·¹Áö½ºÆ®¸® ÀÚ°¡ µî·Ï µµ¿ÍÁÖ´Â ÄÚµå

Âü°í·Î ·¹Áö½ºÆ®¸® µî·Ï ÄÚµå´Â DllRegisterServer()¿¡¼­ Çصµ µÇÁö¸¸,

clsid¸¦ °¡Á®´Ù ¾´´Ù´ø°¡ÀÇ ¹®Á¦°¡ ÀÖÀ¸¹Ç·Î..

ÄÁÆ®·Ñ::CKioPhotoCtrlFactory::UpdateRegistry ÇÔ¼ö¿¡¼­ µî·ÏÇϵµ·Ï ÇÏÀÚ.

}}}

 

===== ¿ÀÀü 11:53 2004-08-17 =====

http://www.codeproject.com/system/serial.asp ½Ã¸®¾ó Åë½Å¿ë Wrapper Class.

 

===== ¿ÀÀü 11:39 2004-08-16 =====

ºê¶ó¿ìÀú¿¡¼­ ¸¶¿ì½º Å°º¸µå ¸·±â (ie ±âÁØ)

{{{

// Å°º¸µå ¸·±â

document.onkeydown=KeyEventHandle;

document.onkeyup=KeyEventHandle;

 

function KeyEventHandle() {

 if ( (event.ctrlKey == true && (event.keyCode == 78 || event.keyCode == 82)) || (event.keyCode >= 117 && event.keyCode <= 123) ) {

  event.keyCode = 0;

  event.cancelBubble = true;

  event.returnValue = false;

 }

}

 

// ¸¶¿ì½º ¸·±â

document.onmousedown = mouseright;

function mouseright(e) {

 if (navigator.appName == 'Netscape' && (e.which == 3 || e.which == 2)) {

  return false;

 } else if (navigator.appName == 'Microsoft Internet Explorer' && (event.button == 2 || event.button == 3)) {

  return false;

 }

 

 return true;

}

}}}

===== ¿ÀÀü 11:08 2004-08-16 =====

vb¿¡¼­ ocx ¸¸µé ¶§ IObjectSafety ÀÎÅÍÆäÀ̽º ±¸Çö

 : ÀÌ°É ±¸ÇöÇØÁà¾ß '½Ã½ºÅÛ¿¡ ¹º°¡ ¾ÈÁÁÀº°É ½ÃµµÇϴµª¼î?' ¸Þ½ÃÁö¸¦ ¸·À» ¼ö ÀÖÀ½

{{{

' ¸ÞÀÎ ¸ðµâ¿¡ »ðÀÔÇÏ´Â ºÎºÐ

 

Global gPortOpen As Boolean

Global gVIewMode As Integer

Option Explicit

 

      Public Const IID_IDispatch = "{00020400-0000-0000-C000-000000000046}"

      Public Const IID_IPersistStorage = _

        "{0000010A-0000-0000-C000-000000000046}"

      Public Const IID_IPersistStream = _

        "{00000109-0000-0000-C000-000000000046}"

      Public Const IID_IPersistPropertyBag = _

        "{37D84F60-42CB-11CE-8135-00AA004BB851}"

 

      Public Const INTERFACESAFE_FOR_UNTRUSTED_CALLER = &H1

      Public Const INTERFACESAFE_FOR_UNTRUSTED_DATA = &H2

      Public Const E_NOINTERFACE = &H80004002

      Public Const E_FAIL = &H80004005

      Public Const MAX_GUIDLEN = 40

 

      Public Declare Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" _

         (pDest As Any, pSource As Any, ByVal ByteLen As Long)

      Public Declare Function StringFromGUID2 Lib "ole32.dll" (rguid As _

         Any, ByVal lpstrClsId As Long, ByVal cbMax As Integer) As Long

 

      Public Type udtGUID

          Data1 As Long

          Data2 As Integer

          Data3 As Integer

          Data4(7) As Byte

      End Type

 

      Public m_fSafeForScripting As Boolean

      Public m_fSafeForInitializing As Boolean

 

      Sub Main()

          m_fSafeForScripting = True

          m_fSafeForInitializing = True

      End Sub

 

 

' ÄÁÆ®·Ñ Äڵ忡 »ðÀÔÇÏ´Â ºÎºÐ

 

Private Sub IObjectSafety_GetInterfaceSafetyOptions(ByVal riid As _

      Long, pdwSupportedOptions As Long, pdwEnabledOptions As Long)

 

          Dim Rc As Long

          Dim rClsId As udtGUID

          Dim IID As String

          Dim bIID() As Byte

 

          pdwSupportedOptions = INTERFACESAFE_FOR_UNTRUSTED_CALLER Or _

                                INTERFACESAFE_FOR_UNTRUSTED_DATA

 

          If (riid <> 0) Then

              CopyMemory rClsId, ByVal riid, Len(rClsId)

 

              bIID = String$(MAX_GUIDLEN, 0)

              Rc = StringFromGUID2(rClsId, VarPtr(bIID(0)), MAX_GUIDLEN)

              Rc = InStr(1, bIID, vbNullChar) - 1

              IID = Left$(UCase(bIID), Rc)

 

              Select Case IID

                  Case IID_IDispatch

                      pdwEnabledOptions = IIf(m_fSafeForScripting, _

                    INTERFACESAFE_FOR_UNTRUSTED_CALLER, 0)

                      Exit Sub

                  Case IID_IPersistStorage, IID_IPersistStream, _

                     IID_IPersistPropertyBag

                      pdwEnabledOptions = IIf(m_fSafeForInitializing, _

                    INTERFACESAFE_FOR_UNTRUSTED_DATA, 0)

                      Exit Sub

                  Case Else

                      Err.Raise E_NOINTERFACE

                      Exit Sub

              End Select

          End If

      End Sub

 

      Private Sub IObjectSafety_SetInterfaceSafetyOptions(ByVal riid As _

      Long, ByVal dwOptionsSetMask As Long, ByVal dwEnabledOptions As Long)

          Dim Rc As Long

          Dim rClsId As udtGUID

          Dim IID As String

          Dim bIID() As Byte

 

          If (riid <> 0) Then

              CopyMemory rClsId, ByVal riid, Len(rClsId)

 

              bIID = String$(MAX_GUIDLEN, 0)

              Rc = StringFromGUID2(rClsId, VarPtr(bIID(0)), MAX_GUIDLEN)

              Rc = InStr(1, bIID, vbNullChar) - 1

              IID = Left$(UCase(bIID), Rc)

 

              Select Case IID

                  Case IID_IDispatch

                      If ((dwEnabledOptions And dwOptionsSetMask) <> _

                   INTERFACESAFE_FOR_UNTRUSTED_CALLER) Then

                          Err.Raise E_FAIL

                          Exit Sub

                      Else

                          If Not m_fSafeForScripting Then

                              Err.Raise E_FAIL

                          End If

                          Exit Sub

                      End If

 

                  Case IID_IPersistStorage, IID_IPersistStream, _

                IID_IPersistPropertyBag

                      If ((dwEnabledOptions And dwOptionsSetMask) <> _

                    INTERFACESAFE_FOR_UNTRUSTED_DATA) Then

                          Err.Raise E_FAIL

                          Exit Sub

                      Else

                          If Not m_fSafeForInitializing Then

                              Err.Raise E_FAIL

                          End If

                          Exit Sub

                      End If

 

                  Case Else

                      Err.Raise E_NOINTERFACE

                      Exit Sub

              End Select

          End If

      End Sub

}}}

 

===== ¿ÀÀü 12:48 2004-08-16 =====

atl¿¡ ÅåÅåÈ÷ ´çÇÏ°í ÀÖ´Â Áß.

 

{{{

HWND hWnd;

((IOleInPlaceObjectWindowlessImpl<Ctestatlctrl>*)this)->GetWindow(&hWnd);

::PostMessage(hWnd, WM_PAINT, 0, 0);

}}}

 : ¾ÈµÈ´Ù. ´ëü ¾î´À À©µµ¿ì Çڵ鿡 °¡Á®´Ù°¡ ¸Þ½ÃÁö¸¦ ¹Ú´ÂÁö´Â ¸ð¸£Áö¸¸.

 

ÀÏ´Ü m_rcPos °´Ã¼·Î À̳༮ÀÌ ¾îµð ¹ÚÇôÀÖ´ÂÁö´Â ¾Ë¾Æ ³¾ ¼ö Àִµ¥,

invalidate, invalidaterect µûÀ§ÀÇ ÇÔ¼ö¸¦ ½áµµ...

ºê¶ó¿ìÀú»Ó¸¸ÀÌ ¾Æ´Ï¶ó, È­¸é Àüü°¡ °»½ÅµÇ¾î ¹ö¸°´Ù.

 

{{{

::InvalidateRect(m_hWnd, &m_rcPos, false);

}}}

 : ´ëÃæ ÀÌ·± ½ÄÀε¥, m_rcPosÀÇ °ªÀÌ ¿ÇÀºµ¥µµ ºÒ±¸, false/trueÀÇ °ü°èµµ »ó°ü¾øÀÌ Àüü È­¸éÀ» ´Ù½Ã ±×·Á¹ö¸°´Ù.

 

È£ÃâµÉ¶§¸¶´Ù È­¸é Àüü°¡ ²­¹÷²­¹÷... -_-

 

±×³É mfc·Î Â¥¾ß°Ú´Ù...

 

===== ¿ÀÈÄ 8:20 2004-08-12 =====

ÃÖ±Ù com ÄÁÆ®·ÑÀ» ¸¸µé°í Àִµ¥, ¾öÇÏ°Ô BSTR ¹®ÀÚ¿­À» ÀÏ¹Ý ¾Æ½ºÅ°·Î º¯È¯ÇÏ´À¶ó »ðÁú.

sprintf, wsprintf ÇÔ¼ö·Î char, wchar_t Çü½Ä º¯È¯Àº °¡´ÉÇѵ¥,

 

¹®Á¦´Â.. BSTRÀº multibyte°¡ ¾Æ´Ï¶ó unicode¶ó´Â °Í -_-

MultibyteToWidecharÀΰ¡... ±× ÇÔ¼ö·Î º¯È¯Çß´Ù --;

 

===== ¿ÀÀü 11:24 2004-08-05 =====

Microsoft Win32 to Microsoft .NET Framework API Map

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/win32map.asp

 

===== ¿ÀÈÄ 3:38 2004-07-21 =====

Startup Phases for x86-based Systems

http://www.microsoft.com/resources/documentation/Windows/XP/all/reskit/en-us/Default.asp?url=/resources/documentation/Windows/XP/all/reskit/en-us/prmc_str_reii.asp

 

===== ¿ÀÈÄ 2:33 2004-07-19 =====

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q145/6/79.asp&NoWebContent=1

vb ¿¡¼­ ·¹Áö½ºÆ®¸® ½Ø¿ì±â

 

===== ¿ÀÀü 11:22 2004-07-07 =====

Accessibility °ü·Ã ¸µÅ©

 http://www.msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000544

 http://msdn.microsoft.com/library/default.asp?url=/downloads/list/accessibility.asp

 http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc/html/ATG_TSF.asp

 http://www.microsoft.com/msagent/downloads/user.asp#sr

 

 http://gregshin.pe.kr/atag10/atag10-chklist.html

 À¥ ÀúÀÛ µµ±¸ Á¢±Ù¼º Áöħ 1.0ÀÇ Ã¼Å©Æ÷ÀÎÆ® ¸ñ·Ï

 

===== ¿ÀÀü 11:26 2004-06-04 =====

ÀÚµ¿ ·Î±×¿Â ½Ø¿ì±â

HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon

  AutoAdminLogon = 1

  DefaultUserName = "Administrator"

  DefaultPassword = "password"

 

===== ¿ÀÈÄ 3:54 2004-05-26 =====

[RegressionAnalyzingGrapher] °³¹ß°ü·Ã 1Â÷ ¹ÌÆÃ

 

===== ¿ÀÀü 10:38 2004-05-11 =====

CDO 1.2.1 for Winnt ´º½º Æ÷½ºÆÿë asp ÇÔ¼ö

Win2k Server (sp2)¿¡¼­ Á¤»ó ÀÛµ¿ÇÔ.

news.microsoft.comÀÇ °æ¿ì Æ÷½ºÆÿ¡ 20~30¿©ÃÊ°¡ ¼Ò¿äµÊ.

iframeÀ̳ª Æ˾÷µîÀ» ÀÌ¿ë, ¹é±×¶ó¿îµå¿¡¼­ Æ÷½ºÆõǵµ·Ï ÇÏ´Â °ÍÀÌ ÁÁÀ» µí.

 

{{{

'Configuration¿ë Á¢µÎ¾î-Namespace

const CONFURL = "http://schemas.microsoft.com/cdo/configuration/"

 

function PostNewsThread(host, newsgroup, subject, contenttext, username, useremail)

 Set msg = Server.CreateObject("CDO.Message")

 Set Flds = msg.Configuration.Fields 'Flds´Â ADODB.Fields °´Ã¼ÀÓ

 

 Flds(CONFURL+"postusing") = 2 'cdoPostUsingPort

 Flds(CONFURL+"protocolauthentication") = 0 'cdoAnonymous

 Flds(CONFURL+"nntpserver") = host

 Flds(CONFURL+"nntpserverport") = 119

 Flds(CONFURL+"nntpauthenticate") = 0 'cdoAnonymous

 Flds(CONFURL+"postusername") = username

 Flds(CONFURL+"postnntpaccountname") = username

 Flds(CONFURL+"postpassword") = ""

 Flds(CONFURL+"postemailaddress") = username + " <"+useremail+">"

 Flds(CONFURL+"postuserreplyemailaddress") = username + " <"+useremail+">"

 Flds.Update

 

 msg.Subject = subject

 msg.TextBody = contenttext

 msg.Newsgroups = newsgroup

 msg.From = username + " <"+useremail+">"

 msg.Post

end function

}}}

===== ¿ÀÈÄ 1:30 2004-05-06 =====

[http://support.microsoft.com/default.aspx?scid=kb;KO;q182598 182598 HOWTO: Implement IObjectSafety in Visual Basic Controls]

 

===== ¿ÀÀü 10:36 2004-04-23 =====

wscript¸¦ ÀÌ¿ëÇÑ ·¹Áö½ºÆ®¸® ¾×¼¼½º.txt

{{{

[VBScript]

Dim WshShell, bKey

Set WshShell = WScript.CreateObject("WScript.Shell")

 

WshShell.RegWrite "HKCU\Software\ACME\FortuneTeller\", 1, "REG_BINARY"

WshShell.RegWrite "HKCU\Software\ACME\FortuneTeller\MindReader", "Goocher!", "REG_SZ"

 

bKey = WshShell.RegRead("HKCU\Software\ACME\FortuneTeller\")

WScript.Echo WshShell.RegRead("HKCU\Software\ACME\FortuneTeller\MindReader")

 

WshShell.RegDelete "HKCU\Software\ACME\FortuneTeller\MindReader"

WshShell.RegDelete "HKCU\Software\ACME\FortuneTeller\"

WshShell.RegDelete "HKCU\Software\ACME\"

 

[JScript]

var WshShell = WScript.CreateObject ("WScript.Shell");

 

WshShell.RegWrite ("HKCU\\Software\\ACME\\FortuneTeller\\", 1, "REG_BINARY");

WshShell.RegWrite ("HKCU\\Software\\ACME\\FortuneTeller\\MindReader", "Goocher!", "REG_SZ");

 

var bKey = WshShell.RegRead ("HKCU\\Software\\ACME\\FortuneTeller\\");

WScript.Echo (WshShell.RegRead ("HKCU\\Software\\ACME\\FortuneTeller\\MindReader"));

 

WshShell.RegDelete ("HKCU\\Software\\ACME\\FortuneTeller\\MindReader");

WshShell.RegDelete ("HKCU\\Software\\ACME\\FortuneTeller\\");

WshShell.RegDelete ("HKCU\\Software\\ACME\\");

}}}

 

===== ¿ÀÈÄ 4:00 2004-04-22 =====

msde ¶óÀ̼¾½º °ü·Ã url.

http://www.microsoft.com/sql/msde/howtobuy/msderights.asp

http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp

 

===== ¿ÀÈÄ 12:18 2004-04-21 =====

 ÆÄÀÏ ¼±ÅÃÇßÀ» ¶§, À̹ÌÁö »çÀÌÁî ³À´Ù ¾Ë¾Æ³»´Â ÄÚµå. ('ÆäÀÌÁö¸¦ ¿­ ¶§¸¶´Ù' ¿É¼Ç ÁÖ¸é ³À´Ù ¿ÀÀÛµ¿)

{{{

<script>

function openNewWin(tmpImg)

{

    var newWin;

    newWin = window.open(tmpImg.src, '', 'width='+tmpImg.width+',height='+tmpImg.height);

    newWin.focus();

}

 

function onloadfile(fname)

{

 alert(fname);

 var tmpImg = new Image;

 tmpImg.src = fname;

 tmpImg.onload = openNewWin(tmpImg);

}

</script>

 

<BODY>

<INPUT TYPE="file" name="file1" onChange="onloadfile(this.value);">

</body>

}}}

 

===== ¿ÀÈÄ 11:43 2004-04-09 =====

{{{

/* Å×ÀÌºí »ý¼º SQL */

CREATE TABLE [dbo].[tb1] (

 [ID] [varchar] (10) NOT NULL ,

 [description] [varchar] (50) NOT NULL

) ON [PRIMARY]

GO

 

CREATE TABLE [dbo].[tb2] (

 [idx] [int] IDENTITY (1, 1) NOT NULL ,

 [ID1] [varchar] (10) NULL ,

 [ID2] [varchar] (10) NULL ,

 [ID3] [varchar] (10) NULL ,

 [ID4] [varchar] (10) NULL ,

 [ID5] [varchar] (10) NULL ,

 [ID6] [varchar] (10) NULL ,

 [ID7] [varchar] (10) NULL ,

 [ID8] [varchar] (10) NULL ,

 [ID9] [varchar] (10) NULL ,

 [ID10] [varchar] (10) NULL

) ON [PRIMARY]

GO

/* Å×ÀÌºí »ý¼º SQLÀÇ ³¡ */

 

 

 

/* ½ÇÁ¦ ÇÊ¿äÇÑ ½ºÅ©¸³Æ®ÀÇ ½ÃÀÛ */

/* ÀÏ´Ü ÇʵåÀÇ °¹¼ö´Â 10°³·Î °¡Á¤ */

Declare @d1 varchar(10), @d2 varchar(10), @d3 varchar(10),@d4 varchar(10),@d5 varchar(10),@d6 varchar(10),@d7 varchar(10),@d8 varchar(10),@d9 varchar(10),@d10 varchar(10)

 

CREATE TABLE #temp(tempfield varchar(10) NULL)

 

/* °¢ ÇʵåÀÇ ID °ª¿¡ µû¶ó ¼³¸í¿¡ ÇØ´çÇÏ´Â description Çʵ带 °¡Á®¿È

    ÇʵåÀÇ ID °ªÀÌ NULLÀ̸é ÇØ´ç description Çʵ忡µµ NULL °ªÀÌ µé¾î°£´Ù */

Declare rCursor CURSOR FOR

      SELECT tb1_1.description AS description1, tb1_2.description AS description2,

                tb1_3.description AS description3, tb1_4.description AS description4,

                tb1_5.description AS description5, tb1_6.description AS description6,

                tb1_7.description AS Expr6description7, tb1_8.description AS description8,

                tb1_9.description AS description9, tb1_10.description AS description10

        FROM dbo.tb2

   LEFT OUTER JOIN dbo.tb1 tb1_1 ON dbo.tb2.ID1 = tb1_1.ID

   LEFT OUTER JOIN dbo.tb1 tb1_2 ON dbo.tb2.ID2 = tb1_2.ID

                LEFT OUTER JOIN dbo.tb1 tb1_3 ON dbo.tb2.ID3 = tb1_3.ID

                LEFT OUTER JOIN dbo.tb1 tb1_4 ON dbo.tb2.ID4 = tb1_4.ID

                LEFT OUTER JOIN dbo.tb1 tb1_5 ON dbo.tb2.ID5 = tb1_5.ID

                LEFT OUTER JOIN dbo.tb1 tb1_6 ON dbo.tb2.ID6 = tb1_6.ID

                LEFT OUTER JOIN dbo.tb1 tb1_7 ON dbo.tb2.ID7 = tb1_7.ID

                LEFT OUTER JOIN dbo.tb1 tb1_8 ON dbo.tb2.ID8 = tb1_8.ID

                LEFT OUTER JOIN dbo.tb1 tb1_9 ON dbo.tb2.ID9 = tb1_9.ID

                LEFT OUTER JOIN dbo.tb1 tb1_10 ON dbo.tb2.ID10 = tb1_10.ID

OPEN rCursor

FETCH NEXT From rCursor

        INTO @d1, @d2, @d3, @d4, @d5, @d6, @d7, @d8, @d9, @d10

 

/* ·çÇÁ¸¦ µ¹¸é¼­ NULL ÀÌ ¾Æ´Ñ °ªÀ» Àӽà Å×ÀÌºí¿¡ Áý¾î³Ö´Â´Ù */

WHILE (@@FETCH_STATUS <> -1)

BEGIN

        IF(@d1 IS not null)

 INSERT #temp

  Select @d1

        IF(@d2 IS not null)

 INSERT #temp

  Select @d2

        IF(@d3 IS not null)

 INSERT #temp

  Select @d3

        IF(@d4 IS not null)

 INSERT #temp

  Select @d4

        IF(@d5 IS not null)

 INSERT #temp

  Select @d5

        IF(@d6 IS not null)

 INSERT #temp

  Select @d6

        IF(@d7 IS not null)

 INSERT #temp

  Select @d7

        IF(@d8 IS not null)

 INSERT #temp

  Select @d8

        IF(@d9 IS not null)

 INSERT #temp

  Select @d9

        IF(@d10 IS not null)

 INSERT #temp

  Select @d10

 FETCH NEXT From rCursor

         INTO @d1, @d2, @d3, @d4, @d5, @d6, @d7, @d8, @d9, @d10

END

CLOSE rCursor

DEALLOCATE rCursor

 

/* °á°ú°ª °¡Á®¿À±â */

SELECT *

FROM #temp;

 

/* Àӽà Å×ÀÌºí »èÁ¦ */

DROP TABLE #temp;

}}}

 

===== ¿ÀÈÄ 5:25 2004-04-08 =====

»ðÁúÀº °è¼ÓµÇ°í...

aspÀÇ ÆĶó¸ÞÅÍ °´Ã¼¿Í´Â ¶Ç ´Þ¶óÁø ado.net.

´öºÐ¿¡ ¶Ç »ðÁú... -_-;

 

ÀÌÁ¨ ÇູÇÏ°Ô ÀúÀå ÇÁ·Î½ÃÀú¸¦ Á» ½áº¸ÀÚ... ;¤²;

 

{{{

SqlCommand comm = new SqlCommand();

SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["DSNConnectionString"]);

comm.Connection = conn;

comm.CommandType = CommandType.StoredProcedure;

comm.CommandText = "sp_uGetKeyCode";

SqlParameter param = new SqlParameter("RETURN_VALUE",SqlDbType.Int);

param.Direction = ParameterDirection.ReturnValue;

comm.Parameters.Add(param);

conn.Open();

comm.ExecuteNonQuery();

int nRet = (int)comm.Parameters["RETURN_VALUE"].Value;

conn.Close();

}}}

===== ¿ÀÈÄ 4:44 2004-03-29 =====

T-SQL¿¡ ´«À» ¶á Kenial.

{{{

Declare @count int

Declare rCursor CURSOR FOR

 SELECT * From Cont_TB Order by Colorcode

Set @count = 0

OPEN rCursor

FETCH NEXT FROM rCursor

WHILE (@@FETCH_STATUS <> -1)

 BEGIN

  Set @count = @count + 1

  UPDATE Cont_TB SET Key_Code = @count WHERE CURRENT OF rCursor

  FETCH NEXT FROM rCursor

 END

CLOSE rCursor

DEALLOCATE rCursor

GO

}}}

 

{{{

CREATE PROCEDURE [dbo].[sp_uGetKeyCode] AS

Declare @count int, @rKeyCode int, @row_status int

 

Set @count = 0

Declare rCursor CURSOR FOR

 SELECT Key_Code From Cont_TB Order by Key_Code

OPEN rCursor

FETCH NEXT From rCursor

 INTO @rKeyCode

 

WHILE (@@FETCH_STATUS <> -1)

BEGIN

 Set @count = @count + 1

 Set @row_status = @@FETCH_STATUS

 IF(@count <> @rKeyCode)

 BEGIN

  Set @count = @count - 1

  Break

 END

 FETCH NEXT From rCursor

  INTO @rKeyCode

END

CLOSE rCursor

DEALLOCATE rCursor

RETURN(@count+1)

GO

}}}

 

http://support.microsoft.com/default.aspx?scid=kb;en-us;257405&Product=win2000 ·¥µð½ºÅ© °ü·Ã

 

===== ¿ÀÈÄ 3:36 2004-03-26 =====

¾û¾û ´ëü ¹¹°¡ ¾î¶»°Ô µÈ°Å¾ß ÀÌ°Ç.

ÀÏ´Ü µ¿ÀüÀνıâ´Â Á¦¾î°¡ µÇ´Âµ¥.. VB·Î ¾Ë¾Æº¼ ¼ö ¾ø°Ô § Äڵ嵢¾î¸®.

mscomm °´Ã¼ µûÀ§¸¦ ½á¼­ ÀÌ·¸°Ô ¸¸µé¾î³õ´Ù´Ï..

 

ÀÏ´Ü ±â°è Á¦Àۻ翡¼­ ¸¸µç Äڵ带 ¾²´Â°Å´Ï±î ÀÌ»óÀº ¾ø°ÚÁö¸¸.

rs-232 Åë½Å.. ¾îÈæÀÌ´Ù ÁøÂ¥ ;

 

ºñº£¿¡¼­ ocx ¸¸µé·Á¸é ÀÌ·¸°Ô ÇÏ´Â ¼ö¹Û¿¡ ¾ø´Â°Ç°¡...?

ÁøÂ¥ º¹ÀâÇÏ°í ³­ÀâÇϱⰡ ±Í¼º±æÀÇ ¼­¿ï¿ª¿¡ ±×Áö¾ø±¸³ª ;

 

===== ¿ÀÈÄ 6:33 2004-03-24 =====

À¥¼­ºñ½º ½ÃÀÛ!

 

uddi, wsdl, soap, http.

 

===== ¿ÀÀü 9:46 2004-01-26 =====

http://www.madchick.com/Default.asp?Page=2&SubPage=2 activex °ü·Ã

http://www.component.pe.kr/Lecture/ActiveX/ActiveX.html .net¿¡¼­ activex ¹èÆ÷ÁúÇϱâ

 

===== ¿ÀÈÄ 1:55 2004-01-19 =====

jscript·Î ÇÁ·Î±×·¥ ·±ÄªÇϱâ (·ÎÄÿ¡¼­¸¸ ÀÛµ¿)

{{{

<script>

function fnShellExecuteJ()

{

 var objShell = new ActiveXObject("Shell.Application");

 objShell.ShellExecute("notepad.exe", "", "", "open", 1); // normal window

}

</script>

}}}

 

ÃÊ°£´Ü ado.net ¿¹Á¦ (in C#)

{{{

// ³×ÀÓ½ºÆäÀ̽º Ãß°¡

 

Using System.Data;

Using System.Data.SqlClient;

 

...

 

SqlConnection sCon = new SqlConnection("DB¿¬°á¹®ÀÚ¿­");

SqlCommand sCom = new SqlCommand();

sCom.Connection = sCon;

sCom.CommandType = CommandType.StoredProcedure; // ÀúÀå ÇÁ·Î½ÃÀú¸¦ »ç¿ë ¾ÈÇϸé À̺κÐÀº »ý·«

 

try

{

    if(sCon.State == ConnectionState.Open) // ÀÌ¹Ì ¿­¸° SqlConnection °³Ã¼¸¦ ¶Ç ¿­¶§ ¹ß»ýÇÏ´Â ¿¡·¯ ¹æÁö

        sCon.Close();

    sCom.Transaction = sCon.BeginTransaction(IsolationLevel.ReadCommitted,"Æ®·£Àè¼Ç¸í"); // Æ®·£Àè¼Ç ½ÃÀÛ

 

    ...

    sCom.CommandText = "ÇØ´ç ÇÁ·Î½ÃÀú¸í"; // ÀúÀå ÇÁ·Î½ÃÀú¸¦ »ç¿ë ¾ÈÇÒ °æ¿ì ÀζóÀÎ Äõ¸®¹®

    sCom.ExcuteNonQuery(); // ±âŸ ½ÇÇà¹æ½Äµµ °¡´É

    sCom.CommandText = "ÇØ´ç ÇÁ·Î½ÃÀú¸í";

    sCom.ExcuteNonQuery();

    ...// ÀÌ·± ½ÄÀ¸·Î Äõ¸®¹® ½ÇÇà °è¼Ó.. ·çÇÁµµ ÀÌ ºÎºÐ¿¡¼­ µ¹¸³´Ï´Ù.

 

       // SqlParameter°¡ ÇÊ¿äÇϸé ÇØ´çÄõ¸® ½ÇÇà Àü¿¡ Add ¶Ç´Â Clear ¶Ç´Â RemoveAt ¸Þ¼Òµå »ç¿ëÇØ ÁÖ±¸¿ä..

 

    // ¿©±â±îÁö ¿¡·¯°¡ ¾øÀ¸¸é Commit ÇØÁÜ

    sCom.Transaction.Commit();

}

catch(SqlException ex)

{

    // ¿¡·¯°¡ ¹ß»ýÇϸé Rollback ÇØÁÜ

    sCom.Transaction.Rollback();

}

finally

{

    sCon.Close();

}

}}}

 * [Á¼®¿¹¾à°ü¸®½Ã½ºÅÛ] 2004-11-20 ~

 

 

[[HTML(</td>)]][[HTML(</tr></table>)]]

----
[ÇÁ·Î±×·¡¹ÖºÐ·ù]

PythonPowered ShowText of this page
EditText of this page
FindPage by browsing, searching, or an index
Or try one of these actions: DeletePage, DeleteUploadedFile, LikePages, SpellCheck, UploadFile