Name 'SqlDbType' is not declared?

[Jerome]

Hi,

I keep getting the same compiler error: 'Name 'SqlDbType' is not
declared' and I don't know why?

I've declared the following:

<%@ Page Language="VB" ContentType="te xt/html"
ResponseEncodin g="iso-8859-1" %>
<%@ import Namespace="Syst em.Data." %>
<%@ import Namespace="Syst em.Data.Sqlclie nt" %>
<%@ import Namespace="Syst em.Data.SqlDbTy pe" %>

What am I missing?

Any help would be greatly appreciated!

Jerome

[Martin Dechev]

Jerome,

There is no namespace System.Data.Sql DbType.

System.Data.Sql Client.SqlDbTyp e is an enum and you can't use it with the
Import keyword.

Hope this helps
Martin
"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
news:#k******** ******@TK2MSFTN GP09.phx.gbl...

Hi,

I keep getting the same compiler error: 'Name 'SqlDbType' is not
declared' and I don't know why?

I've declared the following:

<%@ Page Language="VB" ContentType="te xt/html"
ResponseEncodin g="iso-8859-1" %>
<%@ import Namespace="Syst em.Data." %>
<%@ import Namespace="Syst em.Data.Sqlclie nt" %>
<%@ import Namespace="Syst em.Data.SqlDbTy pe" %>

What am I missing?

Any help would be greatly appreciated!

Jerome

[Jerome]

Thanks Martin, but what could the reason be for that error message then?
Because even when removing the import keyword, it keeps getting displayed.

How do I declare that SqlDbType?

Thanks.
Martin Dechev wrote:

Jerome,

There is no namespace System.Data.Sql DbType.

System.Data.Sql Client.SqlDbTyp e is an enum and you can't use it with the
Import keyword.

Hope this helps
Martin
"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
news:#k******** ******@TK2MSFTN GP09.phx.gbl...

Hi,

I keep getting the same compiler error: 'Name 'SqlDbType' is not
declared' and I don't know why?

I've declared the following:

<%@ Page Language="VB" ContentType="te xt/html"
ResponseEncod ing="iso-8859-1" %>
<%@ import Namespace="Syst em.Data." %>
<%@ import Namespace="Syst em.Data.Sqlclie nt" %>
<%@ import Namespace="Syst em.Data.SqlDbTy pe" %>

What am I missing?

Any help would be greatly appreciated!

Jerome

[Jerome]

Here's the line where the error comes:

cmdInsert.Param eters.Add( "@datedebut ", SqlDbType.Small DateTime
).Value=datedeb ut.Text )

Perhaps that'll help?

Jerome wrote:

Thanks Martin, but what could the reason be for that error message then?
Because even when removing the import keyword, it keeps getting displayed.

How do I declare that SqlDbType?

Thanks.
Martin Dechev wrote:

Jerome,

There is no namespace System.Data.Sql DbType.

System.Data.Sql Client.SqlDbTyp e is an enum and you can't use it with the
Import keyword.

Hope this helps
Martin
"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
news:#k******** ******@TK2MSFTN GP09.phx.gbl...

Hi,

I keep getting the same compiler error: 'Name 'SqlDbType' is not
declared' and I don't know why?

I've declared the following:

<%@ Page Language="VB" ContentType="te xt/html"
ResponseEncodin g="iso-8859-1" %>
<%@ import Namespace="Syst em.Data." %>
<%@ import Namespace="Syst em.Data.Sqlclie nt" %>
<%@ import Namespace="Syst em.Data.SqlDbTy pe" %>

What am I missing?

Any help would be greatly appreciated!

Jerome

[Martin Dechev]

You don't need to declare it, just use it:

Dim dbInt As SqlDbType = _
SqlDbType.Int

Have a look at:

http://msdn.microsoft.com/library/en...umerations.asp

Greetings
Martin
"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
news:uk******** ******@TK2MSFTN GP10.phx.gbl...

Thanks Martin, but what could the reason be for that error message then?
Because even when removing the import keyword, it keeps getting displayed.

How do I declare that SqlDbType?

Thanks.
Martin Dechev wrote:

Jerome,

There is no namespace System.Data.Sql DbType.

System.Data.Sql Client.SqlDbTyp e is an enum and you can't use it with the
Import keyword.

Hope this helps
Martin
"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
news:#k******** ******@TK2MSFTN GP09.phx.gbl...

Hi,

I keep getting the same compiler error: 'Name 'SqlDbType' is not
declared' and I don't know why?

I've declared the following:

<%@ Page Language="VB" ContentType="te xt/html"
ResponseEncod ing="iso-8859-1" %>
<%@ import Namespace="Syst em.Data." %>
<%@ import Namespace="Syst em.Data.Sqlclie nt" %>
<%@ import Namespace="Syst em.Data.SqlDbTy pe" %>

What am I missing?

Any help would be greatly appreciated!

Jerome

[Martin Dechev]

For this exact error try:

cmdInsert.Param eters.Add( _
"@datedebut ", _
System.Data.Sql Client.SqlDbTyp e.SmallDateTime ).Value = _
DateTime.Parse( datedebut.Text)

Or some other overload of the static Parse method, or the static ParseExact
method on the DateTime structure, depending on the input.

Hope this helps
Martin
"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
news:#x******** ******@TK2MSFTN GP11.phx.gbl...

Here's the line where the error comes:

cmdInsert.Param eters.Add( "@datedebut ", SqlDbType.Small DateTime
).Value=datedeb ut.Text )

Perhaps that'll help?

Jerome wrote:

Thanks Martin, but what could the reason be for that error message then?
Because even when removing the import keyword, it keeps getting displayed.
How do I declare that SqlDbType?

Thanks.
Martin Dechev wrote:

Jerome,

There is no namespace System.Data.Sql DbType.

System.Data.Sql Client.SqlDbTyp e is an enum and you can't use it with the Import keyword.

Hope this helps
Martin
"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
news:#k******** ******@TK2MSFTN GP09.phx.gbl...

Hi,

I keep getting the same compiler error: 'Name 'SqlDbType' is not
declared' and I don't know why?

I've declared the following:

<%@ Page Language="VB" ContentType="te xt/html"
ResponseEncodin g="iso-8859-1" %>
<%@ import Namespace="Syst em.Data." %>
<%@ import Namespace="Syst em.Data.Sqlclie nt" %>
<%@ import Namespace="Syst em.Data.SqlDbTy pe" %>

What am I missing?

Any help would be greatly appreciated!

Jerome

[Jerome]

Thanks Martin, but now I get the following:

Compiler Error Message: BC30456: 'SqlDbType' is not a member of 'SqlClient'.

I really don't quite get it because: cmdInsert.Param eters.Add(
"@datedebut ", SqlDbType.Small DateTime).Value =datedebut.Text is the
adaptation of an example from an asp.net book! They only difference is
in the example it was SqlDbType.Money that was used...

I'm trying to find out some more.

Martin Dechev wrote:

For this exact error try:

cmdInsert.Param eters.Add( _
"@datedebut ", _
System.Data.Sql Client.SqlDbTyp e.SmallDateTime ).Value = _
DateTime.Parse( datedebut.Text)

Or some other overload of the static Parse method, or the static ParseExact
method on the DateTime structure, depending on the input.

Hope this helps
Martin
"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
news:#x******** ******@TK2MSFTN GP11.phx.gbl...

Here's the line where the error comes:

cmdInsert.Par ameters.Add( "@datedebut ", SqlDbType.Small DateTime
).Value=dated ebut.Text )

Perhaps that'll help?

Jerome wrote:

Thanks Martin, but what could the reason be for that error message then?
Because even when removing the import keyword, it keeps getting
displayed.
How do I declare that SqlDbType?

Thanks.
Martin Dechev wrote:
Jerome,

There is no namespace System.Data.Sql DbType.

System.Data .SqlClient.SqlD bType is an enum and you can't use it with
the
Import keyword.

Hope this helps
Martin
"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
news:#k**** **********@TK2M SFTNGP09.phx.gb l...
>Hi,
>
>I keep getting the same compiler error: 'Name 'SqlDbType' is not
>declared ' and I don't know why?
>
>I've declared the following:
>
><%@ Page Language="VB" ContentType="te xt/html"
>ResponseEn coding="iso-8859-1" %>
><%@ import Namespace="Syst em.Data." %>
><%@ import Namespace="Syst em.Data.Sqlclie nt" %>
><%@ import Namespace="Syst em.Data.SqlDbTy pe" %>
>
>What am I missing?
>
>Any help would be greatly appreciated!
>
>Jerome

[Martin Dechev]

Sorry, it was my mistake, SqlDbType is in fact in the System.Data namespace,
not in System.Data.Sql Client.

If datedebut.Text is "27/04/2004 15:30:00" the following should work:

cmdInsert.Param eters.Add( _
"@datedebut ", _
System.Data.Sql Client.SqlDbTyp e.SmallDateTime ).Value = _
DateTime.ParseE xact(datedebut. Text, _
"dd/MM/yyyy HH:mm:ss", _
System.Globaliz ation.DateTimeF ormatInfo.Invar iantInfo)

Greetings
Martin
"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
news:Oe******** ******@TK2MSFTN GP12.phx.gbl...

Thanks Martin, but now I get the following:

Compiler Error Message: BC30456: 'SqlDbType' is not a member of 'SqlClient'.
I really don't quite get it because: cmdInsert.Param eters.Add(
"@datedebut ", SqlDbType.Small DateTime).Value =datedebut.Text is the
adaptation of an example from an asp.net book! They only difference is
in the example it was SqlDbType.Money that was used...

I'm trying to find out some more.

Martin Dechev wrote:

For this exact error try:

cmdInsert.Param eters.Add( _
"@datedebut ", _
System.Data.Sql Client.SqlDbTyp e.SmallDateTime ).Value = _
DateTime.Parse( datedebut.Text)

Or some other overload of the static Parse method, or the static ParseExact method on the DateTime structure, depending on the input.

Hope this helps
Martin
"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
news:#x******** ******@TK2MSFTN GP11.phx.gbl...

Here's the line where the error comes:

cmdInsert.Par ameters.Add( "@datedebut ", SqlDbType.Small DateTime
).Value=dated ebut.Text )

Perhaps that'll help?

Jerome wrote:
Thanks Martin, but what could the reason be for that error message then?Because even when removing the import keyword, it keeps getting

displayed.

How do I declare that SqlDbType?

Thanks.
Martin Dechev wrote:
>Jerome,
>
>There is no namespace System.Data.Sql DbType.
>
>System.Data .SqlClient.SqlD bType is an enum and you can't use it with

the

>Import keyword.
>
>Hope this helps
>Martin
>"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
>news:#k**** **********@TK2M SFTNGP09.phx.gb l...
>
>
>>Hi,
>>
>>I keep getting the same compiler error: 'Name 'SqlDbType' is not
>>declared ' and I don't know why?
>>
>>I've declared the following:
>>
>><%@ Page Language="VB" ContentType="te xt/html"
>>ResponseEn coding="iso-8859-1" %>
>><%@ import Namespace="Syst em.Data." %>
>><%@ import Namespace="Syst em.Data.Sqlclie nt" %>
>><%@ import Namespace="Syst em.Data.SqlDbTy pe" %>
>>
>>What am I missing?
>>
>>Any help would be greatly appreciated!
>>
>>Jerome
>
>
>

[Martin Dechev]

"Martin Dechev" <de*******@hotm ail.com> wrote in message
news:uK******** ******@TK2MSFTN GP09.phx.gbl...

Sorry, it was my mistake, SqlDbType is in fact in the System.Data namespace, not in System.Data.Sql Client.

If datedebut.Text is "27/04/2004 15:30:00" the following should work:

cmdInsert.Param eters.Add( _
"@datedebut ", _
System.Data.Sql Client.SqlDbTyp e.SmallDateTime ).Value = _
DateTime.ParseE xact(datedebut. Text, _
"dd/MM/yyyy HH:mm:ss", _
System.Globaliz ation.DateTimeF ormatInfo.Invar iantInfo)
And I should stop copy-pasting wrong code....

cmdInsert.Param eters.Add( _
"@datedebut ", _
System.Data.Sql DbType.SmallDat eTime).Value = _
DateTime.ParseE xact(datedebut. Text, _
"dd/MM/yyyy HH:mm:ss", _
System.Globaliz ation.DateTimeF ormatInfo.Invar iantInfo)

Greetings
Martin
"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
news:Oe******** ******@TK2MSFTN GP12.phx.gbl...

Thanks Martin, but now I get the following:

Compiler Error Message: BC30456: 'SqlDbType' is not a member of

'SqlClient'.

I really don't quite get it because: cmdInsert.Param eters.Add(
"@datedebut ", SqlDbType.Small DateTime).Value =datedebut.Text is the
adaptation of an example from an asp.net book! They only difference is
in the example it was SqlDbType.Money that was used...

I'm trying to find out some more.

Martin Dechev wrote:

For this exact error try:

cmdInsert.Param eters.Add( _
"@datedebut ", _
System.Data.Sql Client.SqlDbTyp e.SmallDateTime ).Value = _
DateTime.Parse( datedebut.Text)

Or some other overload of the static Parse method, or the static ParseExact method on the DateTime structure, depending on the input.

Hope this helps
Martin
"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
news:#x******** ******@TK2MSFTN GP11.phx.gbl...

>Here's the line where the error comes:
>
>cmdInsert.Par ameters.Add( "@datedebut ", SqlDbType.Small DateTime
>).Value=dated ebut.Text )
>
>Perhaps that'll help?
>
>Jerome wrote:
>
>
>>Thanks Martin, but what could the reason be for that error message then?>>Because even when removing the import keyword, it keeps getting

displayed.

>>How do I declare that SqlDbType?
>>
>>Thanks.
>>
>>
>>Martin Dechev wrote:
>>
>>
>>>Jerome,
>>>
>>>There is no namespace System.Data.Sql DbType.
>>>
>>>System.Data .SqlClient.SqlD bType is an enum and you can't use it with

the

>>>Import keyword.
>>>
>>>Hope this helps
>>>Martin
>>>"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
>>>news:#k**** **********@TK2M SFTNGP09.phx.gb l...
>>>
>>>
>>>>Hi,
>>>>
>>>>I keep getting the same compiler error: 'Name 'SqlDbType' is not
>>>>declared ' and I don't know why?
>>>>
>>>>I've declared the following:
>>>>
>>>><%@ Page Language="VB" ContentType="te xt/html"
>>>>ResponseEn coding="iso-8859-1" %>
>>>><%@ import Namespace="Syst em.Data." %>
>>>><%@ import Namespace="Syst em.Data.Sqlclie nt" %>
>>>><%@ import Namespace="Syst em.Data.SqlDbTy pe" %>
>>>>
>>>>What am I missing?
>>>>
>>>>Any help would be greatly appreciated!
>>>>
>>>>Jerome
>>>
>>>
>>>

[Jerome]

Thanks, now it works!

Always these troubles with the dates ... ;)

Martin Dechev wrote:

"Martin Dechev" <de*******@hotm ail.com> wrote in message
news:uK******** ******@TK2MSFTN GP09.phx.gbl...

Sorry, it was my mistake, SqlDbType is in fact in the System.Data

namespace,

not in System.Data.Sql Client.

If datedebut.Text is "27/04/2004 15:30:00" the following should work:

cmdInsert.Par ameters.Add( _
"@datedebut ", _
System.Data.Sql Client.SqlDbTyp e.SmallDateTime ).Value = _
DateTime.ParseE xact(datedebut. Text, _
"dd/MM/yyyy HH:mm:ss", _
System.Globaliz ation.DateTimeF ormatInfo.Invar iantInfo)

And I should stop copy-pasting wrong code....

cmdInsert.Param eters.Add( _
"@datedebut ", _
System.Data.Sql DbType.SmallDat eTime).Value = _
DateTime.ParseE xact(datedebut. Text, _
"dd/MM/yyyy HH:mm:ss", _
System.Globaliz ation.DateTimeF ormatInfo.Invar iantInfo)

Greetings
Martin
"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
news:Oe****** ********@TK2MSF TNGP12.phx.gbl. ..

Thanks Martin, but now I get the following:

Compiler Error Message: BC30456: 'SqlDbType' is not a member of

'SqlClient' .

I really don't quite get it because: cmdInsert.Param eters.Add(
"@datedebut" , SqlDbType.Small DateTime).Value =datedebut.Text is the
adaptation of an example from an asp.net book! They only difference is
in the example it was SqlDbType.Money that was used...

I'm trying to find out some more.

Martin Dechev wrote:
For this exact error try:

cmdInsert.P arameters.Add( _
"@datedebut ", _
System.Data.Sql Client.SqlDbTyp e.SmallDateTime ).Value = _
DateTime.Parse( datedebut.Text)

Or some other overload of the static Parse method, or the static

ParseExact

method on the DateTime structure, depending on the input.

Hope this helps
Martin
"Jerome" <jh***@no.mnhn. spam.lu> wrote in message
news:#x**** **********@TK2M SFTNGP11.phx.gb l...
>Here's the line where the error comes:
>
>cmdInsert. Parameters.Add( "@datedebut ", SqlDbType.Small DateTime
>).Value=da tedebut.Text )
>
>Perhaps that'll help?
>
>Jerome wrote:
>
>
>
>>Thanks Martin, but what could the reason be for that error message

then?

>>Because even when removing the import keyword, it keeps getting

displayed .
>>How do I declare that SqlDbType?
>>
>>Thanks.
>>
>>
>>Martin Dechev wrote:
>>
>>
>>
>>>Jerome ,
>>>
>>>There is no namespace System.Data.Sql DbType.
>>>
>>>System.D ata.SqlClient.S qlDbType is an enum and you can't use it with

the
>>>Import keyword.
>>>
>>>Hope this helps
>>>Martin
>>>"Jerom e" <jh***@no.mnhn. spam.lu> wrote in message
>>>news:#k* *************@T K2MSFTNGP09.phx .gbl...
>>>
>>>
>>>
>>>>Hi,
>>>>
>>>>I keep getting the same compiler error: 'Name 'SqlDbType' is not
>>>>declare d' and I don't know why?
>>>>
>>>>I've declared the following:
>>>>
>>>><%@ Page Language="VB" ContentType="te xt/html"
>>>>Respons eEncoding="iso-8859-1" %>
>>>><%@ import Namespace="Syst em.Data." %>
>>>><%@ import Namespace="Syst em.Data.Sqlclie nt" %>
>>>><%@ import Namespace="Syst em.Data.SqlDbTy pe" %>
>>>>
>>>>What am I missing?
>>>>
>>>>Any help would be greatly appreciated!
>>>>
>>>>Jerom e
>>>
>>>
>>>