ÏÖÔÚÎÒÓÐÒ»¸öList <student>ÀïÃæ°üº¬ID Name Sex Age ×Ö¶Î,»¹ÓÐÒ»¸öList <class>ÀïÃæÓÐClassID ID stuNum×Ö¶Î.
ÆäÖÐstudentÖеÄID¶ÔÓ¦classÖеÄID,stuNumΪ°à¼¶ÈËÊý
ÎÒÓÃGridView×°ÔØList <class>
<asp:GridView ID="GridView1" runat="server">
& ......
ÎÒ°ÑÒ»¸öAccessÊý¾Ý¿âתΪÁËSQLÊý¾Ý¿â£¬°ÑÔÀ´Á¬½ÓACCESSÊý¾Ý¿âµÄ´úÂë¸ø¸Ä³ÉÁËSQLµÄ£¬µ«Í¨¹ýASP²éѯ²»µ½SQLÊý¾Ý¿âÀïµÄ¶«Î÷£¬Çë¸÷λ¸ßÊÖ°ï°ï棡 ллÁË£¡
²»Ì«Çå³þ ²»¹ý accessÖÐ×Ö·ûÊÇ stringÐÍµÄ ×ª³Ésqlserver¾Í³ÉÁË nvarhcarÁË access boolean ÊÇfalse true
sqlserverÖÐûÓеÄ
»¹Ó ......
ASP.NETÈçºÎÖ´ÐÐSQLÃüÁÈ磺´´½¨Ð±íCREATE TABLEµÄÃüÁÈçºÎ±àдִÐдúÂë¡£ÓÃVBÓïÑÔ£¬ÍêÕûµÄ´úÂ롣ллÁË¡£
ɳ·¢¡£¡£¡£¡£¡£¡£¡£¡£
°ï¶¥
C# code:
StringBuilder strSql=new StringBuilder();
strSql.Append(@"CREATE TABLE [tb2] (
[id ......
ÎÒÏÖÔÚÐèÒªÒ»¸öasp.net¹ýÂ˳ÌÐò£¬·ÀÖ¹sql×¢ÈëµÄ¡£»¹ÓÐÒ»¸öÎÊÌ⣬±ÈÈç¹ýÂË%¡¢-¡¢<>¡¢'¡¢µÈ×Ö·û¡£µ«ÊÇÎÒÕýʽÐèҪд×Ö·ûÏÔʾÔõô°ì¡£±ÈÈçÒªÈÃǰ̨ÏÔʾ < »òÕß >¡¢¡¯Ö®ÀàµÄ¡£²»ÄÜÌæ»»Îª¿ÕµÄ¡£
Ï£ÍûÄãÃǵijÌÐòÄܽâ¾öÕâÑùÎÊÌâ¡£
Êý¾Ý¿â²ÎÊý»¯
http://topic.csdn.net/u/20090708/09/b78444ee-9081-4ff7-8a ......
ÎÒÓÃfsoÉú³ÉÁËword£¬µ«ÊÇÓÐÒ»¸öÎÊÌ⣬¾ÍÊÇÕâ¸öÒ³ÃæÖÐÓÐͼƬµÄ²¿·Ö£¬ËƺõÊDz»ÄÜÉú³Éµ½word¸ñʽµÄ
ËùÒÔÎÒ°ÑͼƬȫ²¿ÐÞ¸ÄÕý¾ø¶Ô·¾¶ÁË£¬Èç <a href="http://www.xxxxxx.com/ssssss.gif">XXXXX </a>ÕâÑù
´ó²¿·Ö»úÆ÷ÔÚÏÂÔØÉú³ÉµÄword£¨Êµ¼ÊÉÏÊÇhtm£¬À©Õ¹ÃûΪdoc£©£¬¶¼ÄÜÕý³£ÏÔʾ£¬µ«ÊÇij²¿·ÖµçÄ ......
Application("Web_Const")=arrRow(1,0) & "||" & arrRow(2,0) & "||" & arrRow(3,0) & "||" & arrRow(4,0) & "||" & arrRow(5,0) & "||" & arrRow(6,0) & "||" & arrRow(7,0) & "||" ......