ASP Net Controls ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. ASP Net Controls
  4. Bind Data in Access to ASP
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

   sub Page_Load(Sender as Object, e as EventArgs) 
      dim objConn as new OleDbConnection( _
            "PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
            & "DATA SOURCE=" _
            & Server.MapPath("EmployeeDatabase.mdb;"))
      dim objCmd as OleDbDataAdapter = new OleDbDataAdapter("select * from employee", objConn)
      dim ds as DataSet = new DataSet()
      objCmd.Fill(ds, "employee")
      MyDataList.DataSource = ds.Tables("employee").DefaultView
      MyDataList.DataBind()
    end sub


       RepeatDirection="Vertical" runat="server">
     
                   font-family:Verdana">
        
           <%# DataBinder.Eval(Container.DataItem, "FirstName")%>  
           <%# DataBinder.Eval(Container.DataItem, "LastName")%>
           
        

        

        ID: <%# DataBinder.Eval(Container.DataItem, _
           "ID") %>