Save all records DATA Grid view by typing in it

  • Thread starter Thread starter rexson98
  • Start date Start date
R

rexson98

Guest
Hi, can somebody help me about Save all records DATA Grid view by typing in it. Im using vb 2010..



for example i have a grid and i type the records there after going to the next row it will be saved to the database.. Im using MSSQL 2008 for the DB. I tried this one

Private Sub frmsetting_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Me.UtOTratesTableAdapter.Fill(Me._88PayrollDataSet.utOTrates)

End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Me.UtOTratesTableAdapter.Update(Me._88PayrollDataSet.utOTrates)
End Sub


but I received this error:Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

Continue reading...
 
Back
Top