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
Ïà¹ØÎÊ´ð£º
ÓÐËÄܸø½²½²£¬Ôõô×öÂð£¿
ллÀ²£¡
¸ÊÌØÍ¼ ÊÇɶ£¿
½âÌâ˼·.¿´Ò»Ï½ø¶ÈÌõµÄÏÔʾ..
ÆäʵÄã¾ÍŪһ¶Ñtable ÿ¸ötableµÄ¿í¶È²»Í¬.µ×É«²»Í¬¼´¿É
µ±È»ÓÃdiv¿ØÖÆÎ»ÖøüºÃ
ÄãŪ100¸ötable¸ù¾Ý½ø¶ÈÆäÖÐǰ20¸ö·Ö¸øµ ......
ǰ¶Îʱ¼äÅöµ½Ò»µÀÃæÊÔÌâÈçÏ£º
test.aspxÒ³ÃæÓÐÈçÏ´úÂ룺
Response.Write(Test.GetDate());
TestÀàÈçÏ£º
public class Test
{
static string dt="";
public static s ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
asp ÎÒ²»Õ¦¸ö¶«£¬ÎÒÊÇ×öasp.netµÄµ«ÊÇǰÕß¿´¶®Ó¦¸ÃûÓÐÎÊÌ⣬ÎÒÔÙά»¤Ç°ÃæµÄÒ»¸öÍøÕ¾£¬µ«ÊÇ£¬½ñÌìÎÒÒ²²»ÖªµÀÊÇÔõô¶¯ÁË·þÎñÆ÷ºÍÊý¾Ý¿â£¬µ¼ÖÂÎÒaspÒ³ÃæÃ»ÓÐʹÓÃÊÓͼֱ½Ó´Ó±íÖлñµÃµÄÊý¾ÝÕý³£ÏÔʾ£¬¶øÄÇЩʹÓÃÁËÊÓͼÀ´ ......