VB.NET RSS VB.NET RSS

Dataset.table.AcceptChanges not working??

Please support our VB.NET advertiser: Intel Parallel Studio Home
Reply

•
•
Join Date: Jun 2008
Posts: 2
Reputation: herbally is an unknown quantity at this point 
Solved Threads: 0
herbally herbally is offline Offline
Newbie Poster

Dataset.table.AcceptChanges not working??

 
0
  #1
Jun 10th, 2008
I'm trying to add a row to my dataset using the following:
VB.NET Syntax (Toggle Plain Text) 
  1.  Dim foundRow As DataRow = DsMembers.Members.NewRow
  2.         foundRow("FirstName") = scannedMember.FirstName
  3.         foundRow("MiddleName") = scannedMember.MiddleName
  4.         foundRow("LastName") = scannedMember.LastName
  5.         foundRow("Address") = scannedMember.Address
  6.         foundRow("City") = scannedMember.City
  7.         foundRow("State") = scannedMember.State
  8.         foundRow("Zip") = scannedMember.Zip
  9.         foundRow("DOB") = scannedMember.DOB
  10.         foundRow("TDL") = scannedMember.TDL
  11.         foundRow("MemberID") = scannedMember.MemberID
  12.         foundRow("DateJoined") = scannedMember.DateJoined
  13.         foundRow("DateExpired") = scannedMember.DateExpired
  14.         If scannedMember.Barred <> Nothing Then
  15.             foundRow("Barred") = scannedMember.Barred
  16.             If scannedMember.Barred = "Y" Then
  17.                 foundRow("BarredReason") = scannedMember.BarredReason
  18.             End If
  19.         Else
  20.             foundRow("Barred") = "N"
  21.             foundRow("BarredReason") = " "
  22.         End If
  23.         DsMembers.Members.Rows.Add(foundRow) '.AddMembersRow(foundRow)
  24.         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) 
  1. DsMembers.Members.FindByTDL(scannedMember.TDL)
after calling AcceptChanges it doesn't find anything. Any ideas? Thanks!
Reply With Quote Quick reply to this message  
•
•
Join Date: Jun 2007
Posts: 22
Reputation: dadelsen is an unknown quantity at this point 
Solved Threads: 5
dadelsen dadelsen is offline Offline
Newbie Poster

Re: Dataset.table.AcceptChanges not working??

 
0
  #2
Jun 11th, 2008
Did you check rows.count before and after adding the row?
VB.NET Syntax (Toggle Plain Text) 
  1. 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) 
  1. Dim rowFound As DataRow = DsMembers.Members.FindByTDL(scannedMember.TDL)
Last edited by dadelsen; Jun 11th, 2008 at 4:27 am.
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Other Threads in the VB.NET Forum
Thread Tools Search this Thread



.net .net2008 2005 2008 access account array basic beginner bing browser button buttons center check checkbox client code convert crystalreport cuesent data database datagrid datagridview date datetimepicker designer dissertation dissertations dissertationtopic dropdownlist eclipse excel fade filter forms ftp generatetags gridview html images inline input insert intel internet listview mobile monitor net objects open panel passingparameters pdf picturebox port position print printing problem read remove save searchbox searchvb.net select serial settings shutdown soap sqlserver survey table tcp temperature textbox timer timespan transparency trim update user vb vb.net vb.netformclosing()eventpictureboxmessagebox vb2008 vba vbnet visual visualbasic visualbasic.net visualstudio.net visualstudio2008 web winforms wpf wrapingcode year
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC