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" />
Ïà¹ØÎĵµ£º
sqlite¹Ù·½Õ¾
http://www.sqlite.org/
SQL Syntax
http://www.sqlite.org/lang.html
sqliteÖÐÎÄÕ¾
http://www.sqlite.com.cn/
http://www.sqlitechina.org/
½¨Á¢Êý¾Ý¿âµµ°¸
ÓÃsqlite3½¨Á¢Êý¾Ý¿âµÄ·½·¨ºÜ¼òµ¥£¬Ö»ÒªÔÚshellϼüÈ루ÒÔÏÂ$·ûºÅΪshellÌáʾºÅ£¬ÇëÎð¼üÈ룩£º
$ sqlite3 foo.db
Èç¹ûĿ¼ÏÂûÓÐfo ......
ÔÚ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 ......
¡¡SQLÖÐÓÐËÄÖÖ»ù±¾µÄDML²Ù×÷£ºINSERT£¬SELECT£¬UPDATEºÍDELETE¡£
INSERTÓï¾ä
¡¡¡¡Óû§¿ÉÒÔÓÃINSERTÓï¾ä½«Ò»ÐмǼ²åÈëµ½Ö¸¶¨µÄÒ»¸ö±íÖС£ÀýÈ磬Ҫ½«¹ÍÔ±John SmithµÄ¼Ç¼²åÈëµ½±¾ÀýµÄ±íÖУ¬¿ÉÒÔʹÓÃÈçÏÂÓï¾ä£º
¡¡¡¡INSERT INTO EMPLOYEES VALUES
¡¡¡¡ ('Smith','John','1980-06-10',
¡¡¡¡ 'Los Angles',16,45000);
¡¡ ......
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"
......