Solved

Update Dataset and Database

Posted on 2007-03-29
8
162 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to remove double quotes from a string in VB.Net 5 47
Help with AsEnumerable(), LINQ 4 39
Gridview selected row 9 44
Need a starter for ETL protocol? 4 55
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…
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…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

808 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