dim objconn as new adodb.connection dim objrs as new adodb.recordsetprivate function initconn() as integer dim strconn as string on error goto errhandle strconn="provider=sqloledb.1;password=password;persist security info=true;user id=sa;initial catalog=db;data source=jjt" objconn.connectionnstring=strconn objconn.cursorlocation=aduseclient objconn.mode=admodereadwrite objconn.open initconn=0 exit function errhandle: initconn=-1 public function searchs(byval st_id1) as variant dim strsql as string dim s as string strsql="select sname form student where st_id="+"'"+st_id1+"'" objrs.open strsql,objconn,adopenbynamic,adlockoptimistic,adcmdtext s=objrs("sname").value set searchs=objrs end function
你可以用组件返回一个含有html代码的字符串。输出这个字符串不久可以了。
dim objrs as new adodb.recordsetprivate function initconn() as integer
dim strconn as string
on error goto errhandle
strconn="provider=sqloledb.1;password=password;persist security info=true;user id=sa;initial catalog=db;data source=jjt"
objconn.connectionnstring=strconn
objconn.cursorlocation=aduseclient
objconn.mode=admodereadwrite
objconn.open
initconn=0
exit function
errhandle:
initconn=-1
public function searchs(byval st_id1) as variant
dim strsql as string
dim s as string
strsql="select sname form student where st_id="+"'"+st_id1+"'"
objrs.open strsql,objconn,adopenbynamic,adlockoptimistic,adcmdtext
s=objrs("sname").value
set searchs=objrs
end function