TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Tommy Bell
NA
21
0
Question about certain line -> using NorthwindTableAdapters; // Data Access Layer/logic
Apr 6 2008 2:20 PM
Im trying to make a simple site, that will get its content from a database, following the tutorial from MSDN(http://msdn2.microsoft.com/en-us/library/aa581776.aspx), where they use a northwind sample site - I can get it working fine.
However, when I attempt to apply the same tecniques to my own site, it doesnt work. I have narrowed it down to the following problem
In the sample project, they use a NorthwindTableAdator
using northwindtableadaptor;
This I can figure out where comes from, or how i get to use the adaptors that will make my project work, I cant seem to find out where I have to define the tableadaptors, I've built a tableadaptor and it can pull informaiton out of my database, and I have included the code in the codebehind file, of the page I am trying to show the information on, as follows.
My database is enkelt.mdf
my tablename -> project
in my app_code folder i have an 'ShowProjectList.xsd' where my tableadaptor is defined in as follows:
Projects <- title
ProjectTitle <- row in table
ProjectAuthor <- row in table
ProjectTableAdaptor
Fill, GetProjectList() <- methods
ShowProjects.cs:
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
//notice we are missing the 'using NorthwindTableAdapters;' that the sample project has
//and I do not know what to put there instead to make my project work
public partial class ShowProjects : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//intended here is to give a list of projects in the database
ProjectTableAdapter projectsAdapter = new ProjectTableAdapter();
ListView1.DataSource = projectsAdapter.GetProjectList();
ListView1.DataBind();
}
}
An attempt to compile this will result in the following error:
Error 1 The type or namespace name 'ProjectTableAdapter' could not be found (are you missing a using directive or an assembly reference?) G:\page\ShowProjects.aspx.cs 20 9 G:\page\
So, any ideas on what I have to do, or what I have to read so I can find out what I need to do to make this work?
Reply
Answers (
3
)
Is it possible for me to throw an event from one application and catch it from another?
command buttons On_click