Error: Update requires a valid InsertCommand ...

spiffyaldo2 · March 26th, 2006, 03:02 AM

I get this error message when I am trying to update multiple fields in my database:

Update requires a valid InsertCommand when passed DataRow collection with new rows.

This is my code:

Code:

' Finding the row i want to alter
For i = 0 To ds.Tables("table1").Rows.Count - 1
                    If ds.Tables("table1").Rows(i)(22).ToString = Request.QueryString("ID").ToString Then
                        For ii = 0 To 5
                            ds.Tables("table1").Rows(i)(ii) = "change"
                        Next
                    End If
                Next
                sqlCmd.UpdateCommand = New SqlCommand()
                sqlCmd.UpdateCommand.CommandText = "Update " & Session("table").ToString & " Set Date='" & dateMM.SelectedItem.Text & "/" & dateDD.SelectedItem.Text & "/" & dateYY.SelectedItem.Text & "',[Course Name]='" & CourseName.Text & "',Hole1='" & scoreinfo(0) & "',Hole2='" & scoreinfo(1) & "',Hole3='" & scoreinfo(2) & "',Hole4='" & scoreinfo(3) & " Where RoundID=" & Request.QueryString("ID").ToString
                sqlCmd.UpdateCommand.Connection = SqlConn
                sqlCmd.Update(ds, "table1")

Thanks In Advance,
Aldo

spiffyaldo2 · March 26th, 2006, 04:21 PM

So does anybody have a clue??

jbenson001 · March 26th, 2006, 07:20 PM

cross post
http://p2p.wrox.com/topic.asp?TOPIC_ID=41987

spiffyaldo2 · March 27th, 2006, 02:24 AM

so you would be more willing to tell on me for cross posting, but wont help me? WHY?!?