title: ASP.net DAL DatasSet and Table Adapter not in namespace - Northwind Tutorial
body: <p>I've been attempting to walk through the "Creating a Data Access Layer" tutorial found <a href="http://www.asp.net/learn/data-access/tutorial-01-cs.aspx" rel="nofollow noreferrer">http://www.asp.net/learn/data-access/tutorial-01-cs.aspx</a></p>
  
  <p>I create the DB connection, create the typed dataset and table adapter, specify the sql, etc.</p>
  
  <p>When I add the code to the presentation layer (in this case a page called AllProducts.aspx) I am unable to find the NorthwindTableAdapters.ProductsTableAdapter class. I tried to import the NorthwindTableAdapters namespace, but it is not showing up. Looking in the solution explorer Class View confirms that there is a Northwind class, but not the namespace I'm looking for.</p>
  
  <p>I've tried several online tutorials that all have essentially the same steps, and I'm getting the same results.</p>
  
  <p>Can anyone give me a push in the right direction?</p>
  
  <p>I'm getting error: Namespace or type specified in the Imports 'NorthwindTableAdapters' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member.</p>
  
  <p>I think I might need to add a reference OR they may be creating a separate class and importing it into their main project. If that's the case, the tutorials do not mention this.</p>
  
  <p>SuppliersTest2.aspx.vb:</p>
  
  <pre><code>    Imports NorthwindTableAdapters 
  
     Partial Class SuppliersTest2
  
     Inherits System.Web.UI.Page
  
  
  
     Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
  
  
  
      Dim suppliersAdapter As New SuppliersTableAdapter
  
  
  
      GridView1.DataSource = suppliersAdapter.GetAllSuppliers()
  
      GridView1.DataBind()
  
  
  
  End Sub
  </code></pre>
  
  <p>End Class</p>