如何使用 ACCESS DB 连接来填充 gridview

Question

如何使用 Access 数据库的连接来填充 GridView？

到目前为止我有以下代码：

OleDbConnection myConnection = default(OleDbConnection);
OleDbCommand myCommand = default(OleDbCommand);
string strSQL = null;
strSQL = "SELECT * FROM tblLoginInfo " + "WHERE username='" + CustID.Replace("'", "''") + "' " + "AND password='" + CustPass.Replace("'", "''") + "';";
myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source=" + Server.MapPath("login.mdb") + ";");

myCommand = new OleDbCommand(strSQL, myConnection);
myConnection.Open();

但现在怎么办？

Answer 1

 OleDbConnection myConnection = default(OleDbConnection);
         OleDbCommand myCommand = default(OleDbCommand);
         string strSQL = null;
         strSQL = "SELECT * FROM tblLoginInfo " + "WHERE username='" + CustID.Replace("'", "''") + "' " + "AND password='" +
 CustPass.Replace("'", "''") + "';";
         myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source="
 + Server.MapPath("login.mdb") + ";");
        myConnection.Open();
         myCommand = new OleDbCommand(strSQL, myConnection);

         OleDbDataAdapter adp=new OledbDataAdapter(myCommand);
         dataset ds=new dataset();
         adp.fill(ds);
        gridview.datasource=ds;
        gridview.databind();

Answer 2

类似方法

        <asp:AccessDataSource ID="AccessDataSource1" runat="server" 
            DataFile="~/App_Data/AccesFile.mdb" SelectCommand="SELECT * FROM [TableName]">
        </asp:AccessDataSource>
        <asp:GridView ID="GridView1" runat="server" DataSourceID="AccessDataSource1">
        </asp:GridView>

尝试AccessDataSource、SqlDataSource 以及在 ASP.NET 中连接到 Access 数据库

我还发现了这篇关于 在 Asp.net 中将 GridView 与 MS Access 数据库表绑定

希望这有帮助