Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column

Asked Jul 01 '15 at 16:30

Active Jul 01 '15 at 16:30

Viewed 148 times

I have set PK for all Admin tables. They were working fine in the website. It's still working in the VM, when I debug the application using F5.

But the same code when deployed to IIS website, throwing this error all of the sudden. I didn't change any code specific to this issue.

Thanks, Jay

asked Jul 01 '15 at 16:30

Jay

Code - GridView1_RowUpdating: CmdCommon.Connection = CnCommon CmdCommon.CommandType = CommandType.StoredProcedure CmdCommon.CommandText = "GetParameters" Da = NewSqlDataAdapter(CmdCommon) Da.Fill(Ds) Dim myBuilder As SqlCommandBuilder= NewSqlCommandBuilder(Da) myBuilder.GetUpdateCommand() Da.UpdateCommand = myBuilder.GetUpdateCommand() Ds.Tables(0).Rows(e.RowIndex).Item("ParamValue") = TxtParamValue.Text Da.Update(Ds) Ds.AcceptChanges() – Jay Jul 01 '15 at 17:20
Code - Populate Grid: CmdCommon.Connection = CnCommon CmdCommon.CommandType = CommandType.StoredProcedure CmdCommon.CommandText = "GetParameters" Da = New SqlDataAdapter(CmdCommon) Da.Fill(Ds) GridView1.DataSource = Ds GridView1.DataBind() – Jay Jul 01 '15 at 17:27

0 Answers0