asp.net中gridview和BulletedList连接数据库实例(前端)

web配置：

注意当前文件夹下app_data：Source=|DataDirectory|\测试.mdb

  <connectionStrings>
    <add name="测试ConnectionString" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\测试.accdb" providerName="System.Data.OleDb"/>
  </connectionStrings>

一定一定：否则报错

Provider=Microsoft.ACE.OLEDB.12.0;

前端引用

        <asp:BulletedList ID="BulletedList1" runat="server" cssclass="style" DataSourceID="SqlDataSource1" DataTextField="ID" DataValueField="ID" >
        </asp:BulletedList>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:测试ConnectionString %>" ProviderName="<%$ ConnectionStrings:测试ConnectionString.ProviderName %>" SelectCommand="SELECT * FROM [表1]"></asp:SqlDataSource>

gridview前端调用：

        <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="SELECT * FROM [表1]"></asp:SqlDataSource>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="SqlDataSource3">
            <Columns>
                <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID" />
                <asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
                <asp:BoundField DataField="age" HeaderText="age" SortExpression="age" />
            </Columns>
        </asp:GridView>

后端配置数据源：

  <connectionStrings>
    <add name="ConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\测试.mdb"
      providerName="System.Data.OleDb" />
  </connectionStrings>