Can anyone help with a update statment.

I am having trouble getting this insert statment to work is there a way to just insert all ?

this is in vb.net 2010 using a database from sql server 2008 R2
Would love to get this working 100% as its the second to last piece to the program


Public Class Member

Private Sub MemberBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MemberBindingNavigatorSaveItem.Click
Me.Validate()
Me.MemberBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.TrusteeRentalsDataSet)

End Sub

Private Sub Member_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'TrusteeRentalsDataSet.Member' table. You can move, or remove it, as needed.
Me.MemberTableAdapter.Fill(Me.TrusteeRentalsDataSet.Member)

End Sub

Private Sub btnBack_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBack.Click
Me.MemberBindingSource.MovePrevious() 'moves to the previous record in the table
End Sub

Private Sub btnNext_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNext.Click
Me.MemberBindingSource.MoveNext() 'moves to the next record in the table
End Sub

Private Sub btnLast_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLast.Click
Me.MemberBindingSource.MoveFirst() 'displays the first entry in the table
End Sub

Private Sub btnFirst_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFirst.Click
Me.MemberBindingSource.MoveLast() 'displays the last entry in the table
End Sub

Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
Me.Validate()
Me.MemberBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.TrusteeRentalsDataSet)

End Sub


Private Sub btnInsert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnInsert.Click
' Me.MemberTableAdapter.Insert(Member_NumberTextBox.Text, Member_Last_NameTextBox.Text, Member_First_NameTextBox.Text, Member_StreetTextBox.Text, Member_SuburbTextBox.Text, Member_CityTextBox.Text, Member_PhoneTextBox.Text, , Member_PasswordTextBox.Text)

End Sub

Private Sub btnReset_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnReset.Click
Member_NumberTextBox.Text = ""
Member_Last_NameTextBox.Text = ""
Member_First_NameTextBox.Text = ""
Member_StreetTextBox.Text = ""
Member_SuburbTextBox.Text = ""
Member_CityTextBox.Text = ""
Member_PhoneTextBox.Text = ""
Member_Date_JoinedDateTimePicker.Value = Today
Member_PasswordTextBox.Text = ""

End Sub
End Class
Edited by ipv89 - 11/7/12 at 9:03pm