SqlException: Invalid Column Name

Hello,


I have a problem with my Update sql server command. The error message is strange :


System.Data.SqlClient.SqlException: Invalid column name 'CMD_DATE_ORDER'. Invalid column name 'CMD_REF_CLIENT'. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior,


RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ASP.addorder_aspx.MasterGrid_Update(Object Sender, DataGridCommandEventArgs E)


in C:Inetpubwwwrootproject1addorder.aspx:line 157


On line 157 I have :


UpdateCommand.ExecuteNonQuery()





The Update code :


Sub MasterGrid_Update(Sender As Object, E As DataGridCommandEventArgs)


' update the database with the new values


' get the edit text boxes


Dim dateCom As String = CType(e.Item.FindControl("dateCom"), TextBox).Text


Dim NumBon As String = CType(e.Item.FindControl("NumBon"), TextBox).Text


Dim NomDest As String = CType(e.Item.FindControl("NomDest"), TextBox).Text


Dim NovoieDest As String = CType(e.Item.FindControl("NovoieDest"), TextBox).Text


Dim nomvoieDest As String = CType(e.Item.FindControl("nomvoieDest"), TextBox).Text


Dim cpDest As String = CType(e.Item.FindControl("cpDest"), TextBox).Text


Dim villeDest As String = CType(e.Item.FindControl("villeDest"), TextBox).Text


Dim paysDest As String = CType(e.Item.FindControl("paysDest"), TextBox).Text


Dim telDest As String = CType(e.Item.FindControl("telDest"), TextBox).Text


Dim dateExp As String = CType(e.Item.FindControl("dateExp"), TextBox).Text





Dim myConnection As New SqlConnection(strConnect)


Dim UpdateCommand As SqlCommand = new SqlCommand()


UpdateCommand.Connection = myConnection


' Add to CLIID_LGN the selected value in the DropDownList


Dim cliid As String


cliid = Trim(DDL.SelectedItem.Value)





If AddingNew = True Then


UpdateCommand.CommandText = "INSERT INTO Commandes (CMD_DATE_ORDER, CMD_NUM_BON_ORDER, CMD_NOM_DEST, CMD_NOVOIE_DEST, CMD_NOMVOIE_DEST, CMD_CP_DEST, CMD_VILLE_DEST, CMD_PAYS_DEST, CMD_TEL_DEST,


CMD_DATE_EXPED, CMD_REF_CLIENT) VALUES ('" & dateCom & "','" & NumBon & "','" & NomDest & "','" & NovoieDest & "','" & nomvoieDest & "','" & cpDest & "','" & villeDest & "','" & paysDest & "','" & telDest & "',


'" & dateExp & "', '" & cliid & "')"


Else


UpdateCommand.CommandText = "UPDATE Client SET CMD_DATE_ORDER=@dateCom, CMD_NUM_BON_ORDER = @NumBon, CMD_NOM_DEST = @NomDest, CMD_NOVOIE_DEST = @NovoieDest, CMD_NOMVOIE_DEST = @NomvoieDest,


CMD_CP_DEST = @cpDest, CMD_VILLE_DEST = @villeDest, CMD_PAYS_DEST = @paysDest, CMD_TEL_DEST = @telDest, CMD_DATE_EXPED = @dateExp WHERE CMD_REF_CLIENT = '" & cliid & "'"


End If





UpdateCommand.Parameters.Add("@dateCom", SqldbType.SmallDateTime, 4).Value = Trim(dateCom)


UpdateCommand.Parameters.Add("@NumBon", SqldbType.NVarChar, 10).Value = Trim(NumBon)


UpdateCommand.Parameters.Add("@NomDest", SqldbType.NVarChar, 50).Value = Trim(NomDest)


UpdateCommand.Parameters.Add("@NovoieDest", SqldbType.NVarChar, 5).Value = Trim(NovoieDest)


UpdateCommand.Parameters.Add("@nomvoieDest", SqldbType.NVarChar, 80).Value = Trim(nomvoieDest)


UpdateCommand.Parameters.Add("@cpDest", SqldbType.NVarChar, 5).Value = Trim(cpDest)


UpdateCommand.Parameters.Add("@villeDest", SqldbType.NVarChar, 35).Value = Trim(villeDest)


UpdateCommand.Parameters.Add("@paysDest", SqldbType.NVarChar, 35).Value = Trim(paysDest)


UpdateCommand.Parameters.Add("@telDest", SqldbType.NVarChar, 14).Value = Trim(telDest)


UpdateCommand.Parameters.Add("@dateExp", SqldbType.SmallDateTime, 4).Value = Trim(dateExp)





' execute the command


Try


myConnection.Open()


UpdateCommand.ExecuteNonQuery()





Catch ex as Exception


Message.Text = ex.ToString()





Finally


myConnection.Close()





End Try





' Resort the grid for new records


If AddingNew = True Then


MasterGrid.CurrentPageIndex = 0


AddingNew = false


End If





' rebind the grid


MasterGrid.EditItemIndex = -1


BindMasterGrid()


End Sub


I have send a response.write instruction : the values are all good.


In the sql server database, the syntax of this 2 fields CMD_DATE_ORDER and CMD_REF_CLIENT are good.





Can you help me for this problem ?


Thanks.