Datasets? - fixed it!

[SjR]

OK I'm very new to .NET...
I'm trying to get my head around ADO.NET but I can't declare a Dataset, which is kind of hindering my progress.

When I type Dim dsTest As Dataset()
or Dim dsTest As New Dataset()
the word 'Dataset' has the squiggly blue line and the tooltip says... 'Type "Dataset" is not defined'

Dataset does not appear in System.Data namespace either

I'm sure I'm missing something really obvious, could anyone help me?

[Athley]

I wonder what's in your System.Data namespace as my contains a Dataset object.....

[Athley]

Do you have the system.dll added as reference?

[Cander]

Is System.Data referenced?

[SjR]

Originally posted by Athley
Do you have the system.dll added as reference?

yes

Originally posted by Cander
Is System.Data referenced?

yes

look at my screen...

[Cander]

What version of VS .NET are you using. I get DataSet on my intellisense..

[SjR]

Microsoft Development Environment 2002 Version 7.0.9466
Microsoft .NET Framework 1.0 Version 1.0.3705


I think its broken .........

[Cander]

I dont get it.

[SjR]

I'm going to try downloading sp2 for the .net framework - I don't think I've already done that!?

I also noticed .net framework version 1.1 beta... should I be using that I wonder... because its the framework downloads that contain the system dll files isn't it? Oh I don't know - I'm just gonna download some stuff - can't get anyworse

[Cander]

mmm no dont get Framework 1.1 yet. I dont know if it works with your current Visual Studio. Maybe ..maybe not!

And I dont think the sp has anthing to do with it. i havent gotten sp2 or 1 on this system yet and I still get the DataSet

[m1k3l]

The reference you need to add is to System.Data

Open your reference thingy in your solution explorer to make sure it's there. If only System is there or System.anythingelse, then you need to add System.Data manually.

After that you'll need to add the line

Imports System.Data

on top of your code so that you can declare

Dim blah as new Dataset

otherwise you'll have to do

Dim blah as new System.Data.Dataset everytime

[SjR]

I have System.Data in my references... and despite whether I type..

"Imports System.Data" then
"Dim dsTest as Dataset"

or

"Dim dsTest as System.Data.Dataset"

Type 'Dataset' is not defined

[PilgrimPete]

OK, straw clutching time...
...what version of System.Data.dll do you have (though I can't believe any version didn't have datasets considering how key they are to ADO.NET..!)

My version (from WinCV) is as follows:
// from module 'c:\winnt\assembly\gac\system.data\1.0.3300.0__b77a5c561934e089\system.data.dll'

[SjR]

// from module 'c:\winnt\assembly\gac\system.data\1.0.3300.0__b77a5c561934e089\system.data.dll'

looks the same
hmmmmmm

I've just completely re-installed .NET... still can't see the bloomin' datasets

[SjR]

I've got 'Dataset' to appear in the namespace
I wish I could tell you how... but it really involved temper tantrums.. Violence... and much booting and re-booting .

Maybe the re-install helped ??

[PilgrimPete]

Gaaaaaaaaaaaahhhhhhhhhh!

Glad it's your problem not mine

Anyway you're far better off without datasets, I really can't understand where all that nice recordset functionality has gone...

More seriously, could you have declared a class/type/variable/enum (something!?) as Dataset elsewhere in your app that is causing a conflict? Have you tried declaring a dataset in a 'clean' app?

Help? I'm rambling.

[SjR]

It wasn't appearing in any (clean or dirty ) apps.
Now it's appearing in both, apps I've been working on, and new apps.

So, don't really know the answer - although it wouldn't surprise me one bit if its this tin-pot computer I'm using thats at fault!!

Datasets rubbish then? They looked like a good idea, which is why I was trying to learn how to do the damn things - bit complicated to start with, but once they're in place, database updates should be a piece of errrrrmm cake - or so MS would have you believe!