SqlDbType is not declared ??

[markmcgookin]

Hi Folks,

I'm writing a VB app in .Net 2003, and I am getting a squiggley blue line error on mouse over (Yes that is a technical term)

saying "SqlDbType is not declared" when I mouse over the following

cmdInsert.Parameters.Add(New SqlCeParameter("@p1", SqlDbType.NText))
 

but I have imported (what I thought were) the appropriate namespaces

Imports System
Imports System.IO
Imports System.Data
Imports System.Text
Imports Microsoft.WindowsCE.Forms
Imports System.Data.Common
Imports System.Collections
Imports System.Data.SqlServerCe
 

I thought it would be included in System.Data and System.Data.SqlServerCe, as they are used in another example program I am working in, and it is not showing this error.

Any ideas?

[Killer42]

In the example program which works, you should be able to trace back to the definition of SqlDbType, and check where it resides.

[markmcgookin]

Well I figured it out!

Turned out that my Imports were correct, but my References to the .dll files (in solution explorer) weren't correct, I had to add a reference to System.Data.Common as well as an Include.

Hope this helps someone else with the same problem!