Dim conn As New SqlConnection("Server=localhost;Database=pubs;uid=sa;pwd=pwd;")
conn.Open() Dim cmd As New SqlCommand("select au_lname from authors", conn)
Dim dr As SqlDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection) dlTest.DataSource = dr
dlTest.DataBind() dr.Close()
conn.Open() Dim cmd As New SqlCommand("select au_lname from authors", conn)
Dim dr As SqlDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection) dlTest.DataSource = dr
dlTest.DataBind() dr.Close()
<%-- Open the DataList control and set it for two columns, to be
filled in horizontal order. --%>
<ASP:DataList id="MyDataList" RepeatColumns="2"
RepeatDirection= "Horizontal" runat="server">
<%-- Create a DataList control template named "ItemTemplate". --%>
<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, "title")%>
</i></b>
</div>
<br>
<b>Title ID: </b>
<%# DataBinder.Eval(Container.DataItem, "title_id") %><br>
<b>Category: </b>
<%# DataBinder.Eval(Container.DataItem, "type")%><br>
<b>Publisher ID: </b>
<%# DataBinder.Eval(Container.DataItem, "pub_id") %><br>
<b>Price: </b>
<%# DataBinder.Eval(Container.DataItem,"price", "{0:c}") %>
<p>
</div>
</ItemTemplate>
</ASP:DataList>
</body>
</html>
就算我写给你,你有可能看不懂,MSDN有这上面这个例子,自己去看看
SqlConnection myConnection = new SqlConnection("server=localhost;" +
"database=pubs;Trusted_Connection=Yes");
SqlDataAdapter myCommand = new SqlDataAdapter("SELECT * " +
" from Titles", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds);
MyDataList.DataSource = ds;
MyDataList.DataBind();
但是DataList你需要去Aspx页面文件里面去写那些是要显示的字段,并绑定在页面上。
<asp:DataList>
<HeaderTemplate>页眉内容</HeaderTemplate>
<ItemTemplate>
<!-下面为字段绑定->
<%# DataBinder.Eval(Container.DataItem, "TitlePic")%>
<%#DataBinder.Eval(Container.DataItem, "Stats")%
<%# DataBinder.Eval(Container.DataItem, "StartTime")%>
</ItemTemplate>
</asp:DataList>
***********************************************
dim dr as new SQLDataReader
robjSqlcommand.execute(dr)DataList.datasource=dr;
DataList.DataBind()
***********************************************
dim dr as new SQLDataReader
robjSqlcommand.execute(dr)DataList.datasource=dr;<asp:DataList>
<HeaderTemplate>页眉内容</HeaderTemplate>
<ItemTemplate>
<!-下面为字段绑定->
<%# DataBinder.Eval(Container.DataItem, "TitlePic")%>
<%#DataBinder.Eval(Container.DataItem, "Stats")%
<%# DataBinder.Eval(Container.DataItem, "StartTime")%>
</ItemTemplate>
</asp:DataList>DataList.DataBind()