aspÁ¬½ÓsqlserverÊý¾Ý¿âÎÊÌâ
¸÷λ´óÏÀ£º
ÏÖÔÚ´ÓÊý¾Ý¿âÖжÁÈ¡Êý¾ÝÓöµ½Õâ¸öÆæ¹ÖµÄÎÊÌ⣬ÈçºÎ½â¾öÄØ£¿
Ìáʾ´íÎóÈçÏÂ
´íÎóÀàÐÍ£º
ADODB.Connection (0x800A0E79)
¶ÔÏó´ò¿ªÊ±£¬²»ÔÊÐí²Ù×÷¡£
´úÂëÈçÏÂ
admin.aspÎļþ£º
<!--#include file="adminconn.inc" -->
....
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr align="center" bgcolor="#CCCCCC">
<td width="20%" height="24"> ID </td>
<td width="20%">ʹÓÃÈË </td>
<td width="20%">ʹÓò¿ÃÅ </td>
<td width="40%">·ÖÀà </td>
</tr>
<%
conn.open() '´ò¿ªÊý¾Ý¿â
Set rs=Server.CreateObject("ADODB.Recordset") '½¨Á¢Êý¾Ý¼¯
sql = "select * from t1" '²Ù×÷Êý¾Ý¿âÓï¾ä
rs.open sql,conn,1,3
while not rs.eof
%>
<tr align="center" bgcolor="#FFFFFF">
&nbs
Ïà¹ØÎÊ´ð£º
ǰ¶Îʱ¼äÅöµ½Ò»µÀÃæÊÔÌâÈçÏ£º
test.aspxÒ³ÃæÓÐÈçÏ´úÂ룺
Response.Write(Test.GetDate());
TestÀàÈçÏ£º
public class Test
{
static string dt="";
public static s ......
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
ASP.NETÈçºÎÓÃÒ»¸ö°´Å¥ÊµÏÖÑ¡ÔñÎļþ¼Ð·¾¶µ½Îı¾¿òÖУ¿£¨×¢ÒâÊÇÎļþ¼Ð·¾¶£¬²»ÊÇÎļþ·¾¶£©
http://blog.csdn.net/xianfajushi/archive/2008/10/18/3094474.aspx
Õâ²»ÊÇÎÒÒªµÄЧ¹û£¬ÎÒÒªÓõÄÊÇÀàËÆÓÚÎļþÉÏ´«¿ÉÒ ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......