Tuesday, March 27, 2012

Calling Stored Procedure

I am trying to set up a call to a Stored Procedure to do an Insert. Here is my code snippet:

<%@. Page Language="VB" %>
<%@. import Namespace="System" %>
<%@. import Namespace="System.Data.SqlClient" %>
.
.
.
Dim loConn as New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
Dim cmdInsert as New SQLCommand("AdminUser_Insert", loConn)
cmdInsert.CommandType = CommandType.StoredProcedure

Dim InsertForm As New SqlDataAdapter()
InsertForm.InsertCommand = cmdInsert

cmdInsert.Parameters.Add(New SqlParameter("@.RETURN_VALUE", SqlDbType.bigint, 8, "Account_Number"))
cmdInsert.Parameters("@.RETURN_VALUE").Direction = ParameterDirection.ReturnValue
cmdInsert.Parameters.Add(New SqlParameter("@.UserID", SqlDbType.varchar, 50, "UserID"))
cmdInsert.Parameters("@.UserID").Value = Request("UserID")
cmdInsert.Parameters.Add(New SqlParameter("@.Password", SqlDbType.varchar, 32, "Password"))
cmdInsert.Parameters("@.Password").Value = Request("Password")
cmdInsert.Parameters.Add(New SqlParameter("@.First_Name", SqlDbType.varchar, 32, "First_Name"))
cmdInsert.Parameters("@.First_Name").Value = Request("FirstName")
cmdInsert.Parameters.Add(New SqlParameter("@.Middle_Name", SqlDbType.varchar, 32, "Middle_Name"))
cmdInsert.Parameters("@.Middle_Name").Value = Request("MiddleName")
cmdInsert.Parameters.Add(New SqlParameter("@.Last_Name", SqlDbType.varchar, 32, "Last_Name"))
cmdInsert.Parameters("@.Last_Name").Value = Request("LastName")

loConn.Open()
command.ExecuteNonQuery()
loConn.Close()

I get the following error:

Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

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

This error happens on the line: cmdInsert.CommandType = CommandType.StoredProcedure

Any help would be appreciated,
GregTry importing System.data. I think you're just missing that|||Ugh. That did it. Thank you very much. Been staring at it for a while.

Gregsql

No comments:

Post a Comment