ÈçºÎÓÃasp²åÈëÊýÖµµ½ mssql Varbinary(16)×Ö¶Î
ÒѾ¼ÜÉèºÃÁËÓÎÏ·£¬ÄÜÔËÐÐÁË£¡¡¾ÓÎÏ·²»ÊÇÎÒ×öµÄËùÒÔÀïÃæµÄÔ´ÂëʲôµÄ¶¼²»´óÇå³þ¡¿ÓÎϷʹÓõÄÊý¾Ý¿âÊÇMSSQLµÄ¡£
ÏëÓÃÍøÕ¾ÊµÏÖÔÚÍøÒ³ÖÐ×¢²áÕ˺ÅÀ´²åÈëµ½Ö¸¶¨µÄMSsqlÓû§±íÖÐ! ÒÔ±ã´ïµ½ÔÚÍøÕ¾×¢²áÁËÕ˺źóÄÜÔÚÓÎÏ·ÀïÃæÊ¹ÓÃ.
µ«ÊÇÎÒÔÚÓû§±íÖеÄÄǸöÃÜÂë×ֶο´µ½µÄÊÇÕâÑùÒ»¸ö×´¿ö£ºÏÂͼ()
ÓÃASP ¶Á³öÓÎÏ·ÖÐÃÜÂëΪ£º123456 µÄ PWD×Ö¶Îʱ!
.....
response.Write(rs("pwd"))
Êä³öΪ: ?嶑?
²åÈëÓû§ID×Ö¶ÎʲôµÄ¶¼¿ÉÒÔ£¡¾ÍÊDz»ÖªµÀÔõô²åÈëpwd×ֶΣ¡ÎÒÖ±½ÓpwdÓÃ123456²åÈëʱÊÇ¿ÉÒÔµÄ,Âß¼Èç¹û²åÈëÕýÈ·µÄ»°Êä³öÊÇÓ¦¸ÃÊÇ¡°?嶑?¡±
µ«ÊÇÊä³öÀ´µÄʱºò²¢²»ÊÇ¡°?嶑?¡±
ÎÊÌ⣺ÇëÎÊÒ»ÏÂÎÒ¸ÃÔõôÓÃASPʵÏÖÔÚÏß×¢²áÓû§²åÈëPWD×Ö¶ÎÊýÖµ£¿Ð»Ð»£¡ºÜ¼±£¡
SQL code:
żȻÔÚsqlteam¿´µ½ÁË£¬ÕæÊǹ»¾ø£¬Õâ¶¼ÏëµÃ³öÀ´£¬ºÜ±ã½ÝµÄÒ»¸ö·½Ê½£¨Ö»ÊÊÓÃÓÚSQL SERVER 2005+£©£¬Ó¦¸Ã¸ú´ó¼Ò·ÖÏí¡£´úÂëÈçÏ£º
CREATE TABLE myTable(Document varbinary(max)) INSERT INTO myTable(Document) SELECT * from OPENROWSET(BULK N'C:\Image1.jpg', SINGLE_BLOB) µ±È»ÁË£¬Èç¹ûÐèÒªÌí¼ÓһЩ±äÁ¿Ö®ÀàµÄ£¬ÈÃSQLÓï¾ä¸üÁé»î£¬ÕâÄܺܺÃÔËÓÃÔÚ´æ´¢¹ý³ÌºÍ¶¯Ì¬SQLÖУ¬ÔÙÀ´Ò»¸ö²åÈëXMLÎı¾µÄ£¬Ò²ÊÇÏ൱µÄ¼ò½à£¬´úÂëÈçÏ£ºCREATE TABLE XmlImportTest
(
xmlFileName VARCHAR(300),
xml_data xml
)
GO
DECLARE @xmlFileName VARCHAR(300)
SELECT @xmlFileName = 'c:\TestXml.xml'
-- dynamic sql is just so we can use @xmlFileName variable in OPENROWSET
EXEC('
INSERT INTO
Ïà¹ØÎÊ´ð£º
http://www.zgjhjy.com/Test/PrimaryTest/Index.aspx
¾ÍÊÇÀàËÆÒÔÉϵÄÔÚÏß²âÊÔϵͳ£¬ÐèÒªÓÐÒ»¸öºǫ́µÄ£¬ÓïÑÔÊÇaspµÄ£¬Êý¾Ý¿âÊÇaccessµÄ£¬»¹ÐèÒªÄÜÔÚºǫ́¶ÔÐÅÏ¢½øÐÐÌíɾ¸Ä²éµÄ¡£Ð»Ð»¸÷λÁË¡£¡£¡£
³ÌÐòÕæµÄºÜ¶à£¬²»Öª ......
Imports System.ComponentModel
Imports System.Web.UI
Imports System.Web.UI.Design
Imports System.Web.UI.WebControls
Namespace CBDAspNet.WebControls.HTML
''' <summary>
'' ......
¸÷λ´óϺ£º
AspÈçºÎÄÜ×öµ½³¬´óÎļþµÄÉÏ´«¹ÜÀíÄØ£¿ÕâÀﳬ´óÎļþÖ¸µÄÊÇ£º100M ÖÁ 2G Ö®¼äµÄÒ»¸öÎļþ£¬Æ©È磺¼à¿ØÂ¼Ïñ Îļþ
ÎÒÏÖÔÚÓõÄÊÇFtpÉÏ´«£¬ÓÃÁË´ó°ëÄêÁË£¬ÏÖÔÚ·¢ÏÖFTPÀïÃæ·Ç³£»ìÂÒ£¬ºÜ¶àÓû§ÉÏ´«µÄ¶ ......
3¸öradioButton
Ò»¸öButton
Ò»¸ölabel
C# code:
protected void Button1_Click(object sender, EventArgs e)
{
string str = null;
RadioButton rdo=(RadioButton)sender;
......