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 2008 access add advanced application array assignment basic beginner box browser button buttons center click client code combo convert cpu cuesent data database datagrid datagridview datetimepicker designer dissertation dissertations dissertationtopic eclipse editvb.net employees excel exists filter forms function html images isnumericfuntioncall listview map mobile module msaccess mssqlbackend mysql net number open page pan panel pdf picturebox picturebox2 port position print printing printpreview read record regex reuse right-to-left save search serial settings socket sorting sqldatbase sqlserver storedprocedure temp textbox timer timespan transparency txttoxmlconverter usercontol vb vb.net vba vbnet vista visual visualbasic visualbasic.net visualstudio.net web winsock wpf wrapingcode xml year
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC