BUG in Microsoft Learning Resources VB Express Lesson 9 (Database Fails to Update).

I recently downloaded Visual Studio 2005 Express along with the Learning Resources for Visual Basic Express video. First let me say that the Learning Resources is an excellent resource for beginners to become familiar with Visual Studio, Database and programming concepts. Although the series is probably too basic for experienced developers you may find it reveals a number of tricks in the Visual Studio 2005 interface.

http://msdn.microsoft.com/vstudio/express/vb/default.aspx

Problem

I downloaded the VB Lesson 9 Visual Basic Project from Microsoft Learning Resources. With out making any changes to the project I compiled and ran it, making changes to the data and saving the changes. Every thing look great until you run it a second time and see that the changes to the data are all lost.

Observations:

1. Changes made to the data from within Visual Studio (Show Table Data) do take effect.

2. The in-memory data (DataSet) is changed as you move from row to row.

3. The TableAdapter.Update call returns 1, ostensibly indicating the number of rows updated.

4. The data in the database is not changed by the TableAdapter.Update call.

Operating System: Windows XP Pro Service Pack 2

Other Software installed on this system

20SQL Server 2005 Express

Visual Web Developer 2005 Express

Visual Studio 6.0 Enterprise

Visual Studio .net Enterprise

Microsoft .NET Framework SDK

Microsoft Office 2003

If anyone can help me understand the cause of this problem I would greatly appreciate it.

Thanks

Bob

Allow Nulls is a problem for Edit - Update

I have found the if you leave the Allow Nulls for any fields the Update will not work.

If any knows of a way to leave the Allow Nulls on some fields and have the Update work please let me know.

Thanks

Bob

bpasetup install interruption?

Hi- My basic bpasetup install is not completing on Win2000 Advanced Server SP4/SQL Server 2000.
I get to the point where I enter my servername and authentication mode. I have tried my server name and my servername\instance name in both security modes. Nothing seems to compete the installation (the message says it is interrupted and to restart the
install).
How can I get it to complete? I have disabled McAffee as well but left up all SQL services.
Thanks!
Susan
Can you please generate an installation log and post it here or send it to
me?
To generate the verbose log run:
msiexec.exe /i BPASETUP.msi /L*v .\bpainstall.log
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Susan" <Susan@.discussions.microsoft.com> wrote in message
news:8C94F4F9-05A7-48E6-8296-FEC352D17EF3@.microsoft.com...
> Hi- My basic bpasetup install is not completing on Win2000 Advanced Server
SP4/SQL Server 2000.
> I get to the point where I enter my servername and authentication mode. I
have tried my server name and my servername\instance name in both security
modes. Nothing seems to compete the installation (the message says it is
interrupted and to restart the install).
> How can I get it to complete? I have disabled McAffee as well but left up
all SQL services.
> Thanks!
|||Christian- I emailed you the log but the post here has a limit of 30000 text (the log isdouble). Please email me if you haven't received or a preferred area where I can post/ftp the log to you. Thanks- Susan
Thanks!

Bound control timing issues in Visual Basic

It is just me or...
I have two appications in very different environments that have
suddenly shown very similar behavior, after a fashion.
One application is simple desktop. I've been working on the development
off and on for a number of months. It uses controls bound to an Access
database. As a for instance, I have two list boxes where items are
copied from left to right and deleted from the left, a fairly standard
practice. After the delete from the left, the repaint should eliminate
the deleted item, which worked fine until just recently.
The client became very upset when the the control repainted with the
deleted item still displayed. And this was also happening with two grid
controls. It was making me quite nuts. I dug around until I found a
reference to 'sleep' and implemented it. The problem was resolved.
Therefore, the cursor in memory was not being overwritten in time to
keep up with the repaint.
I also have an application in a Citirx/Softricity environment that is
working just fine on several servers (it produces reports using the VB6
data report designer) but is failing on one. I have not yet seen the
results, but I've added the same 'Sleep' methodology to this
application. My current working assumption is that the application
(data report dll) does not have enough time to locate the remote
network printer in time to produce a display when requested by the
application. It's just a working assumption.
What I'm wondering is whether or not anyone else out there in VB land
particularly VB6 land has recently encountered any timing related
errors. I want to document this, if I'm not the only one encountering
the issues.
I'm bringing this up because of something I read around the time of the
emergency patch related to the possibility of viruses or trojans being
embbedded in graphic files. It suggested that the underlayment
(operating environment) was being adversly affected, that is it was
significantly slower to respond to certain requests, as a result of the
patch.
Thanks for your attention...Hello,
If you are using an Access database and you do not have a single
connection for the entire application, you may be running into this
issue:
http://support.microsoft.com/kb/q200300
Razvan