473,765 Members | 1,955 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Disconnected Recordset??



Hi - I have a recordset generated from a search between two dates - if
the user wishes to 'update' some of the records to show their interest
in some of the dates, is there a way I can just update the recordset,
and write it back to the database (used to use rs.Edit, rs.Update etc in
old ASP) - or do I still need to run an update query for the records I
want to update?

Thanks for any pointers,

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 21 '05 #1
1 1859
Mark:

Are you using an ADO recordset or are you using a DataSet? If a dataset,
the rowstate of any rows modified/inserted/deleted will be marked as such
and you can just pass an update with those rows.

However, if you call dataadapter.upd ate on a dataset that doesn't have
changes !DataSet.HasCha nges;
then it won't submit anything back tot he db
"Mark" <an*******@devd ex.com> wrote in message
news:uo******** ******@TK2MSFTN GP10.phx.gbl...


Hi - I have a recordset generated from a search between two dates - if
the user wishes to 'update' some of the records to show their interest
in some of the dates, is there a way I can just update the recordset,
and write it back to the database (used to use rs.Edit, rs.Update etc in
old ASP) - or do I still need to run an update query for the records I
want to update?

Thanks for any pointers,

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 21 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
2319
by: jason | last post by:
Is there a way - possibly a disconnected rs? - to update the contents of an existing pulldown on a page without having to re-submit the page for the user to see the pulldown populated with an additional value? I realise there are javascript possibilities (and I am still searching for a usable one) but I thought perhaps it may be possible to allow a user to add a new entry to a drop down box that had been dynamically populated from an...
0
2878
by: elcc1958 | last post by:
I need to support a VB6 application that will be receiving disconnected ADODB.Recordset from out DotNet solution. Our dotnet solution deals with System.Data.DataTable. I need to populate a disconnected ADODB.Recordset from System.Data.DataTable data. Below is the source code I am implementing to test the process. I do not get any error, that I can see. The problem I have is that at the end, the recordset seems to be empty. Any...
6
2948
by: Steve Jorgensen | last post by:
I keep having problems in which ADO disconnected recordset work under some circumstances, but lose all their data at other times, having no rows or fields, though the recordset object still exists. One case where this happened to me today was in trying to store disconnected recordsets in a cache collection in case they are needed again later in the same session. When I retrieve the recordset from the collection, it's empty. On the other...
2
4640
by: PeteCresswell | last post by:
I've got a routine that loads a tree control. Works a-ok the first time around, then bombs the second. Works the third, bombs on the fourth....i.e. it works every other time it is invoked. Error# always the same: -2214 741 7848, but the message varies between "Method 'Add' of object INodes failed." and "The object invoked has disconnected from it's clients." The first one is more common.
3
2543
by: AC | last post by:
Running VS.NET 2003 Enterprise Arch on WinXP Pro SP1 with a P4-2.4Ghz, 760MB+ RAM, and 10+GB free disk space. Laptop is part of a domain. When working on a web project connected at the office, VS.NET enters into debug mode (compiling, firing off a browser, and starting the debugger) just fine. However, when the machine is disconnected, or I'm working off a wireless network @ home (WiFi) or working off a wired connection @ home (all...
2
2878
by: Eric Peterson | last post by:
I use the shape object to make recordsets that have no db connection for use in grids and such. For example (mPhoneNumbersRS as ADODB.Recordset) **************************************** mPhoneNumbersRS.let_ActiveConnection ("Provider=MSDataShape;Data Provider=none;Data Source=localhost;") sTmp = "SHAPE APPEND NEW adChar(20) as Type, NEW advarChar
1
315
by: Mark | last post by:
Hi - I have a recordset generated from a search between two dates - if the user wishes to 'update' some of the records to show their interest in some of the dates, is there a way I can just update the recordset, and write it back to the database (used to use rs.Edit, rs.Update etc in old ASP) - or do I still need to run an update query for the records I want to update? Thanks for any pointers, *** Sent via Developersdex...
2
2681
by: =?Utf-8?B?ZGdjb29wZXI=?= | last post by:
When I get a list of drives using the Directory.GetLogicalDrives(), it gives me all drives including disconnected network drives. When I attempt to use Directory.GetDirectories() on a disconnected drive, the GetDirectories Method stops responding. I also tried to use properties such as DirectoryInfo.Attributes but I have the same problem. How do I detect if one of the logical drives in my list is a disconnected network drive? I want to...
1
2251
by: Arpan | last post by:
Recently in an interview (for the post of ASP programmer), I was asked "How do you define disconnected recordset in ASP". I was stumped & couldn't answer. What's the answer to the question? Is it GetRows()? Thanks, Regards, AD
0
9568
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10160
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10007
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
7378
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5275
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5421
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3924
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3531
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2805
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.