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

Question

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

Answer 1

I also had the same problem and finally found the solution. try followings; 1) Right click on your DataSet and select properties 2) Under the dataset properties, set a name for Prifix property. 3) debug your application. 4) in your application(C#.net) import the namesapce as using DALexample.MyTableAdapters;

DALexample is your project name...