Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQLÓï¾äµ¼Èëµ¼³ö´óÈ«

ÕâÊÇ¡¶VC++¶¯Ì¬Á´½Ó¿â(DLL)±à³ÌÉîÈëdz³ö¡·µÄµÚËIJ¿·Ö£¬ÔĶÁ±¾ÎÄǰ£¬ÇëÏÈÔĶÁǰÈý²¿·Ö£º£¨Ò»£©
¡¢£¨¶þ£©
¡¢£¨Èý£©
¡£
¡¡¡¡MFCÀ©Õ¹DLLµÄÄÚº­ÎªMFCµÄÀ©Õ¹£¬Óû§Ê¹ÓÃMFCÀ©Õ¹DLL¾ÍÏñʹÓÃMFC±¾ÉíµÄDLLÒ»Ñù¡£³ýÁË¿ÉÒÔÔÚMFCÀ©Õ¹DLLµÄÄÚ²¿Ê¹ÓÃMFCÒÔÍ⣬MFCÀ©Õ¹DLLÓëÓ¦ÓóÌÐòµÄ½Ó¿Ú²¿·ÖÒ²¿ÉÒÔÊÇMFC¡£ÎÒÃÇÒ»°ãʹÓÃMFCÀ©Õ¹DLLÀ´°üº¬Ò»Ð©MFCµÄÔöÇ¿¹¦ÄÜ£¬Æ©ÈçÀ©Õ¹MFCµÄCStatic¡¢CButtonµÈÀàʹ֮¾ß±¸¸üÇ¿´óµÄÄÜÁ¦¡£
¡¡¡¡Ê¹ÓÃVisual C++Ïòµ¼Éú²úMFCÀ©Õ¹DLLʱ£¬MFCÏòµ¼»á×Ô¶¯Ôö¼ÓDLLµÄÈë¿Úº¯ÊýDllMain£º
extern "C" int APIENTRY
DllMain(HINSTANCE hInstance, DWORD dwReason, LPVOID lpReserved)
{
 // Remove this if you use lpReserved
 UNREFERENCED_PARAMETER(lpReserved);
 if (dwReason == DLL_PROCESS_ATTACH)
 {
  TRACE0("MFCEXPENDDLL.DLL Initializing!\n");
  // Extension DLL one-time initialization
  if (!AfxInitExtensionModule(MfcexpenddllDLL, hInstance))
   return 0;
  // Insert this DLL into the resource chain
  // NOTE: If this Extension DLL is being implicitly linked to by
  //  an MFC Regular DLL (such as an ActiveX Control)
  //  instead of an MFC application, then you will want to
  //  remove this line from DllMain and put it in a separate
  //  function exported from this Extension DLL.  The Regular DLL
  //  that uses this Extension DLL should then explicitly call that
  //  function to initialize this Extension DLL.  Otherwise,
  //  the CDynLinkLibrary object will not be attached to the
  //  Regular DLL's resource chain, and serious problems will
  //  result.
  new CDynLinkLibrary(MfcexpenddllDLL);
 }
 else if (dwReason == DLL_PROCESS_DETACH)
 {
  TRACE0("MFCEXPENDDLL.DLL Terminating!\n");
  // Terminate the library before destructors are called
  AfxTermExtensionModule(Mf


Ïà¹ØÎĵµ£º

linq »ñÈ¡Êý¾Ý¿âʱ¼ä »òÕßÖ´ÐÐÆäËû´ø·µ»ØÖµµÄsql²éѯ

 using (LongXingDBDataContext db = new LongXingDBDataContext())
             {
                 DeviceInfo di;
        ......

ÈçºÎ²é¿´SQL Server 2005°æ±¾ MS2005°æ±¾ MS2000°æ±¾

Ҫȷ¶¨ËùÔËÐÐµÄ SQL Server 2005 µÄ°æ±¾£¬ÇëʹÓà SQL Server Management Studio Á¬½Óµ½ SQL Server 2005£¬È»ºóÔËÐÐÒÔÏ Transact-SQL Óï¾ä£º
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
½á¹û£º
RTM 2005.90.1399
SQL Server 2005 Service Pack 1 2005.90. ......

Sql Server »ù´¡

Èí¼þ £º Sql Server 2005
 
    ÕâÀï²¢²»ÊÇSQLÓï·¨´óÈ«£¬ÒÔÏÂÊdz£ÓõÄÓï¾ä£¬¶Ô£¨Êý¾Ý¿â¡¢±í¡¢×ֶΡ¢Êý¾Ý£©µÄÔöɾ¸Ä²é£¬Èç¹ûÐèÒªÏêÏ¸È«ÃæµÄTransact-SQLÓï¾ä£¬¿ÉÒÔ²éSql ServerÁª»ú´ÔÊ飬ÄÇÀïÊÇ×îÈ«µÄ×ÊÁÏ£¬Ò»°ã°²×°Sql Server¶¼»áĬÈϰ²×°¡£
´ò¿ªSql ServerÁª»ú´ÔÊé
¿ªÊ¼ à ³ÌÐò à&n ......

SQL Server2005SQLCLR´úÂ밲ȫ֮ȨÏÞ

Ò»¡¢ SQLCLRȨÏÞ¼¯¼¶±ð
 
¡¡¡¡µ±ÄãʹÓÃCREATE ASSEMBLYÓï¾ä°ÑÒ»¸ö³ÌÐò¼¯¼ÓÔØµ½Ò»¸öÊý¾Ý¿âÖÐʱ£¬SQL ServerÌṩÁËÈýÖÖȨÏÞ¼¯¼¶±ð£ºSAFE£¬EXTERNAL_ACCESSºÍUNSAFE¡£ÕâЩȨÏÞ¼¯ÐγÉÈçͼ3ºÍͼ5£¨¾ùÇë²Î¿¼µÚ¶þƪ£©ËùʾµÄ AppDomain²ßÂÔ¼¶±ð¡£
 
¡¡¡¡ÏÂÃæÊÇÒ»¸öµäÐ͵ÄÓï¾ä£¬ËüʵÏÖ°²×°Î»ÓÚFileLoader.dllÎļþÄÚµ ......

C# ±àдSQL SERVER 2005 µÄ´æ´¢¹ý³Ì


ÒÔÏÂÊÇÒ»¸ö²éѯIPµØÖ·¹éÊôµØµÄCLR´æ´¢¹ý³Ì£¬Èý²½£º
1¡¢ÓÃC#À´×öDLL£¬´úÂëÈçÏ£º
//====================================================================
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlTypes;
using System.Data.SqlClient;
using Microsoft.Sq ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ