Hello All,
I am trying to update two fields based on where chart = @chart. Update executed successfully but nothing happens. Where or at what point does it ask for @chart value. I even tried to create another update function but the program just removes it by itself. I am confused...please help.
thanks
btran
Me._adapter.UpdateCommand.CommandText = "UPDATE Chart SET Release = 1, ReleaseDate = Now() WHERE Chart = @chart)
---------
Me.ChartTableAdapter.Update(Me.DataSet1.Chart)
----------
<System.Diagnostics.DebuggerNonUserCodeAttribute(), System.ComponentModel.Design.HelpKeywordAttribute "vs.data.TableAdapter")>
Public Overloads Overridable Function Update(ByVal chart As String) As Integer
me.Adapter.UpdateCommand.Parameters(0).Value = chart
return me.Adapter.UpdateCommand.ExecuteNonQuery()
End Function
I am trying to update two fields based on where chart = @chart. Update executed successfully but nothing happens. Where or at what point does it ask for @chart value. I even tried to create another update function but the program just removes it by itself. I am confused...please help.
thanks
btran
Me._adapter.UpdateCommand.CommandText = "UPDATE Chart SET Release = 1, ReleaseDate = Now() WHERE Chart = @chart)
---------
Me.ChartTableAdapter.Update(Me.DataSet1.Chart)
----------
<System.Diagnostics.DebuggerNonUserCodeAttribute(), System.ComponentModel.Design.HelpKeywordAttribute "vs.data.TableAdapter")>
Public Overloads Overridable Function Update(ByVal chart As String) As Integer
me.Adapter.UpdateCommand.Parameters(0).Value = chart
return me.Adapter.UpdateCommand.ExecuteNonQuery()
End Function