Incorrect syntax near...

[geo039]

Okay i am growing weary of staring. I keep getting incorrect syntax near 'usp_bldgs_c' I cannot figure out what that is. Please help!

Private Sub AddNewRecord(ByVal bldgdesc As String)

        Dim conString As String = Utilities.GetConnectionString("AssetInventory")
        Dim conInventory As SqlConnection = New SqlConnection(conString)
        Dim cmdStoredProc As SqlCommand


        cmdStoredProc = New SqlCommand("usp_bldgs_c", conInventory)
        cmdStoredProc.Parameters.AddWithValue("@bldg_desc", bldgdesc)

        conInventory.Open()

        cmdStoredProc.ExecuteNonQuery()

        conInventory.Close()

        BindBldg(bldgdesc)
    End Sub 'AddNewRecord

[Phil Weber]

Try setting cmdStoredProc's .CommandType property to CommandType.StoredProcedure.

[asubash]

Yaa try to put

cmdStoredProc.CommandType = CommandType.StoredProcedure
cmdStoredProc.CommandText = "usp_bldgs_c"
cmdStoredProc.Parameters.Add(New SqlParameter("@bldg_desc", bldgdesc))

try to do like this....

[geo039]

I did this and it worked wonderfully, however now I am doing the UpdateRecord and it's saying the same thing

Private Sub UpdateRecord(ByVal bldgid As Integer, ByVal bldgdesc As String)

        Dim conString As String = Utilities.GetConnectionString("AssetInventory")
        Dim conInventory As SqlConnection = New SqlConnection(conString)
        Dim cmdStoredProc As SqlCommand

        cmdStoredProc = New SqlCommand("usp_bldgs_u", conInventory)
        cmdStoredProc.CommandType = CommandType.StoredProcedure
        cmdStoredProc.Parameters.AddWithValue("@bldg_id", bldgid)
        cmdStoredProc.Parameters.AddWithValue("@bldg_desc", bldgdesc)

        conInventory.Open()

        cmdStoredProc.ExecuteNonQuery()

        conInventory.Close()

        BindBldg()

[asubash]

Private Sub UpdateRecord(ByVal bldgid As Integer, ByVal bldgdesc As String)

       Dim conString As String = Utilities.GetConnectionString("AssetInventory")
        Dim conInventory As SqlConnection = New SqlConnection(conString)
        Dim cmdStoredProc As new SqlCommand

        cmdStoredProc.CommandType = CommandType.StoredProcedure
        cmdStoredProc.CommandText = "usp_bldgs_c"
        cmdStoredProc.Parameters.AddWithValue("@bldg_id", bldgid)
        cmdStoredProc.Parameters.AddWithValue("@bldg_desc", bldgdesc)

        conInventory.Open()

        cmdStoredProc.ExecuteNonQuery()

        conInventory.Close()

        BindBldg()

try like this..may the order was wrong...
u declared this
cmdStoredProc.CommandType = CommandType.StoredProcedure

after the passing the name of the SP.