i am trying to create a form that lets me add new entries into a database when i click a button. "reference to a non-shared member requires an object reference" is the error that occurs at karateDataSet.Tables("Payments") on line 17 and 22 in the code. any help would be appreciated, thanks.
Code:Public Class AddNewPayments Private Sub btnShow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnShow.Click Payments.Show() End Sub Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click Dim newAccount As Integer Dim newMember As Integer Dim payDate As Date Try newAccount = CInt(txtAccount.Text) newMember = CInt(txtMember.Text) payDate = DateTimePicker1.Value.Date Dim newPaymentsRow As DataRow = karateDataSet.Tables("Payments").NewRow() newPaymentsRow("Account") = newAccount newPaymentsRow("Member_ID") = newMember newPaymentsRow("Payment_Date") = payDate karateDataSet.Tables("Payments").Rows.Add(newPaymentsRow) Catch ex As Exception MessageBox.Show("Only numeric values can be added") End Try End Sub End Class


Reply With Quote
Bookmarks