IDC资讯中心
<!– <%@ page trace="true" %> –>
<%@ import namespace="system.data" %>
<%@ import namespace="system.data.sqlclient" %>
<html>
<body bgcolor="white">
<h3>使用 ado+, 结合 datagrid — ado+.aspx <hr></h3>
<asp:datagrid headerstyle-backcolor="cyan" id="grid1" runat="server"/>
</body>
</html>
<script language="vb" runat="server">
sub page_load(src as object, e as eventargs)
grid1.datasource = createdataview( "pubs", "authors" )
grid1.databind()
end sub
function createdataview( db as string, table as string ) as dataview
dim connstr, sql as string
connstr = "server=hnby-dom;uid=sa;pwd=;database="&db
dim conn as sqlconnection
dim cmd as sqldataadapter
conn = new sqlconnection(connstr)
cmd = new sqldataadapter( "select * from " & table, connstr )
dim ds as dataset = new dataset()
cmd.fill(ds, table)
createdataview = new dataview(ds.tables(table))
end function
</script>
和使用ado+（一）不同，这里用到一个函数createdataview，你可以单独吧这个函数做到一个包含页面里。
————————————————
以上在win2000server,win2000professional,sql6.0，microsoft .net framework sdk beta2测试通过。
实例：http://202.102.247.235/aspx/ado2.aspx
