Michael Maddison
michael at ddisolutions.com.au
Wed Dec 8 21:23:27 CST 2010
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