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£º
Ò»´Î²éѯ£¬Êý¾Ý¿âÖ»·µ»ØÒ»Ò³µÄÊý¾Ý¡£¶ø²»ÊÇÈ¡³öËùÓеÄÊý¾Ý¡£
pagesize£º ÿҳÏÔʾ¼Ç¼Êý
cureentpage£ºµ±Ç°Ò³Êý
select * from ( select TOP pagesize * from ( SELECT TOP pagesize*cureentpage * from my_table ORDER BY id ASC ) as amyTable OR ......
µ±SQLServerµÄϵͳÈÕÖ¾¹ý´ó£¬¾Í»áÒýÆðSQLServer·þÎñÆ÷ÎÞ·¨Æô¶¯µÈһϵÁÐÎÊÌâ¡£½ñÌìÎÒÓöµ½ÁËÕâ¸öÎÊÌ⣬ÔÚÍøÉÏËÑË÷ÁËһϣ¬½â¾ö·½·¨ÊÇɾ³ý¾Í¿ÉÒÔÁË£¬¿ÉÊǵ±Ç°µÄErrorLogÕýÔÚ±»SQLʹÓÃÎÞ·¨É¾³ý°¡£¬ÒªÉ¾³ýÖ»ÄÜÍ£Ö¹SQL·þÎñÆ÷£¬ÄѵÀ¾ÍûÓбðµÃ°ì·¨ÁËÂð£¿
»Ø´ðÊǿ϶¨µÄ£ºÊ¹ÓÃÒÔÏ´洢¹ý³Ì£º ......
ÔÚsqlÓï¾äÖÐÉæ¼°µ½Ê±¼äÀàÐÍʱ ÈôÖ»ÏëÒªÈÕÆÚ to_date('2007-7-8','yyyy-mm-dd')
ÔÚC#ÖÐÓÐdatetimeÀàÐÍ£¬´úÂë˵Ã÷Ò»ÇÐ
DateTime dt = System.DateTime.Now;
string lsh;
lsh=string.Format("{0:yyyyMMddHHmmss}", dt);
DateTime dt = DateTime.Now;
Label1.Text = dt.To ......
Visual C#Öж¯Ì¬²Ù×÷SQL ServerÊý¾Ý¿â £¨1£©
·¢²¼Ê±¼ä£º2003.01.14 10:09 À´Ô´£ºÈüµÏÍø ×÷ÕߣºÍõ¿Ã÷
ÔÚ±àдÊý¾Ý¿âÓ¦ÓóÌÐòµÄʱºò£¬ÎÒÃÇ¿ÉÒÔͨ¹ýSQLÓï¾äÀ´¶¯Ì¬´´½¨¡¢ÐÞ¸ÄÊý¾Ý¿âÒÔ¼°ÆäÖеĶÔÏó¡£±¾ÎÄÎÒ¾ÍÏò´ó¼Ò½éÉÜÈçºÎÔËÓÃVisual C#À´¶¯Ì¬²Ù×÷SQL ServerÊý¾Ý¿ ......
1
<asp:UpdatePanelID="UpdatePanel1"
UpdateMode="Conditional"
runat="server">
<ContentTemplate>
<asp:Button ID="Button1"
......