VB.NET的DataGrid控件中显示数据记录编号

最新推荐文章于 2018-04-18 09:16:32 发布

原创最新推荐文章于 2018-04-18 09:16:32 发布 · 931 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#datagrid #vb.net #express #access #object #string

VB 专栏收录该内容

5 篇文章

订阅专栏

本文介绍了一个使用ASP.NET和Access 2007进行数据交互的简单示例。示例中展示了如何通过Visual Web Developer 2008 Express Edition创建一个网页应用程序，并实现按钮点击后从Access数据库中获取数据并显示在一个DataGrid控件上。

IDE:Visual Web Developer 2008 Express Edition

DB:Access 2007

aaa.aspx.vb

Protected Sub btnSearch_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnSearch.Click Dim myConnection As OleDbConnection Dim myCommand As OleDbCommand Dim dbname As String dbname = Server.MapPath("location.accdb") myConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;DATA Source=" & dbname) myConnection.Open() myCommand = New OleDbCommand("SELECT * FROM tableName", myConnection) MyDataGrid.DataSource = myCommand.ExecuteReader() MyDataGrid.DataBind() End Sub

aaa.aspx

<asp:DataGrid id="MyDataGrid" runat="server" Font-Name="Verdana" Font-Size="10pt" HeaderStyle-BackColor="#aaaadd" AlternatingItemStyle-BackColor="#eeeeee" Font-Names="Verdana" PageSize="50" AllowPaging="True" CellPadding="4" ForeColor="#333333" GridLines="None" AllowCustomPaging="True" Width="100%"> <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <EditItemStyle BackColor="#2461BF" /> <SelectedItemStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" /> <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" /> <AlternatingItemStyle BackColor="White"></AlternatingItemStyle> <ItemStyle BackColor="#EFF3FB" /> <Columns> <asp:TemplateColumn HeaderText="No"> <ItemTemplate> <%#Container.DataSetIndex + 1%> </ItemTemplate> </asp:TemplateColumn> </Columns> <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White"></HeaderStyle> </asp:DataGrid>