Problems with doing an SQL insert stored procedure

[EmJayEm]

I'm having some problems with this line when I do a SQL insert stored
procedure:

Compiler Error Message: BC30451: Name 'CommandType' is not declared.

Source Error:
Line 65: cmd.Parameters.Add( "@EmployeeID", newEmployeeId)
Line 66:
Line 67: cmd.CommandType = CommandType.StoredProcedure
Line 68:
Line 69: conn.Open()
Any ideas anyone?

Thanks,

EmJ.

[Karl Seguin]

Make sure that System.Data is imported...my guess is that you only have
System.Data.SqlClient or System.data.OleDbClient

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"EmJayEm" <Wo*@eookie.com> wrote in message
news:Z9******************@fe3.news.blueyonder.co.u k...

I'm having some problems with this line when I do a SQL insert stored
procedure:

Compiler Error Message: BC30451: Name 'CommandType' is not declared.

Source Error:
Line 65: cmd.Parameters.Add( "@EmployeeID", newEmployeeId) Line 66:
Line 67: cmd.CommandType = CommandType.StoredProcedure
Line 68:
Line 69: conn.Open()
Any ideas anyone?

Thanks,

EmJ.

[Mark Fitzpatrick]

Assuming that you imported the System.Data.SqlClient, System.Data.OleDb, or
another namespace to connect to the DB, did you also import the System.Data
namespace? I've seen it happen a couple times where the
System.Data.SqlClient namespace (or whatever is appropriate for the given
database) is imported since all the connection and command objects, but the
System.Data namespace is forgotten. You have to import the System.Data
namespace in order to use the CommandType because it lives in the
System.Data namespace as System.Data.CommandType.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

"EmJayEm" <Wo*@eookie.com> wrote in message
news:Z9******************@fe3.news.blueyonder.co.u k...

I'm having some problems with this line when I do a SQL insert stored
procedure:

Compiler Error Message: BC30451: Name 'CommandType' is not declared.

Source Error:
Line 65: cmd.Parameters.Add( "@EmployeeID",
newEmployeeId)
Line 66:
Line 67: cmd.CommandType = CommandType.StoredProcedure
Line 68:
Line 69: conn.Open()
Any ideas anyone?

Thanks,

EmJ.

[Curt_C [MVP]]

Hmm... should work. Try using the full namespace.
How is cmd declared?

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"EmJayEm" <Wo*@eookie.com> wrote in message
news:Z9******************@fe3.news.blueyonder.co.u k...

I'm having some problems with this line when I do a SQL insert stored
procedure:

Compiler Error Message: BC30451: Name 'CommandType' is not declared.

Source Error:
Line 65: cmd.Parameters.Add( "@EmployeeID",
newEmployeeId)
Line 66:
Line 67: cmd.CommandType = CommandType.StoredProcedure
Line 68:
Line 69: conn.Open()
Any ideas anyone?

Thanks,

EmJ.

[EmJayEm]

Cheers guys for replying.

I didn't have the System.Data namespace
EmJ.
"Mark Fitzpatrick" <ma******@fitzme.com> wrote in message
news:ut****************@TK2MSFTNGP10.phx.gbl...

Assuming that you imported the System.Data.SqlClient, System.Data.OleDb,
or another namespace to connect to the DB, did you also import the
System.Data namespace? I've seen it happen a couple times where the
System.Data.SqlClient namespace (or whatever is appropriate for the given
database) is imported since all the connection and command objects, but
the System.Data namespace is forgotten. You have to import the System.Data
namespace in order to use the CommandType because it lives in the
System.Data namespace as System.Data.CommandType.

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

"EmJayEm" <Wo*@eookie.com> wrote in message
news:Z9******************@fe3.news.blueyonder.co.u k...

I'm having some problems with this line when I do a SQL insert stored
procedure:

Compiler Error Message: BC30451: Name 'CommandType' is not declared.

Source Error:
Line 65: cmd.Parameters.Add( "@EmployeeID",
newEmployeeId)
Line 66:
Line 67: cmd.CommandType = CommandType.StoredProcedure
Line 68:
Line 69: conn.Open()
Any ideas anyone?

Thanks,

EmJ.