ÎÒÒѾ°Ñselect * from user дµ½ÁËSql.xmlÖÐ
ÔÚReadXML.csÀï¶ÁÈ¡ÆäÓï¾äµÄ´úÂëÈçÏÂ:
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load("E:\\program1\\ConsoleApplication1\\ConsoleApplication1\\Sql.xml") ......
C/SÓëB/SÊÇÖеÄÈý²ãÊÇÖ¸ÎïÀí²¼¾ÖÂð?
ÄÇô±íʾ²ã--ÒµÎñÂß¼²ã--Êý¾Ý´æ´¢²ãÓÖÊÇÊ²Ã´ÄØ?ÊÇÉè¼ÆÄ£Ê½?
ÄÇôËùνµÄÈý²ã½á¹¹ : ¿Í»§²ã--Öмä²ã--·þÎñÆ÷²ãÓÖÊÇÐÎÈÝʲôµÄ°¡?
ggÖ®
C/S ¿Í戶¶Ë/·þ務Æ÷ ģʽ
B/S 瀏覽Æ÷/·þ務Æ÷ ģʽ
client/server
brower/server
ÒýÓÃ
C/SÓëB/SÊÇÖеÄÈ ......
Çë¿´Ò»ÏÂÎÒҪʵÏÖÕâ¸öЧ¹û£¬Ó¦¸ÃÈçºÎ´¦ÀíÄØ£¿
conn.execute("update table set ziduan="&chengxu(ziduan,bianliang)&" where id=1")
¾ÍÊÇ˵£¬ÎÒÒª¸üеÄÊÇ¡°ziduan¡±Õâ¸ö×ֶΣ¬¶ø¡°chengxu(²ÎÊý1,²ÎÊý2)¡±ÓÖÊÇÒ»¸öasp¹ý³Ì(Óõ±Ç°µÄÄÚÈݼÓÉÏеÄÄÚÈÝ)£¬¶¼ÊÇ×Ö·ûÐÍÊý¾Ý£¬ÓÐûÓа취ʵÏÖÄØ£¿
F ......
ÎÒ°ÑÒ»¸ö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 ......
cmD.CommandText = "SELECT * from hetong where type=" & TextType & " And htbhao=" & TextHTBhao
adOpenStatic = 3
adLockBatchOptimistic = 4
Rst1.CursorLocation = ADODB.Cursor ......