ASP Net Controls ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. ASP Net Controls
  4. Bind data from Access database to an ASP
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

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


  
     
        
           Name
           ID
        
     
     
        
            <%# Container.DataItem("FirstName") %> 
                <%# Container.DataItem("LastName") %>
           
            <%# Container.DataItem("ID") %> 
        
     
     
        
            
              <%# Container.DataItem("FirstName") %> 
              <%# Container.DataItem("LastName") %>
           
            
              <%# Container.DataItem("ID") %> 
           
        
     
     
        
           
              - - -