[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Check Criteria Before Update

Posted on 2004-11-10
5
Medium Priority
?
204 Views
Last Modified: 2010-08-05
I have a master detail form, the header has a text box with a sales order number and a department, the detail section has a datagrid with a list of departments, when the user enters a sales order number I first need to check if it exists, if not add a new record, if it does check to see if the department exist, if it does then add a date into the detail if not add the department the date

I have got it working filtering a dataview and refilling the dataset however this is much to slow, any other suggestions will be greatly appreciated

Thanks
0
Comment
Question by:davidrichardson
  • 3
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
iboutchkine earned 375 total points
ID: 12549103
I would close the dataset before update to a differrnt one, then check Changed rows in updated dataset and do all the valaidation on the cloned dataset. After that update the table using dataadapter
0
 
LVL 7

Author Comment

by:davidrichardson
ID: 12549510
Could you give me a bit more detail

Thanks
0
 
LVL 28

Expert Comment

by:iboutchkine
ID: 12773900
What kind of details do you want
0
 
LVL 7

Author Comment

by:davidrichardson
ID: 12774327
I have sorted, Your post pointed me in right direction
Thanks
David
0
 
LVL 28

Expert Comment

by:iboutchkine
ID: 12774349
You are welcome
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Loops Section Overview
Suggested Courses

831 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