Solved

Update Dataset and Database

Posted on 2007-03-29
8
161 Views
Last Modified: 2010-04-23
I'm  trying to update a dataset and its not working.  
The form has 4 different 'modes' that it opens in for different formatting reasons.  When the user loads the form in Edit Mode, the form loads and I open the connection and fill the data adapter then use the FindBy function to locate the record the user wants (code below):

Me.Con_DWS.Open()
      Da_Main.Fill(Ds_DWSMain1.DWS_Main)
Me.Con_DWS.Close()

Dim drDWS_Main as ds_DWSMain.DWS_MainRow
drDWS_Main = Ds_DWSMain1.DWS_Main.FindBySlip_no(me.txtSlip_no.text)

txtJob_num.text = drDWS_Main.job_no
txtSWO_num.text = drDWS_Main.swo_no
txtDate.text = drDWS_Main.job_date
txtLocation = drDWS_Main.job_site
txtContractor.text = drDWS_Main.contractor
txtdescription.text = drDWS_Main.job_desc

At this point I have the information in the textboxes based on what the user has entered in txtSlip_no.text.

The user can then edit some of the fields.  The user will then save the data and I run the following code:

Public Sub btnSave.....
Con_DWS.Open()
Dim drDWS_Main as ds_DWSMain.DWS_MainRow
drDWS_Main.job_no = txtJob_num.text
drDWS_Main.swo_no = txtSWO_num.text
drDWS_Main.job_date = txtDate.text
drDWS_Main.job_site = txtLocation
drDWS_Main.contractor = txtContractor.text
drDWS_Main.job_desc = txtdescription.text

Da_Main.Update(ds_DWSMain1.DWS_Main)
Con_DWS.Close()

Yet, the update doesn't happen.  
0
Comment
Question by:tobin46
  • 3
  • 2
8 Comments
 
LVL 7

Expert Comment

by:dctuck
ID: 18818730
I assume that ds_DWSMain is a DataSet, in which case, after the Da_Main.Update call, you need to have:

ds_DWSMain.AcceptChanges()
0
 
LVL 1

Author Comment

by:tobin46
ID: 18819004
Tried that it didn't work.  
0
 
LVL 7

Expert Comment

by:dctuck
ID: 18821990
You shouldn't actually need to open your connections for datasets and dataadapters, as it should do that for you automatically. Not sure if that makes any difference, though
0
 
LVL 1

Author Comment

by:tobin46
ID: 18833017
I think you are right.  The textboxes aren't bound to the dataset though.  If they were bound to the dataset, it would automatically update if there are changes.  

0
 
LVL 7

Accepted Solution

by:
dctuck earned 500 total points
ID: 18833055
Just realised - you haven't actually added the row to the dataset.

ds_DWSMain.DWS_Main.AddDWS_MainRow(drDWS_Main)

before Update / AcceptChanges commands
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now