"field used as type" build error DataSet for SQL Server connection

alec

i have a "field used as type" build error and it says

Error1'WindowsFormsApplication1.update_html1.test_db_DataSet' is a 'field' but is used like a 'type'

but as far as i can see form the .designer.cs file and .cs files it is actualy a type ... any ideas????

if anyone needs any details to shed light on this i would only be to happy to give you them.

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

alec15y ago
I know when I saw how much there was I was quite scared ... but pleased to find a cheeky answer :D
Vulpes15y ago
I'm relieved to hear that, alec ;)

My usual approach of trying to figure stuff out logically tends to struggle with designer generated code :(
alec15y ago
I have got it to work by lifting the code from the click events and putting it into a new solution ... it seams that VS just got its knickers in a twist :s I am very pleased that the solution didnt take too long to recreate
Vulpes15y ago
Well, it looks to me like the designer creates a field within the form itself called test_db_DataSet and assigns to this a new object of type update_html1.test_db_DataSet.

There's nothing wrong with that and the code for the ebay_test_db_DataSet is analogous.

I imagine that update_html1 must be another class within the WindowsFormsApplication1 namespace which has probably been generated by the designer.

So was the code you uploaded part of update_html1 and, if so, can you see a field in that class also named test_db_DataSet?
alec15y ago
you are quite right i had put up the wrong one and not added the bold sorry for this

private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
this.update_html_button = new System.Windows.Forms.Button();
this.gen_price_and_cat_sheet_button = new System.Windows.Forms.Button();
this.test_connection_button = new System.Windows.Forms.Button();
this.test_db_DataSet = new update_html1.test_db_DataSet();
this.testdbDataSetBindingSource = new System.Windows.Forms.BindingSource(this.components);
((System.ComponentModel.ISupportInitialize)(this.test_db_DataSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.testdbDataSetBindingSource)).BeginInit();
this.SuspendLayout();

//then button declarations and specifications

...
}

the ebay one is similar but less complicated ... and so works
Vulpes15y ago
Well, you're right that test_db_DataSet is a type but it's not actually used in the extract you posted from the InitializeComponent method.

There's an ebay_test_db_DataSet though that's not the same thing.

Also, you wouldn't expect there to be any errors in the designer generated code. It's far more likely to be in code you've written yourself.

So, are you sure the error is in there (no line was emboldened) or is it somewhere else?
alec15y ago
would help if I actually did put the file up
alec15y ago
the line causing the problem is in bold bellow:

private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
this.update_html_button = new System.Windows.Forms.Button();
this.gen_price_and_cat_sheet_button = new System.Windows.Forms.Button();
this.test_connection_button = new System.Windows.Forms.Button();
this.ebay_test_db_DataSet = new update_html1.ebay_test_db_DataSet();
this.ebaytestdbDataSetBindingSource = new System.Windows.Forms.BindingSource(this.components);
((System.ComponentModel.ISupportInitialize)(this.ebay_test_db_DataSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.ebaytestdbDataSetBindingSource)).BeginInit();
this.SuspendLayout();

//then button declarations and specifications

...
}

the definition is in the automatically generated test_db_DataSet.Designer.cs and is huge so I have included it as a file
Vulpes15y ago
Can you post:

1. The line of code which is causing this error and any earlier lines in the same method which you think may be relevant.

2. The field or type definition for WindowsFormsApplication1.update_html1.test_db_DataSet.