Am I just totally missing something here? I'm just new to VS.NET 2005
(using VB.NET) and ADO.NET.
I get the impression that ADO.NET can't do what I'm used to doing with ADO
(previous ADO withVB6).
I used to bind (let's say a text box) to a field (column) in a recordset and
if I typed a value in that textbox and tabbed out of it, the value in the
database got updated without me having to do anything else.
Now what I see is a terribly convoluted mish-mash of connections, adapters,
datasets that have to be "filled" etc and then there's the data bindings to
get it so you can just "see" what is in your database (excuse me, data
"source") and then after all of that it doesn't even keep up to date (if
something in the underlying database changes) much less update the database
after all. I have to write the code to do that too!!!!
Keep in mind the very first sentence... Am I missing something here?? OMG I
hope I am.
6  1002 
ADO.NET is disconnect by nature as opposed to ADO, which usually worked with
the actual data in the database. So, in ADO.NET you work with a copy of the
data, and when you are ready, you update the original data source with your
copy's changes.
This architecture reduces server load and generally improves the
application's response time (if you are smart about how and when you connect
to the data source).
"Sam Malone" <th************ @hotmail.com> wrote in message
news:%2******** ********@TK2MSF TNGP03.phx.gbl. .. Am I just totally missing something here? I'm just new to VS.NET 2005
(using VB.NET) and ADO.NET.
I get the impression that ADO.NET can't do what I'm used to doing with ADO
(previous ADO withVB6).
I used to bind (let's say a text box) to a field (column) in a recordset
and if I typed a value in that textbox and tabbed out of it, the value in
the database got updated without me having to do anything else.
Now what I see is a terribly convoluted mish-mash of connections,
adapters, datasets that have to be "filled" etc and then there's the data
bindings to get it so you can just "see" what is in your database (excuse
me, data "source") and then after all of that it doesn't even keep up to
date (if something in the underlying database changes) much less update
the database after all. I have to write the code to do that too!!!!
Keep in mind the very first sentence... Am I missing something here?? OMG
I hope I am.
Cripes. Seems like a MAJOR step backwards to me. People cost way more than
CPU cycles. Oh well, I'm sure my whining won't change M$ attitude. At least
it does show I wasn't as confused as I thought (hoped) I was :-(
"Scott M." <s-***@nospam.nosp am> wrote in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. .. ADO.NET is disconnect by nature as opposed to ADO, which usually worked
with the actual data in the database. So, in ADO.NET you work with a copy
of the data, and when you are ready, you update the original data source
with your copy's changes.
This architecture reduces server load and generally improves the
application's response time (if you are smart about how and when you
connect to the data source).
"Sam Malone" <th************ @hotmail.com> wrote in message
news:%2******** ********@TK2MSF TNGP03.phx.gbl. .. Am I just totally missing something here? I'm just new to VS.NET 2005
(using VB.NET) and ADO.NET.
I get the impression that ADO.NET can't do what I'm used to doing with
ADO (previous ADO withVB6).
I used to bind (let's say a text box) to a field (column) in a recordset
and if I typed a value in that textbox and tabbed out of it, the value in
the database got updated without me having to do anything else.
Now what I see is a terribly convoluted mish-mash of connections,
adapters, datasets that have to be "filled" etc and then there's the data
bindings to get it so you can just "see" what is in your database (excuse
me, data "source") and then after all of that it doesn't even keep up to
date (if something in the underlying database changes) much less update
the database after all. I have to write the code to do that too!!!!
Keep in mind the very first sentence... Am I missing something here?? OMG
I hope I am.
Sam,
If you had to think about an uniform method for a
Connected PC
Mobile device
Not connected mobile PDA device
Endless amounts of active webpage's
Have you any idea how to handle that with a connected recordset?
Cor
"Sam Malone" <th************ @hotmail.com> schreef in bericht
news:%2******** ********@TK2MSF TNGP03.phx.gbl. .. Am I just totally missing something here? I'm just new to VS.NET 2005
(using VB.NET) and ADO.NET.
I get the impression that ADO.NET can't do what I'm used to doing with ADO
(previous ADO withVB6).
I used to bind (let's say a text box) to a field (column) in a recordset
and if I typed a value in that textbox and tabbed out of it, the value in
the database got updated without me having to do anything else.
Now what I see is a terribly convoluted mish-mash of connections,
adapters, datasets that have to be "filled" etc and then there's the data
bindings to get it so you can just "see" what is in your database (excuse
me, data "source") and then after all of that it doesn't even keep up to
date (if something in the underlying database changes) much less update
the database after all. I have to write the code to do that too!!!!
Keep in mind the very first sentence... Am I missing something here?? OMG
I hope I am.
Cor Ligthert [MVP] wrote: Sam,
If you had to think about an uniform method for a
Connected PC
Mobile device
Not connected mobile PDA device
Endless amounts of active webpage's
Have you any idea how to handle that with a connected recordset?
Cor
"Sam Malone" <th************ @hotmail.com> schreef in bericht
news:%2******* *********@TK2MS FTNGP03.phx.gbl ...
Am I just totally missing something here? I'm just new to VS.NET 2005
(using VB.NET) and ADO.NET.
I get the impression that ADO.NET can't do what I'm used to doing with ADO
(previous ADO withVB6).
I used to bind (let's say a text box) to a field (column) in a recordset
and if I typed a value in that textbox and tabbed out of it, the value in
the database got updated without me having to do anything else.
Now what I see is a terribly convoluted mish-mash of connections,
adapters, datasets that have to be "filled" etc and then there's the data
bindings to get it so you can just "see" what is in your database (excuse
me, data "source") and then after all of that it doesn't even keep up to
date (if something in the underlying database changes) much less update
the database after all. I have to write the code to do that too!!!!
Keep in mind the very first sentence... Am I missing something here?? OMG
I hope I am.
I think Sam has an excellent point - as developers we should have a
choice of working in a connected mode or not. In VB 6 we could work
with that recordset object as connected or not. Surely MS could have
given us the option of using ado.net in connected or disconnected mode,
maybe with two different components.
Tom
You can work in connected mode in one of two ways:
Read-only, forward-only needs are handled by the ADO.NET DataReader.
If read/write is desired, you can still use the ADO Recordset (if you must),
using COM InterOp.
Give the disconnected paradigm a chance, it is more code, but it results in
MUCH better performance overall.
"tomb" <to**@technetce nter.com> wrote in message
news:Cw******** ***********@big news2.bellsouth .net... Cor Ligthert [MVP] wrote:
Sam,
If you had to think about an uniform method for a
Connected PC
Mobile device
Not connected mobile PDA device
Endless amounts of active webpage's
Have you any idea how to handle that with a connected recordset?
Cor
"Sam Malone" <th************ @hotmail.com> schreef in bericht
news:%2****** **********@TK2M SFTNGP03.phx.gb l...
Am I just totally missing something here? I'm just new to VS.NET 2005
(using VB.NET) and ADO.NET.
I get the impression that ADO.NET can't do what I'm used to doing with
ADO (previous ADO withVB6).
I used to bind (let's say a text box) to a field (column) in a recordset
and if I typed a value in that textbox and tabbed out of it, the value in
the database got updated without me having to do anything else.
Now what I see is a terribly convoluted mish-mash of connections,
adapters, datasets that have to be "filled" etc and then there's the data
bindings to get it so you can just "see" what is in your database (excuse
me, data "source") and then after all of that it doesn't even keep up to
date (if something in the underlying database changes) much less update
the database after all. I have to write the code to do that too!!!!
Keep in mind the very first sentence... Am I missing something here?? OMG
I hope I am.
I think Sam has an excellent point - as developers we should have a choice
of working in a connected mode or not. In VB 6 we could work with that
recordset object as connected or not. Surely MS could have given us the
option of using ado.net in connected or disconnected mode, maybe with two
different components.
Tom
Thanks. I've been spending the weekend (it's a three day weekend here in
Canada) reading about it and yes I'm going to "give it a chance".
"Scott M." <s-***@nospam.nosp am> wrote in message
news:eo******** ******@TK2MSFTN GP05.phx.gbl... You can work in connected mode in one of two ways:
Read-only, forward-only needs are handled by the ADO.NET DataReader.
If read/write is desired, you can still use the ADO Recordset (if you
must), using COM InterOp.
Give the disconnected paradigm a chance, it is more code, but it results
in MUCH better performance overall.
"tomb" <to**@technetce nter.com> wrote in message
news:Cw******** ***********@big news2.bellsouth .net... Cor Ligthert [MVP] wrote:
Sam,
If you had to think about an uniform method for a
Connected PC
Mobile device
Not connected mobile PDA device
Endless amounts of active webpage's
Have you any idea how to handle that with a connected recordset?
Cor
"Sam Malone" <th************ @hotmail.com> schreef in bericht
news:%2***** ***********@TK2 MSFTNGP03.phx.g bl...
Am I just totally missing something here? I'm just new to VS.NET 2005
(using VB.NET) and ADO.NET.
I get the impression that ADO.NET can't do what I'm used to doing with
ADO (previous ADO withVB6).
I used to bind (let's say a text box) to a field (column) in a recordset
and if I typed a value in that textbox and tabbed out of it, the value
in the database got updated without me having to do anything else.
Now what I see is a terribly convoluted mish-mash of connections,
adapters, datasets that have to be "filled" etc and then there's the
data bindings to get it so you can just "see" what is in your database
(excuse me, data "source") and then after all of that it doesn't even
keep up to date (if something in the underlying database changes) much
less update the database after all. I have to write the code to do that
too!!!!
Keep in mind the very first sentence... Am I missing something here??
OMG I hope I am.
I think Sam has an excellent point - as developers we should have a
choice of working in a connected mode or not. In VB 6 we could work with
that recordset object as connected or not. Surely MS could have given us
the option of using ado.net in connected or disconnected mode, maybe with
two different components.
Tom
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Ville Vainio |
last post by:
It might just be that @decorator might not be all that bad. When you
look at code that uses it it's not that ugly after all.
A lot of the furor about this is probably because it happened so
quicly. The situation might have been different if we had seen a
pronouncement a week before, in the vein of "I have chosen this syntax
- it will go in to the next alpha".
My chief worry was throwing away one of the few unused ascii symbols,
but if...
|
by: Sims |
last post by:
Hi,
I have some small questions that have never been any problems, (for my
compiler?), but always make me curious.
So here goes...
what does the standard sday about the 'if' statement?
for example
if i have,
|
by: James Gregory |
last post by:
I'm pretty sure this is non-totally-trivial enough and standard-C++ enough
to post here, however much it may initially look like a "how do I make a
computer game?" question, though I may be wrong.
I'm loading a bitmap, and as I'm using Linux I've had to define
BITMAPFILEHEADER myself (maybe better practice would be to give my version
a new name or whatever, I dunno). Windows uses WORDs and DWORDs to
define it, I've used some...
|
by: Lauren Wilson |
last post by:
Ok I have searched the MS website for info on this. I am totally
confused.
If I want to deploy an Access 2003 app and allow my users to run it
using Access 2003 Runtime, where do I get the Runtime?
I just purchased Office 2003 Professional. Is Access 2003 Runtime
included with that or not?
It APPEARS that the only way I can get Access 2003 Runtime is to
|
by: Anan18 |
last post by:
kk..there were 15 problems for for the monthy projects..i finished 11 of them..these 4 were really hard..
5. your working on a problem in which you must display as integer ratios; therefore you need to be able to compute using common fractions and get the results that are common fractions in reduced form. you want to write a program that will allow you to add, subtract, multiply, and divide common fractions. The program will promt you for a...
| | |
by: fairyvoice |
last post by:
i am writing a very simple c/s socket program, i just wanted the client to
first write to the server, after server get the message it, write to the
client, the the client write again. here's the codes:
Server:
---------------------------------------------
NetworkStream ns = this.client.GetStream();
StreamReader reader = new StreamReader(ns);
StreamWriter sw = new StreamWriter(ns);
|
by: stef mientki |
last post by:
hello,
I've thought many times I finally understood the import / namespace rules,
but again I'm totally lost :-(
This is my library file
# Module lib_test.py
X = 1
|
by: Lloyd Sheen |
last post by:
Ok I have a web control which is used to input search terms. It works
really well on one page.
Now I need nearly the same functionallity on another page and I take the
pieces and move them to the new page (no web control). I have a button with
a click function which populates a repeater. On the first click of the
button it goes to the click handler and all is well. On the second click it
goes directly to the ItemCreated handler. ...
|
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...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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...
| | |
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
