[dba-VB] Type Is Not Defined

ACTEBS actebs at actebs.com.au
Wed Dec 8 21:58:25 CST 2010


Now that's funny!

Yep in Canberra and it's just stopped raining! Over 100mm overnight and
everything is under water. Luckily we haven't been affected, but a lot of
people around Canberra are struggling... Where are you located? Have you
been affected by the rains?

I've got the Crystal Report to work with some mucking around, but once I've
gotten the hang of it, it seems OK. When you say huge assemblies to move
around, aren't they just part of the .Net Framework or are there additional
files to be included in the install package?

Thanks

Vlad

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Michael Maddison
Sent: Thursday, 9 December 2010 2:23 PM
To: Discussion concerning Visual Basic and related programming issues.
Subject: Re: [dba-VB] Type Is Not Defined

Lol,

 

C:\Program Files\MicrosoftVisual Studio 8\Crystal
Reports\Samples\En\Database\xtreme.mdb

 

It used to be like pulling teeth to get it to work right. Had to write
heaps of code to make them portable IIRC.

Huge assemblies to move around and keep up to date.

I haven't used it for years, I just use MS builtin reports now.

 

You will enjoy the .net world once you get the hang of it. Just ask JC!

 

BTW you're in Canberra aren't you?

Keeping dry?

 

Cheers

 

Michael

 

 

 

From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of ACTEBS
Sent: Thursday, 9 December 2010 1:57 PM
To: 'Discussion concerning Visual Basic and related programming issues.'
Subject: Re: [dba-VB] Type Is Not Defined

 

Hi Michael,

Thanks for your reply. I got to the bottom of it eventually. I needed to
make a data table schema of what I wanted returned from the DB. After I
did
that, everything worked as expected.

BTW, how did you know I was using the Crystal Reports tutorial? Also,
why
wouldn't you use that as a basis for learning how to use classes?

Thanks...

Vlad

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Michael
Maddison
Sent: Thursday, 9 December 2010 9:22 AM
To: Discussion concerning Visual Basic and related programming issues.
Subject: Re: [dba-VB] Type Is Not Defined

The compiler cant find 'CustomerDataSetSchema'.

Is it in another project? Set a ref to the project.

If you don't have the class then you need to get it and it needs to be
in the scope of the calling class, the tutorial should have it.

BTW, the last place I'd be learning .net classes is in a Crystal Reports
tutorial!



Cheers



Michael



From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of ACTEBS
Sent: Wednesday, 8 December 2010 2:19 PM
To: 'dba-vb'
Subject: [dba-VB] Type Is Not Defined



Hi Everyone,



This is my first attempt at a class, so don't laugh. I am doing this via
a
tutorial, and keep getting:



Type 'CustomerDataSetSchema' Is Not Defined.



I can't understand why this is throwing this error and hope someone can
shed
some light on it. The code is below:



Imports System.Data

Imports System.Data.OleDb



Public Class DataSetConfiguration

'Private Const CONNECTION_STRING As String =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program
Files\MicrosoftVisual Studio 8\Crystal
Reports\Samples\En\Database\xtreme.mdb"

Private Const QUERY_STRING As String = "SELECT * FROM tblMainData"

Private Const DATATABLE_NAME As String = "tblMainData"

'Bloew is for use within a website

'Private Const DIRECTORY_FILE_PATH As String =
"C:\WebSites\VB_Web_Data_DataSets\"

Public Shared ReadOnly Property CustomerDataSet() As DataSet

Get

Dim myDataSet As CustomerDataSetSchema = New CustomerDataSetSchema()

Dim myOleDbConnection As OleDbConnection = New
OleDbConnection(GetDestConnectionString) '(CONNECTION_STRING)

Dim myOleDbDataAdapter As OleDbDataAdapter = New
OleDbDataAdapter(QUERY_STRING, myOleDbConnection)



myOleDbDataAdapter.Fill(myDataSet, DATATABLE_NAME)

Return myDataSet



End Get

End Property



End Class



Many Thanks



Vlad











_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com

________________________________

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1170 / Virus Database: 426/3302 - Release Date: 12/07/10

_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com








_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com

________________________________

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1170 / Virus Database: 426/3304 - Release Date: 12/08/10

_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com











More information about the dba-VB mailing list