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

SQLServer 2005 ÖеÄÀàÐÍ Óë C# ÖеÄÀàÐÍ ¶ÔÓ¦ ¹ØÏµ

<Language from="SQL" To="C#">
   <Type from="bigint" To="long" />
   <Type from="binary" To="object" />
   <Type from="bit" To="bool" />
   <Type from="char" To="string" />
   <Type from="datetime" To="DateTime" />
   <Type from="decimal" To="decimal" />
   <Type from="float" To="double" />
   <Type from="image" To="byte[]" />
   <Type from="int" To="int" />
   <Type from="money" To="decimal" />
   <Type from="nchar" To="string" />
   <Type from="ntext" To="string" />
   <Type from="numeric" To="decimal" />
   <Type from="nvarchar" To="string" />
   <Type from="real" To="float" />
   <Type from="smalldatetime" To="DateTime" />
   <Type from="smallint" To="short" />
   <Type from="smallmoney" To="decimal" />
   <Type from="text" To="string" />
   <Type from="timestamp" To="byte[]" />
   <Type from="tinyint" To="byte" />
   <Type from="uniqueidentifier" To="Guid" />
   <Type from="varbinary" To="byte[]" />
   <Type from="varchar" To="string" />
   <Type from="xml" To="string" />
   <Type from="sql_variant" To="object" />
</Language>
<Language from="SQL" To="C# System Types">
   <Type from="bigint" To="System.Int64" />
   <Type from="binary" To="System.Object" />
   <Type from="bit" To="System.Boolean" />
   <Type from="char" To="System.String" />
   <Type from="datetime" To="System.DateTime" />
   <Type from="decimal" To="System.Decimal" />
   <Type from="float" To="System.Double" />
  


Ïà¹ØÎĵµ£º

ʵÏÖsqlserver·ÖÒ³²éѯÓï¾ä

 sqlServer£º
Ò»´Î²éѯ£¬Êý¾Ý¿âÖ»·µ»ØÒ»Ò³µÄÊý¾Ý¡£¶ø²»ÊÇÈ¡³öËùÓеÄÊý¾Ý¡£
pagesize£º ÿҳÏÔʾ¼Ç¼Êý
cureentpage£ºµ±Ç°Ò³Êý
select * from (   select TOP pagesize * from ( SELECT TOP pagesize*cureentpage   * from my_table   ORDER BY id ASC ) as amyTable   OR ......

sqlserver¸Ä±äÊÇ·ñÇø·Ö´óСд

²é¿´ÊÇ·ñÇø·Ö´óСд-Ö´Ðд洢¹ý³Ìsys.sp_server_info
exec sys.sp_server_info
²é¿´µÚ18ÐÐCOLLATION_SEQ-collationÊôÐÔ
charset=cp936 collation=Chinese_PRC_CS_AS
csÎªÇø·Ö´óСд£¬CIΪ²»Çø·Ö´óСд
½«Çø·Ö´óСд¸ÄΪ²»Çø·Ö´óСд
alter database yourDB COLLATE Chinese_PRC_CI_AS
½«²»Çø·Ö´óСд¸ÄÎªÇø·Ö´óСд ......

SWFÖ®¼äͨÐÅ¡¢FlexÓëSWFÖ®¼äͨÐÅ¡¢C#ÓëSWFÖ®¼äͨÐÅ


SWFÖ®¼äͨÐÅ¡¢FlexÓëSWFÖ®¼äͨÐÅ¡¢C#ÓëSWFÖ®¼äͨÐÅ
Ò»¡¢SWFÖ®¼äͨÐÅ£¨¸÷SWFÎļþ¾ùûÓаüº¬¹ØÏµ——·ÇÄÚ²¿Ç¶Èë¼ÓÔØ£¬¾ù¶ÀÁ¢£©
ʹÓà LocalConnection Àà¿ÉÒÔ´´½¨Ò»¸ö LocalConnection ¶ÔÏ󣬸öÔÏó¿ÉÔÚÒ»¸ö SWF ÎļþÖлò¶à¸ö SWF Îļþ¼ä£¬µ÷ÓÃÁíÒ»¸ö LocalConnection ¶ÔÏóÖеķ½·¨¡£ ͨ¹ý±¾µØÁ¬½Ó£¬¿ÉÒÔÔÚ SWF ......

ÊÖ°ÑÊÖ½ÌÄãC#¶ÁÈ¡XMLÎļþ

C#¶ÁÈ¡XML×ÊÁÏ
Ò» C#¶ÁÈ¡XML×ÊÁÏ
À©³ä±ê¼ÇÓïÑÔXML£¨eXtensible Markup Language£©£¬ÊÇÓÉWÈýC»ú¹ØÖƶ©µÄ¡£×öΪÓÃÒÔ´úÌæHTMLÓïÑÔµÄÒ»ÖÖÐÂʽµÄ±ê¼ÇÓïÑÔ£¬XMLÄÚ²¿ÓÐןܶà¸ù±¾»ù×¼£¬XMLÄËÊǾ­¹ýÓëÕâЩÏà¸É»ù×¼µØ×éºÏ£¬Ó¦ÓÃÓÚ¿ÆÑ§¼ÆËã¡¢µç×Ó³ö°æ¡¢¶àýÌåϵÌåÀý×÷ºÍµç×ÓÉÌÎñµÄ¡£C££×÷ΪһÖÖÐÂʽµÄ³ÌÐòÓïÑÔ£¬ÊÇ.Net¹¹¼ÜµÄÒ»¸öÖ ......

C#²Ù×÷SQL ServerÊý¾Ý¿â(ת)


Visual C#Öж¯Ì¬²Ù×÷SQL ServerÊý¾Ý¿â £¨1£©
 
·¢²¼Ê±¼ä£º2003.01.14 10:09     À´Ô´£ºÈüµÏÍø    ×÷ÕߣºÍõ¿­Ã÷
ÔÚ±àдÊý¾Ý¿âÓ¦ÓóÌÐòµÄʱºò£¬ÎÒÃÇ¿ÉÒÔͨ¹ýSQLÓï¾äÀ´¶¯Ì¬´´½¨¡¢ÐÞ¸ÄÊý¾Ý¿âÒÔ¼°ÆäÖеĶÔÏó¡£±¾ÎÄÎÒ¾ÍÏò´ó¼Ò½éÉÜÈçºÎÔËÓÃVisual C#À´¶¯Ì¬²Ù×÷SQL ServerÊý¾Ý¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ