Building a Dataset with Access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Curt Emich (cemich_at_comcast.net)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 14:57:04 -0500

I have another question about this process of getting a connection set up
and then populating a drop-down list box with a query.

I was able to create a connection like you said, and then I created a data
adapter. I then clicked on "generate dataset" and named a dataset to be
created from a query I specified. I get this build error:

"The type or namespace name 'dsStatements' does not exist in the class or
namespace 'TrainOfThought.TrainOfThought' (are you missing an assembly
reference?)"

"dsStatements", of course, is the name of the dataset. "TrainOfThought" is
the name of the application and the namespace and the main class. The code
doesn't seem to generate a dataset object. Instead, I get this code at the
top of the "TrainOfThought" class:

protected System.Data.OleDb.OleDbConnection cnnTrainOfThought;

protected System.Data.OleDb.OleDbCommand oleDbInsertCommand1;

protected System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;

protected System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;

protected System.Data.OleDb.OleDbDataAdapter adaStatements;

protected System.Data.OleDb.OleDbCommand cmdSelectStatements;

protected TrainOfThought.dsStatements dsStatements1;

protected System.Web.UI.WebControls.DropDownList DropDownList1;

The second to last line is the problem. I can't see why it's generated the
way it is. I would expect it to come from System.Data.Dataset, not
"TrainOfThought.dsStatements". Does anyone know what I'm doing wrong here
or how I can work around it?

Relevant Pages

  • Re: Using Access with Data Object Connections
    ... I have another question about this process of getting a connection set ... up and then populating a drop-down list box with a query. ... "The type or namespace name 'dsStatements' does not exist in the class ...
    (microsoft.public.dotnet.framework.adonet)
  • Building a Dataset with Access
    ... I have another question about this process of getting a connection set up ... and then populating a drop-down list box with a query. ... "The type or namespace name 'dsStatements' does not exist in the class or ... namespace 'TrainOfThought.TrainOfThought' (are you missing an assembly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Decision Tables
    ... namespace parser{ ... switch ){ ... bool b = expr; ... "See source grammar for query syntax\n" ...
    (comp.programming)
  • Re: Simple xpath query with default namespace
    ... query (a prefix that's no actually in the xml) in order for the library ... whether it's the default namespace. ... then when you have your XPath query you will need to tell XPath which Account ...
    (microsoft.public.dotnet.languages.csharp)