Database update help needed

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: StressPuppy (StressPuppy_at_discussions.microsoft.com)
Date: 02/16/05 

Date: Wed, 16 Feb 2005 14:59:07 -0800

I am a newbie to the ADO .NET stuff. I am using Visual Studio 2003/ VB to
develop an app. Been doing development for a long time, but having a tough
time getting my hands around the new way of doing things. Hoping you can
help.

First, is there a site or book you can point me to that will describe this
stuff in detail? I can't seem to get the stuff I am reading/trying to work.

Second, can someone give me a basic idea on the "preferred" use of data
adapters and datasets? Separate DS for each DA, or one DS for all DAs?

Lastly, I have an issue of data not being saved. I have a DB connection to
an Access DB, a DA with the necessary SQL statements for update and insert,
and a group of text controls bound to the data. I open the form and the data
is there. I make changes and then issue:

MyDataAdapter.Update(MyDataSet)

I get no errors, but nothing changes in the DB.

Part of the issues for me are understanding the opening/closing of the
connection and how the data in the DS gets back to the actual DB.

Sorry for the long question/post and many questions. I appreciate any help!!

Relevant Pages

  • Re: Forms Authentication - Admin Pages Outside of VS?
    ... have a look at the query strings they pass into the admin page - basically the virtual and physical path of the app you want to configure ... in addition - there is a check in the source to only allow connection from localhost - you would have to remove that check. ... ASP.Net app and then clicked the Website, ASP.Net Configuration Menu ... folder and run it from another Web instead of inside Visual Studio? ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • sockets not seeing the world :(
    ... development on visual studio 2003. ... app using sockets. ... to connect to the outside world both on the emulator and the device. ... which tells me it has no internet connection. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Local connection to SQL Server 2005 Express fails
    ... I just installed SQL Server 2005 Express edition, and created an app in ... Visual Studio using C#. ... "An error has occurred while establishing a connection to the server. ...
    (microsoft.public.sqlserver.connect)
  • Re: A month with a Nokia n95 (long)
    ... and can't play. ... One of these days I will get around to writing a small app to do it all on the fly. ... HSDPA works well and you can have more than one internet connection going at once. ... For example I can use it as a modem for my laptop and also "listen again" to a Beeb radio programme. ...
    (uk.telecom.mobile)
  • Re: ADO Connection.Execute Method leaves Open SQL Process
    ... Have the App create a single ADODB.Connection object, ... requesting only one connection from a single ADO Connection ... Pool, thus if all requests are sequenced and not over-lapping ...
    (microsoft.public.vb.database.ado)