Namespace Not Found?

[Arpan]

I successfully compiled a "Database.v b" file (existing in
C:\Inetpub\wwwr oot\ASPX\Busine ss) into "Database.d ll" (in
C:\Inetpub\wwwr oot\ASPX\bin). The namespace in "Database.v b" is
"Database" which encapsulates a class named "DBSettings ". This is the
code in "Database.v b":

Imports System
Imports System.Data
Imports System.Data.Sql Client

Namespace Database
Public Class DBSettings
Private sqlCmd As SqlCommand
Private sqlConn As SqlConnection
Public ConnectionStrin g As String

Public Function QueryDB(ByVal qry As String) As SqlDataReader
sqlConn = New SqlConnection(C onnectionString )
sqlCmd = New SqlCommand(qry, sqlConn)

sqlConn.Open()
Return sqlCmd.ExecuteR eader

sqlConn.Close()
End Function
End Class
End Namespace

To use the above namespace in a class file named "Users.vb" (which
exists in the same folder as "Database.v b"), I am using the following
code:

Imports Database

Namespace Users
Public Class User
Public Function Login(ByVal UserName As String, ByVal Password
As String) As Integer
Dim iID As Integer
Dim boDBSet As DBSettings
Dim sqlReader As SqlDataReader

boDBSet = New DBSettings
boDBSet.Connect ionString = "Data Source=......."
sqlReader = boDBSet.QueryDB ("SELECT ID FROM tblUsers WHERE
UserName='" & UserName & "' AND Password='" & Password & "'")

Do While (sqlReader.Read )
iID = sqlReader.GetIn t32(0)
Loop

Return iID
End Function
End Class
End Namespace

But when I try to compile the above code into "Users.dll" (in the same
folder where "Database.d ll" exists) from the command prompt, the
following errors gets generated:

Namespace or type specified in the Imports 'Database' doesn't contain
any public member or cannot be found. Make sure the namespace or the
type is defined and contains at least one public member.

Type 'DBSettings' is not defined.

which points to the following 2 lines

Dim boDBSet As DBSettings
boDBSet = New DBSettings

What am I doing wrong here?

Thanks,

Arpan

[Hans Kesting]

I successfully compiled a "Database.v b" file (existing in

C:\Inetpub\wwwr oot\ASPX\Busine ss) into "Database.d ll" (in
C:\Inetpub\wwwr oot\ASPX\bin). The namespace in "Database.v b" is
"Database" which encapsulates a class named "DBSettings ". This is the
code in "Database.v b":

[snip]

But when I try to compile the above code into "Users.dll" (in the same
folder where "Database.d ll" exists) from the command prompt, the
following errors gets generated:

Namespace or type specified in the Imports 'Database' doesn't contain
any public member or cannot be found. Make sure the namespace or the
type is defined and contains at least one public member.

Type 'DBSettings' is not defined.

which points to the following 2 lines

Dim boDBSet As DBSettings
boDBSet = New DBSettings

What am I doing wrong here?

Thanks,

Arpan

The "Imports" statement ("using" in C#) doesn't "do" anything. It
doesn't provide a link to a dll, it just enables the programmer to
leave out the namespaces.
I think you need to find a switch for that command-line compiler (maybe
\r ?) that enables you to specify dll's to be referenced.

Hans Kesting