ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë
Ôõô»ØÊ¡£
´úÂëÒѾдÁ˹ýÂË×Ö·û´®
Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË
Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË
»¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½
ÔõôûÈËÖªµÀ
......
¸÷λ´óÏÀ£º
ÏÖÔÚ´ÓÊý¾Ý¿âÖжÁÈ¡Êý¾ÝÓöµ½Õâ¸öÆæ¹ÖµÄÎÊÌ⣬ÈçºÎ½â¾öÄØ£¿
Ìáʾ´íÎóÈçÏÂ
´íÎóÀàÐÍ£º
ADODB.Connection (0x800A0E79)
¶ÔÏó´ò¿ªÊ±£¬²»ÔÊÐí²Ù×÷¡£
´úÂëÈçÏÂ
admin.aspÎļþ£º
<!--#include file="adminconn.inc" -->
....
<table widt ......
ÇósqlserverѲ¼ìÎĵµ...
...
»¹ÇëÎÊÏÖÔÚÆóÒµÖ÷Á÷sqlserverÊÇÓÃÄĸö°æ±¾£¿ÊÇ2005Âð£¿
Çë¸÷ÎÊ°ïæÌṩһЩÖÐÎĵÄsqlserver¹ÜÀíά»¤Îĵµ£¡
ûÌý˵¹ý,°ï¶¥.
......
ÎÒÁÐÁËÒÔÏÂѲ¼ìÄÚÈÝ£º
Êý¾Ý¿âÃû
°æ±¾ÐÅÏ¢
Êý¾Ý¿âµÄλÊý
Êý¾Ý¿â¿ÉÓÃÐÔ
·¢ÉúËÀËøµÄ´ÎÊý
Á¬½Óµ½Êý¾Ý¿âµÄ»á»°ÊýÁ¿
Êý¾Ý¿âÁ¬½ÓÊ ......
´ó¼ÒºÃ,СµÜÓÖÓöÒ»ÐÂÎÊÌâ:
VB+SQL
ÓÐN¸ö×Ö¶Î,´°ÌåÉÏÓÐN¸ötext.±£´æÊäÈë½á¹ûºó,ÓÐN¸ö¶ÔӦΪ»õ±Ò×ԶεÄtextÔÚûÓÐÊäÈëÈκÎÖµ(¼´Îª¿Õ)µÄÇé¿öÏÂ,´ÓSQL²éѯ·ÖÎöÆ÷Àï²éµ½,Æä¾ÓÈ»ÊÇ"0.00".
¶øÇÒ½«Æä¶Á³öµ½TEXT¿òÄÚÒ²ÏÔʾΪ 0,ÏÖÎÒÏëÔÚ¶Á³öÊý¾ÝµÄʱºò,ÓÐÊý¾ÝµÄÏÔʾÊý¾Ý,¶øΪ 0 µÄÊýÖµ²»ÏÔʾÓÚÎı¾¿ò ......
°²×°ÁËsql server 2008ÆóÒµ°æ£¬²Ù×÷ϵͳΪwindows server 2008 X64£¬°²×°Íê³Ésql server 2008ºó£¬»¹×°ÁËvs2008£¬È»ºó´òÁËvs2008ºÍsql server 2008µÄSP1¡£
°²×°ºó£¬Á¬½ÓÊý¾Ý¿âʱ£¬Èç¹ûÖ¸¶¨·þÎñÆ÷Ãû³ÆΪ¡°.\MSSQLSERVER2008¡±£¬ÄÇôÓÃsaµÇ¼³É¹¦£¬µ«Ö¸¶¨·þÎñÆ÷Ãû³ÆΪ¡°IP\MSSQLSERVER2008¡±£¬ÔòµÇ¼ʧ°Ü£¬ÆäÖÐMSSQLSERVER2 ......
°ïæдÌõÓï¾ä£¬Ð»Ð»ÁË¡£
col1 col2
1 a
2 b
3 ......