Inserting Records Via Stored Procedure

I am trying to insert a record in a SQL2005 Express database. I can use the sp fine and it works inside of the database, but when I try to launch it via ASP.NET it fails...

here is the code. I realize it is not complete, but the only required field is defined via hard code. The error I am getting states it cannot find "sp_InserOrder"

 

===

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim conn As SqlConnection = Nothing

Dim trans As SqlTransaction = Nothing

Dim cmd As SqlCommand

conn = New SqlConnection(ConfigurationManager.ConnectionStrings("PartsConnectionString").ConnectionString)

conn.Open()

trans = conn.BeginTransaction

cmd = New SqlCommand()

cmd.Connection = conn

cmd.Transaction = trans

cmd.CommandText = "usp_InserOrder"

cmd.CommandType = Data.CommandType.StoredProcedure

cmd.Parameters.Add("@MaterialID", Data.SqlDbType.Int)

cmd.Parameters.Add("@OpenItem", Data.SqlDbType.Bit)

cmd.Parameters("@MaterialID").Value = 3

cmd.ExecuteNonQuery()

trans.Commit()

=====

 

I get an error stating cannot find stored procedure. I added the Network Service account full access to the Web Site Directory, which is currently running locally on Windows XP Pro SP2.

 

Please help, I am a newb and lost...as you can tell from my code...