SQLHelper Class problem : For Gregory A. Beamer

[Rajesh Madhra]

Hi Gregory
Thanks for your answer. I did not see any attached file so I copied your
text into a text file and named it compiler.bat
Checked the wrapped lines and runned the file. It said Dataset, Datareader
and some other things are not defined. So I entered the :

Imports Microsoft.Appli cationBlocks.Da ta
Imports system
Imports system.data
Imports System.Data.Sql Client
Imports System.xml

into the SQLHelper.vb file and tried again. This time it says that
ArgumentNullExc eption is not defined.
I uninstalled the version2 and then downloaded and installed version1,
because there is no ArgumentNullExc eption in version1's SQLHelper.vb file.
Corrected compiler.bat file by Removing v2 from ...\Data Access v2\... and
runned it but nothing happens.
Any idea what I am doing wrong ?

If you will attach a file, i would like to get it on ma****@yahoo.co m,
because on the site I did not see any attachment.

Thanks for your help
Madhra

Re: SQLHelper Class problem
From: Cowboy \(Gregory A. Beamer\)
Date Posted: 7/16/2003 1:44:00 PM

The problem is with references to other classes.

Here is a script for The Data Block v2 with Framework 1.1 (.NET 2003).
Either copy the code below (watching line wraps) into a text file and place
in, or copy the attached file to:

C:\Program Files\Microsoft Application Blocks for .NET\Data Access
v2\Code\VB\Micr osoft.Applicati onBlocks.Data

Then, run the .bat file and you can compile the SQLHelper class into the
proper DLL. You can then reference this DLL in your /bin folder for your
site.
REM =============== =============== =============== =============== ====
REM
REM Data Access Compile Script
REM Date: 07/16/2003
REM Author: Gregory A. Beamer
REM
REM Uncomment version 1 if you are compiling it
REM NOTE: You may have to change Windows to WINNT (Windows 2000)
REM
REM =============== =============== =============== =============== ====
REM *************** **************
REM Alter Path
REM *************** **************

PATH=c:\Program Files\Microsoft Visual Studio .NET
2003\Common7\ID E;c:\Program Files\Microsoft Visual Studio .NET
2003\VC7\BIN;c: \Program Files\Microsoft Visual Studio .NET
2003\Common7\To ols;c:\Program Files\Microsoft Visual Studio .NET
2003\Common7\To ols\bin\prerele ase;c:\Program Files\Microsoft Visual Studio
...NET 2003\Common7\To ols\bin;c:\Prog ram Files\Microsoft Visual Studio .NET
2003\SDK\v1.1\b in;c:\WINDOWS\M icrosoft.NET\Fr amework\v1.1.43 22;C:\WINDOWS\s y
stem32;C:\WINDO WS;C:\WINDOWS\S ystem32\Wbem;C: \Program Files\Microsoft SQL
Server\80\Tools \BINN;C:\Progra m Files\Common
Files\OpSession \Shared;C:\Prog ram Files\Common Files\OpSession \Viewer
Shared;;C:\WIND OWS\Microsoft.N ET\Framework\v1 .1.4322;C:\Prog ram
Files\Microsoft Application Blocks for .NET\Data Access
v2\Code\VB\Micr osoft.Applicati onBlocks.Data;C :\WINDOWS\Micro soft.NET\Framew o
rk\v1.1.4322;C: \Program Files\Microsoft Application Blocks for .NET\Data
Access
v2\Code\VB\Micr osoft.Applicati onBlocks.Data;C :\WINDOWS\Micro soft.NET\Framew o
rk\v1.1.4322

PATH=%PATH%;C:\ Program Files\Microsoft Application Blocks for .NET\Data
Access
v2\Code\VB\Micr osoft.Applicati onBlocks.Data;C :\WINDOWS\Micro soft.NET\Framew o
rk\v1.1.4322;C: \Program Files\Microsoft Application Blocks for .NET\Data
Access v2\Code\VB\Micr osoft.Applicati onBlocks.Data

REM *************** **************
REM Compile the Application Block
REM *************** **************

vbc.exe /r:System.dll /r:System.Data.d ll /r:System.xml.dl l /t:library
/nologo /out:Microsoft.A pplicationBlock s.Data.dll SqlHelper.vb