ASP.net DAL DatasSet and Table Adapter not in namespace - Northwind Tutorial

Posted by Alan on Stack Overflow See other posts from Stack Overflow or by Alan
Published on 2010-03-31T17:44:46Z Indexed on 2010/04/01 2:53 UTC
Read the original article Hit count: 811

I've been attempting to walk through the "Creating a Data Access Layer" tutorial found http://www.asp.net/learn/data-access/tutorial-01-cs.aspx

I create the DB connection, create the typed dataset and table adapter, specify the sql, etc.

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.

I've tried several online tutorials that all have essentially the same steps, and I'm getting the same results.

Can anyone give me a push in the right direction?

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.

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.

SuppliersTest2.aspx.vb:

    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

End Class

© Stack Overflow or respective owner

Related posts about dataaccesslayer

Related posts about dataaccess