asp.net的数据库连接后没有数据显示

来源:百度知道 编辑:UC知道 时间:2024/06/26 01:12:06
<%@import namespace="system.data"%>
<%@import namespace="system.data.sqlclient"%>
<html>
<script language="vb" runat="server">
sub page_load(src as object,e as eventargs)
dim ds as dataset
dim mydatagrid as new datagrid
dim myconnection as sqlconnection
dim mycommand as sqldataadapter
'同数据库进行连接,采用sql server 数据库
myconnection=new sqlconnection("server='localhost';uid=sa;pwd=123;database=ifo")
'执行sql操作
mycommand = new sqldataadapter("select * from infor",myconnection)
ds=new dataset()
mycommand.fill(ds,"infor")
mydatagrid.datasource=ds.tables("infor").defaultview
mydatagrid.databind()
end sub
</script>
<center>
<body>
<h3><font face="verdana">page_load 事件演示</font></h3>
<asp:datagrid if="mydatagrid"

myconnection=new sqlconnection("server='localhost';uid=sa;pwd=123;database=ifo")
myconnection.Open()
'执行sql操作
mycommand = new sqldataadapter("select * from infor",myconnection)
ds=new dataset()
mycommand.fill(ds,"infor")
mydatagrid.datasource=ds.tables("infor").defaultview
mydatagrid.databind()