Incorrect syntax near...

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!

Code:

---

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

---

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

Yaa try to put

Code:

---


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

---

try to do like this....

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

Code:

---

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()

---

Code:

---

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.