Re: Please help! Database won't update

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

On Mon, 13 Mar 2006 02:53:08 +0100, "Morten Dahl"
<morten.ikkespam@xxxxxxxxxx> wrote:

My database won't update??

I'm using VB.NET 2005 and SQL Server 2005 Express. I Create a Form and a
database. Using the wizard draging the DatabaseDataSet Table on the form.

Everything works fine. I can edit, delete, and add new records (save), but
my changes are not visible when I close and restart the application. The
changes made is in memory only.

Please help me :(


* Visual Basic.NET 2005
* SQL Server 2005 Express
* All on local machine

Example:
Lesson 9: Databinding Data to User Interface Controls
http://msdn.microsoft.com/vstudio/express/vb/learning/


Are you talking about close and restarting the app in the IDE or are
you talking about running the app's .exe file?

If you are talking about the IDE, try running an app 'build', and see
if changes are showing up when you close and restart the' build'. By
default in the IDE, every time you run the app, a new copy of the
original DB is copied to the bin/debug folder, hence, it appears that
nothing was updated. This drove me crazy the first time I played with
DB's in VB2005.

Gene
.

Relevant Pages

  • Re: Webservices - the way to go...?
    ... about your lack of secure network connectivity your between a rock and a ... To summarize the posts so far: you have a winform app. ... using a webservices data layer to handle all the database interactions. ... Upgrade your database to SQL Server. ...
    (microsoft.public.dotnet.general)
  • Re: MSVC++ app type choice, form design questions
    ... > 1) MSVC Project definition requires that for an MFC app I choose ... MFC's built-in database support is really built around the document/ ... with the full version of SQL Server, but it's still pretty usable -- ...
    (microsoft.public.vc.mfc)
  • Re: SQL Licensing
    ... it depends on the features you used in your database development. ... If your app works with Express, then go with it not to buy license for SQL Server instances. ...
    (microsoft.public.sqlserver.clients)
  • Re: MSVC++ app type choice, form design questions
    ... >> 1) MSVC Project definition requires that for an MFC app I choose ... At startup the end user sees a summary of the database contents. ... MDAC has full built-in support ... >competing with the full version of SQL Server, ...
    (microsoft.public.vc.mfc)
  • Integrated Security in a Workgroup?
    ... I'm trying to set up a development environment for developing an ASP.Net app ... that needs to access an SQL Server 2000 database. ... On machine "B" (where the SQL Server is running) I had no problem setting up ...
    (microsoft.public.sqlserver.security)