<%@import namespace="system.data"%>
<%@import namespace="system.data.ado"%>
<%
dim strConnstring as string
strconnstring="provider=sqloledb;data source=(local);"&"initial catalog=pubs;user id=sa"
dim objconn as adoconnection
objconn=new adoconnection
objconn.connectionstring=strconnstring
objconn.open()
dim strsql as string="select * from authors"
dim objdscommand as adodatasetcommand
dim objdataset as dataset=new dataset
objdscommand=new adodatasetcommand(strsql,objconn)
objdscommand.filldataset(objdataset,"Author Information")
objconn.close()
objconn.nothing
authors.datasource=objdataset.tables("Author Information").dafaultview
authors.databind()
</script>
%>
<html>
<body>
<asp:datagrid id="Authors" runat="server"/>
</body>
</html>
<%@import namespace="system.data.ado"%>
<%
dim strConnstring as string
strconnstring="provider=sqloledb;data source=(local);"&"initial catalog=pubs;user id=sa"
dim objconn as adoconnection
objconn=new adoconnection
objconn.connectionstring=strconnstring
objconn.open()
dim strsql as string="select * from authors"
dim objdscommand as adodatasetcommand
dim objdataset as dataset=new dataset
objdscommand=new adodatasetcommand(strsql,objconn)
objdscommand.filldataset(objdataset,"Author Information")
objconn.close()
objconn.nothing
authors.datasource=objdataset.tables("Author Information").dafaultview
authors.databind()
</script>
%>
<html>
<body>
<asp:datagrid id="Authors" runat="server"/>
</body>
</html>
如果是1.1的就不行!
我原先加在<%和%>中间
但还实际错啊
那到底要加在哪啊
这个东东是干嘛的
充分利用Aps.Net的代码分离技术,不会碰到你上面的问题.