aspÁ¬Êý¾Ý¿âµÄÎÊÌâ - Web ¿ª·¢ / ASP
aspÁ¬½Óoracleʱ±¨´í£º ADODB.Connection (0x800A0E7A) δÕÒµ½Ìṩ³ÌÐò¡£¸Ã³ÌÐò¿ÉÄÜδÕýÈ·°²×°¡£
aspÖеĴúÂëÈçÏ£º
VBScript code:
Dim MM_conora_STRING
MM_conora_STRING = "Provider=OraOLEDB.Oracle.1;User ID=lan;password=lan"
dim conn ,rs ,sql
set conn = server.CreateObject("adodb.connection")
conn.open MM_conora_STRING
set rs = server.CreateObject("adodb.recordset")
sql = "select * from users"
rs.open sql,conn,3
if rs.eof = false then
response.Write(rs("name") & "" & rs("pwd"))
end if
µ«ÈçÏ´úÂëÔÚVBÖÐÈ´ÄÜÕý³£ÔËÐУº
VB code:
Dim conn As Object
Dim rs As Object
Dim sql As String
sql = "select * from users"
Set conn = CreateObject("adodb.connection")
Set rs = CreateObject("adodb.recordset")
conn.Open "Provider=OraOLEDB.Oracle.1;User ID=lan;password=lan"
rs.Open sql, conn, 3
If rs.EOF = False Then
Debug.Print rs("name") & "" & rs("pwd")
End If
ÕâÊÇΪʲô£¿
MM_conora_STRING = "Provider=OraOLEDB.Oracle.1;User ID=lan;password=lan"
Ïà¹ØÎÊ´ð£º
ÍòÍøµÄ·þÎñÆ÷Ö§³Öα¾²Ì¬µÄ,Ö±½ÓÓÃrewriteÔÚweb.configÎļþд¹æÔò,Ò²²»Óð²×°×é¼þ¾Í¿ÉÒÔʵÏÖα¾²Ì¬,µ«ÊÇÔÚʱ´ú»¥Áª·þÎñÆ÷¾ÍÓò»ÁËÁË,×ÉѯËüµÄ¿Í·þ,Ëû˵ËûÃÇ·þÎñÆ÷(»ù±¾ÐÍC)²»Ö§³Öα¾²Ì¬µÄ.ÇëÎÊһϸ÷λÎÒ¸ÃÓÃʲô·½·¨ ......
1.asp.net×öµÄÒ»¸ö´ðÌâÒ³Ãæ£¬ÈçºÎʵʱÏÞʱºó×Ô¶¯Ìá½»£¬Çë´ó¼Ò¸øµã˼·
ÏÞʱµÄʱ¼äÐÅÏ¢´æ·ÅÔÚÊý¾Ý¿âÖÐ
2.Èç¹û´ðÌâʱ¼äÉèÖõĽϳ¤£¬ÈçºÎ·½Ê½session³¬Ê±ºóÒ³ÃæÎÞЧ
лл
ÓÃjs·½·¨À´¿ØÖÆ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË¡£¡£
js ......
ĿǰÊÇA.aspÃæÒ³ÓÐÒ»¸ö±äÁ¿aa,Ôõô²Å¿ÉÒÔ´«µ½B.aspÒ³Ãæ,²»ÊÇÓÃURL´«,ÏëÓÃ<inupt >¿Ø¼þÔõô´«°¡!Çë´ó¼ÒÖ¸µã!
ÓÃ±íµ¥´«Öµ
´«Öµ£¬GETºÍPOST£¬ÒªÃ´´ø²ÎÊý£¬ÒªÃ´ÓÃform
¶øÇÒ£¬Èç¹ûÄãÁ½¸öÒ³ÃæÃ»ÓÐÈκιØÁª£¬´«Ö ......
asp ·Ò³ÔõôʵÏÖ£¿
·ÖÒ³¿ÉʹÓ÷ÖÒ³¿Ø¼þÈçaspnetpager
ûÕÒµ½´Ë¿Ø¼þ£¡£¡£¡£¡£¡
µÚÈý·½×é¼þ ÐèÒªÔÚÍøÉÏÈ¥ÏÂÔØ http://www.webdiyer.com/Controls/AspNetPager/Downloads
²»Óÿؼþ Ôõô×ö°¡£¡
hehe
²» ......
sqlserverµÄÊý¾Ý¿â£¬×Ö¶ÎÊÇimageÀàÐ͵ġ£Ôõôд´úÂ룬ÔÚÒ³ÃæÖеã»÷¡°ÏÂÔØ¡±¾ÍÄÜ´ò¿ªÄǸöÏÂÔØ¶Ô»°¿ò£¿
PS£ºOracleLob ÔÚsqlserverÀïÊÇʲô£¿
Response.Redirect("test.jpg")
ÒýÓÃ
Response.Redirect( ......