ASP¶à±í²éѯ£¬Ò»¶Ô¶à
ÎÒÒª²éѯÁ½ÕűíµÄÊý¾Ý£¬Ò»ÕűíÒ»ÌõÊý¾Ý¶ÔÓ¦ÁíÒ»ÕűíµÄ¶àÌõÊý¾Ý£¬SQLÊý¾Ý¿â
±í1£º ±í2£º
id name ... ctrId content ...
5 ¼× ... 5 A ...
6 ÒÒ ... 5 B ...
7 ±û ... 6 C ...
8 ¶¡ ... 6 D ...
²éѯºó
id name content ...
5 ¼× A,B ...
6 ÒÒ C,D ...
ÇëÎÊÔõôʵÏÖ£¿
ÓÃÀàËÆsql="select a.id,name,content from a,b where a.id=b.ctrid" µÄÓï¾äÖ»»áÉú³É¶àÌõÊý¾Ý£¬ÒòÎÒÒª½«±í¸ñµ¼³öµ½EXCELÖз½±ãɸѡ
ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!
Ïà¹ØÎÊ´ð£º
<form id="form1" runat="server">
<div>
<script type="text/javascript">
function oo(a){
document.getEleme ......
ÎÒÃÇÓÐÒ»¸öÍøÕ¾Ä£°å£¬www.c111.com.cn,Ï£ÍûÐÞ¸ÄһЩµØ·½£º
1£©µã»÷×ó²à¡°·þÎñÆ·ÅÆ¡±µÄÆäÖÐÒ»¸öС·ÖÀ࣬Èç¡°×ãÇò¡±£¬½çÃæµÄÓÒ²à¾Í³öÏÖÈçwww.c111.com.cn/1.jpg£¬µã»÷1.jpgÉÏ·½µÄÆäÖÐÒ»¸öÆ·ÅÆlogo£¬ÏÂÃæ¾Í³öÏÖÏà¹ØµÄÍ ......
×î½üÎÒͨ¹ýѧϰ£¬¸Ð¾õ×Ô¼ºÑ§µÄ»¹¿ÉÒÔÁË£¬Ïë×öÒ»ÍøÕ¾£¬µ«ÊÇÒ»Ö±¶¼ÕÒ²»µ½Ìâ²Ä£¬²»ÖªµÀ×öʲô£¬Ï£Íû¸÷λ¸øÎÒµãÒâ¼û£¬Èç¹ûÓÐÐèÇóÎĵµ¾Í¸üºÃÁË£¡Ï£Íû´ó¼Ò¸øÎÒµãÒâ¼û£¬Ð»Ð»£¡
ÏÈ×ö¸öÆóÒµÍøÕ¾°É£¬ÎҸоõÒ»¸öÈË×öÍøÕ¾²»ÊÊÒË ......
ƽʱ¶¼³öÏÖÔÚIEÀï±ßµÄ£¬µ«ÏÖÔÚä¯ÀÀ·¢ÏÖ²»³öÏÖÔÚä¯ÀÀÆ÷Àï±ß¡£¸ß¼¶Àï±ßÑ¡ÖÐÁË¡°ÏÔʾ½Å±¾´íÎó...¡±µ«Ã»ÓÐÏÔʾ¡£
ÓÐûÓе÷ÊÔÆ÷£¬Ò»²½Ò»²½¸ú×ÙÖ´ÐÐÇé¿ö£¿
on error resume nextÕâÑùµÄ¶«Î÷È¥µô
»¹ÓÐÔÚIISÀï ......
ÎÒ×°µÄÊÇwindows7 £¬Êý¾Ý¿âÏëÓÃsql server 2008Á¬asp£¬²»¹ýÎÒ²»ÖªµÀsql server 2008µÄÓû§ÃûºÍÃÜÂëÁË£¬ÏëÓÃwinÑéÖ¤£¬ÊÔÁ˼¸±éû³É¹¦£¬Çë´ó¼Ò°ïæ¡£
˳±ãÎÊһϣ¬ÎÒÔõôÄܲé³öÀ´×Ô¼ºsql 2008µÄÓû§Ã ......