Dataset.table.AcceptChanges not working??

Expand Post »

I'm trying to add a row to my dataset using the following:

VB.NET Syntax (Toggle Plain Text)
 Dim foundRow As DataRow = DsMembers.Members.NewRow
        foundRow("FirstName") = scannedMember.FirstName
        foundRow("MiddleName") = scannedMember.MiddleName
        foundRow("LastName") = scannedMember.LastName
        foundRow("Address") = scannedMember.Address
        foundRow("City") = scannedMember.City
        foundRow("State") = scannedMember.State
        foundRow("Zip") = scannedMember.Zip
        foundRow("DOB") = scannedMember.DOB
        foundRow("TDL") = scannedMember.TDL
        foundRow("MemberID") = scannedMember.MemberID
        foundRow("DateJoined") = scannedMember.DateJoined
        foundRow("DateExpired") = scannedMember.DateExpired
        If scannedMember.Barred <> Nothing Then
            foundRow("Barred") = scannedMember.Barred
            If scannedMember.Barred = "Y" Then
                foundRow("BarredReason") = scannedMember.BarredReason
            End If
        Else
            foundRow("Barred") = "N"
            foundRow("BarredReason") = " "
        End If
        DsMembers.Members.Rows.Add(foundRow) '.AddMembersRow(foundRow)
        DsMembers.Members.AcceptChanges()
 Dim foundRow As DataRow = DsMembers.Members.NewRow
        foundRow("FirstName") = scannedMember.FirstName
        foundRow("MiddleName") = scannedMember.MiddleName
        foundRow("LastName") = scannedMember.LastName
        foundRow("Address") = scannedMember.Address
        foundRow("City") = scannedMember.City
        foundRow("State") = scannedMember.State
        foundRow("Zip") = scannedMember.Zip
        foundRow("DOB") = scannedMember.DOB
        foundRow("TDL") = scannedMember.TDL
        foundRow("MemberID") = scannedMember.MemberID
        foundRow("DateJoined") = scannedMember.DateJoined
        foundRow("DateExpired") = scannedMember.DateExpired
        If scannedMember.Barred <> Nothing Then
            foundRow("Barred") = scannedMember.Barred
            If scannedMember.Barred = "Y" Then
                foundRow("BarredReason") = scannedMember.BarredReason
            End If
        Else
            foundRow("Barred") = "N"
            foundRow("BarredReason") = " "
        End If
        DsMembers.Members.Rows.Add(foundRow) '.AddMembersRow(foundRow)
        DsMembers.Members.AcceptChanges()

For some reason, even though the rowState says "Added", the row is never added to the dataset. If I run

VB.NET Syntax (Toggle Plain Text)
DsMembers.Members.FindByTDL(scannedMember.TDL)
DsMembers.Members.FindByTDL(scannedMember.TDL)

after calling AcceptChanges it doesn't find anything. Any ideas? Thanks!

herbally

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jun 2008

Permalink

Jun 11th, 2008

Re: Dataset.table.AcceptChanges not working??

Did you check rows.count before and after adding the row?

VB.NET Syntax (Toggle Plain Text)
console.Writeline( "Rows.Count {0}", DsMembers.Members.Rows.Count )
console.Writeline( "Rows.Count {0}", DsMembers.Members.Rows.Count )

Do you assign the result of the find to a datarow?

VB.NET Syntax (Toggle Plain Text)
Dim rowFound As DataRow = DsMembers.Members.FindByTDL(scannedMember.TDL)
Dim rowFound As DataRow = DsMembers.Members.FindByTDL(scannedMember.TDL)

Last edited by dadelsen; Jun 11th, 2008 at 4:27 am.

dadelsen

Reputation Points: 25

Solved Threads: 5

Newbie Poster

Offline

22 posts
since Jun 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Datagrid

Next Thread in VB.NET Forum Timeline: Retrieving data from the parent category using a combo box

DaniWeb Message

Cancel Changes

User Name
Password