Have you added the stored procedure to the database?
What does my.Resources.DatabaseCreationScripts.spInsertModels contain?
(E-Mail Removed) wrote:
> I am trying to call a Stored Prodecure in my code, and I keep getting
> the same error...
>
> system.data.sqlclient.sqlexception: incorrect syntax near the keyword
> 'Procedure'
>
>
> I have added my stored procedure as a .sql file and have verified that
> it is written correctly in SQL Sever 2005. Below is that stored
> procedure...
>
> CREATE PROCEDURE spInsertModels
> @ModelName nvarchar(50),
> @Photo image,
> @PhotoPath nvarchar(255),
> @Active bit
> AS
> INSERT INTO "dbo"."Models" (ModelName, Photo, PhotoPath, Active)
> VALUES (@ModelName, @Photo, @PhotoPath, @Active)
>
>
> The next couple of methods are written in VB.NET 2005 and are shown
> below...
>
> 'This is the first method called
> Private Sub UpdateOrInsertModelsInDB(ByVal changedData As DataTable)
> Try
> Dim oRow As DataRow
> Dim smallIntActive As Int16
>
> For Each oRow In changedData.Rows
> smallIntActive = oRow("Active")
> If smallIntActive = vbYes Then
> smallIntActive = -1
> End If
>
>
> Dim cmdCommand As New SqlCommand
> If oRow.RowState = DataRowState.Added Then
> 'THIS IS WHAT IS CALLED....
> AddModelInsertUpdateParameters(cmdCommand, oRow,
> smallIntActive, False)
> ExecuteInsertSPWithParams(cmdCommand)
> Else
> AddModelInsertUpdateParameters(cmdCommand, oRow,
> smallIntActive, True)
> ExecuteUpdateSPWithParams(cmdCommand)
> End If
> Next
> Catch ex As Exception
> MessageBox.Show(ex.ToString)
> End Try
> End Sub
>
>
> Private Sub AddModelInsertUpdateParameters(ByRef cmdCommand As
> SqlCommand, ByVal orow As DataRow, ByVal smallIntActive As Int16, ByVal
> update As Boolean)
> Try
> Dim sqlParam As New SqlParameter
>
> If update Then
> sqlParam = cmdCommand.Parameters.Add("@ModelID",
> SqlDbType.Int)
> sqlParam.Value = orow("ModelID")
> End If
>
> sqlParam = cmdCommand.Parameters.Add("@ModelName",
> SqlDbType.NVarChar, 50)
> sqlParam.Value = orow("ModelName")
>
> sqlParam = cmdCommand.Parameters.Add("@Photo",
> SqlDbType.Image)
> sqlParam.Value = orow("Photo")
>
> sqlParam = cmdCommand.Parameters.Add("@PhotoPath",
> SqlDbType.NVarChar, 255)
> sqlParam.Value = orow("PhotoPath")
>
> sqlParam = cmdCommand.Parameters.Add("@Active",
> SqlDbType.Bit)
> sqlParam.Value = smallIntActive
> Catch ex As Exception
> MessageBox.Show(ex.ToString)
> End Try
> End Sub
>
>
> Private Sub ExecuteInsertSPWithParams(ByVal cmdCommand As
> SqlCommand)
> Try
> Using conn As New SqlConnection(dbClass.connectionString)
> conn.Open()
>
> cmdCommand.Connection = conn
> cmdCommand.CommandText =
> my.Resources.DatabaseCreationScripts.spInsertModels
> cmdCommand.ExecuteNonQuery()
>
> conn.Close()
> End Using
> Catch ex As Exception
> MessageBox.Show(ex.ToString)
> End Try
> End Sub
>
>
> Any Ideas on why I am getting this error?
>
Similar Threads
