我在access中家里了一个名为bank的数据库,数据表的名是tblusers,下面这断代码能显示数据库中的内容吗?
要怎样做呀???急救!!
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb" %><script language="VB" runat="server">
sub Page_Load(obj as Object,e as EventArgs)
dim objConn as new OleDbConnection _
("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\aspnet\data\bank.mdb")
dim objCmd as OleDbDataAdapter= new OleDbDataAdapter _
("select * from tblusers",objConn)
dim ds as DataSet=new DataSet()
objCmd.Fill(ds,"tblusers")
MyDataList.DataSource=ds.Tables("tblusers"). _
DefaultView
MyDataList.DataBind()
end sub
</script><html><body>
<ASP:DataList ID="MyDataList" RepeatColumns="2"
RepeatDirection="Vertical" runat="server"
<ItemTemplate>
<div style="padding :15,15,15,15;font-size:10pt;
font-family:Verdana">
<div style="font:12pt verdana;color:darkred">
<i><b><%# DataBinder.Eval(Container._
DataItem,"firstname")%>
<%# DataBinder.Eval(Container. _
DataItem,"lastname")%>
</i></b>
</div>
<br>
<b>address:</b><%# DataBinder.Eval(Container.DataItem,_
"address")%><br>
<b>city:</b><%# DataBinder.Eval(Container.DataItem, _
"city")%><br>
<b>state:</b><%# DataBinder.Eval_
(Container.DataItem,"state")%><br>
<b>zip:</b><%# DataBinder.Eval_
(Container.DataItem,"zip")%><br>
<b>phone:</b><%# DataBinder.Eval_
(Container.DataItem,"phone")%><br>
</div>
</ItemTemplate>
</ASP:DataList>
</body></html>
要怎样做呀???急救!!
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb" %><script language="VB" runat="server">
sub Page_Load(obj as Object,e as EventArgs)
dim objConn as new OleDbConnection _
("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\aspnet\data\bank.mdb")
dim objCmd as OleDbDataAdapter= new OleDbDataAdapter _
("select * from tblusers",objConn)
dim ds as DataSet=new DataSet()
objCmd.Fill(ds,"tblusers")
MyDataList.DataSource=ds.Tables("tblusers"). _
DefaultView
MyDataList.DataBind()
end sub
</script><html><body>
<ASP:DataList ID="MyDataList" RepeatColumns="2"
RepeatDirection="Vertical" runat="server"
<ItemTemplate>
<div style="padding :15,15,15,15;font-size:10pt;
font-family:Verdana">
<div style="font:12pt verdana;color:darkred">
<i><b><%# DataBinder.Eval(Container._
DataItem,"firstname")%>
<%# DataBinder.Eval(Container. _
DataItem,"lastname")%>
</i></b>
</div>
<br>
<b>address:</b><%# DataBinder.Eval(Container.DataItem,_
"address")%><br>
<b>city:</b><%# DataBinder.Eval(Container.DataItem, _
"city")%><br>
<b>state:</b><%# DataBinder.Eval_
(Container.DataItem,"state")%><br>
<b>zip:</b><%# DataBinder.Eval_
(Container.DataItem,"zip")%><br>
<b>phone:</b><%# DataBinder.Eval_
(Container.DataItem,"phone")%><br>
</div>
</ItemTemplate>
</ASP:DataList>
</body></html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货