连接

谁能给我一段连接ACCESS的源码啊

解决方案 »

  1.   

    <add name="OleDbConnectionString" connectionString="provider=Microsoft.Jet.OLEDB.4.0;data source=D:\MyInfo.mdb" providerName="System.Data.OleDb"/>
      

  2.   

    <%@ Import Namespace="System.Data" %>
    <%@ Import Namespace="System.Data.OleDb" %>
    <script Language="c#" runat="server">
      void Page_Load()
      {
        string strConnection; 
        strConnection ="Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("northwind.mdb");
        data_src.Text = strConnection;
        OleDbConnection objConnection = new OleDbConnection(strConnection);
        try
        {
          objConnection.Open();
          con_open.Text="Connection opened successfully.<br/>";
          objConnection.Close();
          con_close.Text="Connection closed.<br/>";
        }
        catch (Exception e)
        {
          con_open.Text="Connection failed to open.<br/>";
          con_close.Text=e.ToString();
        }
      }
    </script>
    <html>
      <body onunload="return window_onunload()" onload="return window_onload()">
      <h4>Testing the data connection
      <asp:label id="data_src" runat="server"/></h4>
      <asp:label id="con_open" runat="server"/><br />
      <asp:label id="con_close" runat="server"/><br />
      </body>
    </html>
      

  3.   

    ole--access-DataReader<%@ Import Namespace="System.Data" %>
    <%@ Import Namespace="System.Data.OleDb" %>
    <script Language="c#" runat="server">
    void Page_Load()
    {
      string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("northwind.mdb");
      
      data_src.Text = strConnection;
      string strSQL = "SELECT FirstName,LastName FROM Employees";
      string strResultsHolder = "";
      OleDbConnection objConnection = new OleDbConnection(strConnection);
      OleDbCommand objCommand = new OleDbCommand(strSQL, objConnection);
      OleDbDataReader objDataReader = null;
      try
      {
        objConnection.Open();
        con_open.Text="Connection opened successfully.<br>";
        objDataReader = objCommand.ExecuteReader();
        while (objDataReader.Read() == true)
        {
           strResultsHolder += objDataReader["FirstName"];
           strResultsHolder += "|&nbsp;";
           strResultsHolder += objDataReader["LastName"];
           strResultsHolder += "<br/>";
        }
        objDataReader.Close();
        objConnection.Close();
        con_close.Text = "<br/>Connection closed.<br/>";
        divListEmployees.InnerHtml = strResultsHolder;
      }
      catch (Exception e)
      {
        con_open.Text = "Connection failed to open successfully.<br/>";
        con_close.Text = e.ToString();
      }
    }
    </script>
    <html>
      <body>
      <h4>Reading data from the connection
      <asp:label id=data_src runat=server/> with the DataReader object.</h4>
      <asp:label id=con_open runat=server/><br>
      <div id="divListEmployees" runat="server">list will go here</div>
      <asp:label id=con_close runat=server/><br>
      </body>
    </html>
      

  4.   

    ole--access-DataSet--datagrid<%@ Page %>
    <%@ Import Namespace="System.Data" %>
    <%@ Import Namespace="System.Data.OleDb" %>
    <script Language="c#" runat="server">
      void Page_Load()
      {
        string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("northwind.mdb");
      
        data_src.Text = strConnection;
        string strSQL = "SELECT FirstName, LastName FROM Employees";
        DataSet objDataSet = new DataSet();
        OleDbConnection objConnection = new OleDbConnection(strConnection);
        OleDbDataAdapter objAdapter = new OleDbDataAdapter(strSQL, objConnection);
        objAdapter.Fill(objDataSet, "Employees");
        
        //DataView objDataView = new DataView(objDataSet.Tables["Employees"]);
        //dgNameList.DataSource=objDataView;
        //dgNameList.DataBind();
        
        dgNameList.DataSource=objDataSet.Tables["Employees"].DefaultView;
        dgNameList.DataBind();
      }
    </script>
    <html>
      <body>
      <h4>Reading data from the connection 
      <asp:label id="data_src" runat="server"/> to the DataGrid control.</h4>
      <asp:datagrid id="dgNameList" runat="server" runat="server" BorderWidth="1px" BorderStyle="Groove" BorderColor="Teal"
    Width="200px" Font-Size="12px">
    <HeaderStyle Font-Bold="True" HorizontalAlign="Center" BackColor="#CCFFCC"></HeaderStyle>
    <AlternatingItemStyle ForeColor="Red" BackColor="#FFFF80"></AlternatingItemStyle>
    </asp:datagrid><br />
      </body>
    </html>