Question

我如何使用访问数据库链接,填满<>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>

http://www.mikesdotnetting.com/Article/78/AccessDataSource-SqlDataSource-and-linking-to-Access-databases-in-ASP.NET“rel=” AccessDataSource, SqlDataSource andlinking to Access database in ASP. NET

我还认为,该条涉及

希望这一帮助

友情链接