ÈçºÎÓÃ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
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
¸÷λ´óϺ£º
AspÈçºÎÄÜ×öµ½³¬´óÎļþµÄÉÏ´«¹ÜÀíÄØ£¿ÕâÀﳬ´óÎļþÖ¸µÄÊÇ£º100M ÖÁ 2G Ö®¼äµÄÒ»¸öÎļþ£¬Æ©È磺¼à¿ØÂ¼Ïñ Îļþ
ÎÒÏÖÔÚÓõÄÊÇFtpÉÏ´«£¬ÓÃÁË´ó°ëÄêÁË£¬ÏÖÔÚ·¢ÏÖFTPÀïÃæ·Ç³£»ìÂÒ£¬ºÜ¶àÓû§ÉÏ´«µÄ¶ ......
ÔÚaspÀïÔõôµ÷ÓÃjavaдµÄwebservice·½·¨£¬Óкܶ෽·¨
- <message name="RtPnrIn">
<part name="bstrPnrNO" type="s:string" />
<part name ......
¸÷λ´óϺ£¬ÎÒ×öÁËÒ»¸öASPµÃͨѶ¼£¬µ«ÊdzýÁ˲éѯ¹¦ÄܺÃÏñÆäËû¶¼ÓÐÎÊÌ⣬ÆäÖÐÌí¼Ó¹¦ÄÜÈçÏ£¬ÄÜÖ¸µ¼Ò»ÏÂÎÒÄÄÀï³ö´íÁËÂð£¿
<html>
<head>
<title>ÎÞ±êÌâÎĵµ</title>
</head>
<b ......
3¸öradioButton
Ò»¸öButton
Ò»¸ölabel
C# code:
protected void Button1_Click(object sender, EventArgs e)
{
string str = null;
RadioButton rdo=(RadioButton)sender;
......