Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Update Dataset and Database

Posted on 2007-03-29
8
Medium Priority
?
167 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

715 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