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

Browser compatibility for Reporting Services

We are considering using Reporting Services along with Dundas charts for our
web-based reporting application. However, we hear that using Reporting
Services will LIMIT us to only I.E. browser. Is this true? Can Reporting
Services be used with other web browsers besides I.E.?
Thank you,
Morgan StricklandJust my 2 cents. I use IE and FireFox. The Report Manager and Report
Server webs and the web service rendering work just fine in IE. It doesn't
work correctly in Firefox 1.0.4. I would be curious to test Mozilla and
some of the others...
--
Adrian M.
MCP
"Morgan Strickland" <Morgan Strickland@.discussions.microsoft.com> wrote in
message news:20A0483F-2BBD-422B-926D-69DF36B26643@.microsoft.com...
> We are considering using Reporting Services along with Dundas charts for
> our
> web-based reporting application. However, we hear that using Reporting
> Services will LIMIT us to only I.E. browser. Is this true? Can Reporting
> Services be used with other web browsers besides I.E.?
> Thank you,
> Morgan Strickland
>|||I just disable the top toolbar with anything but IE.
The actual reports do work for me, but not all the functionality.
"Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
news:%23sLt3y$VFHA.3532@.TK2MSFTNGP09.phx.gbl...
> Just my 2 cents. I use IE and FireFox. The Report Manager and Report
> Server webs and the web service rendering work just fine in IE. It
doesn't
> work correctly in Firefox 1.0.4. I would be curious to test Mozilla and
> some of the others...
> --
> Adrian M.
> MCP
>
> "Morgan Strickland" <Morgan Strickland@.discussions.microsoft.com> wrote in
> message news:20A0483F-2BBD-422B-926D-69DF36B26643@.microsoft.com...
> > We are considering using Reporting Services along with Dundas charts for
> > our
> > web-based reporting application. However, we hear that using Reporting
> > Services will LIMIT us to only I.E. browser. Is this true? Can Reporting
> > Services be used with other web browsers besides I.E.?
> >
> > Thank you,
> > Morgan Strickland
> >
>|||There were several bugs in the SQL 2000 version of Reporting Services around
support for other browsers. We are working on addressing these for SQL 2005
Reporting Services. We plan to support Firefox and Safari in addition to IE.
Every single feature might not work, but most things should.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Morgan Strickland" <Morgan Strickland@.discussions.microsoft.com> wrote in
message news:20A0483F-2BBD-422B-926D-69DF36B26643@.microsoft.com...
> We are considering using Reporting Services along with Dundas charts for
> our
> web-based reporting application. However, we hear that using Reporting
> Services will LIMIT us to only I.E. browser. Is this true? Can Reporting
> Services be used with other web browsers besides I.E.?
> Thank you,
> Morgan Strickland
>|||Brian,
We are just now planning on upgrading from SQL 2000 to SQL 2003 (and begin
using Reporting Services). Does SQL 2003 support browsers other than IE? If
not, when is SQL 2005 due for release?
Thank you
Morgan Strickland
"Brian Welcker [MS]" wrote:
> There were several bugs in the SQL 2000 version of Reporting Services around
> support for other browsers. We are working on addressing these for SQL 2005
> Reporting Services. We plan to support Firefox and Safari in addition to IE.
> Every single feature might not work, but most things should.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Morgan Strickland" <Morgan Strickland@.discussions.microsoft.com> wrote in
> message news:20A0483F-2BBD-422B-926D-69DF36B26643@.microsoft.com...
> > We are considering using Reporting Services along with Dundas charts for
> > our
> > web-based reporting application. However, we hear that using Reporting
> > Services will LIMIT us to only I.E. browser. Is this true? Can Reporting
> > Services be used with other web browsers besides I.E.?
> >
> > Thank you,
> > Morgan Strickland
> >
>
>|||There is not a SQL Server 2003. There is a Service Pack 3a but there is not
a SQL Server 2003. MS has said that SQL Server 2005 will be released this
year.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Morgan Strickland" <Morgan Strickland@.discussions.microsoft.com> wrote in
message news:A9A29692-0499-40FC-8EC0-7A594BA5797A@.microsoft.com...
> Brian,
> We are just now planning on upgrading from SQL 2000 to SQL 2003 (and begin
> using Reporting Services). Does SQL 2003 support browsers other than IE?
> If
> not, when is SQL 2005 due for release?
> Thank you
> Morgan Strickland
> "Brian Welcker [MS]" wrote:
>> There were several bugs in the SQL 2000 version of Reporting Services
>> around
>> support for other browsers. We are working on addressing these for SQL
>> 2005
>> Reporting Services. We plan to support Firefox and Safari in addition to
>> IE.
>> Every single feature might not work, but most things should.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Morgan Strickland" <Morgan Strickland@.discussions.microsoft.com> wrote
>> in
>> message news:20A0483F-2BBD-422B-926D-69DF36B26643@.microsoft.com...
>> > We are considering using Reporting Services along with Dundas charts
>> > for
>> > our
>> > web-based reporting application. However, we hear that using Reporting
>> > Services will LIMIT us to only I.E. browser. Is this true? Can
>> > Reporting
>> > Services be used with other web browsers besides I.E.?
>> >
>> > Thank you,
>> > Morgan Strickland
>> >
>>|||wow...new browsers popping up all the time. Never even heard of Safari...
--
Adrian M.
MCP
"Brian Welcker [MS]" <bwelcker@.online.microsoft.com> wrote in message
news:OOoKP5KWFHA.1796@.TK2MSFTNGP15.phx.gbl...
> There were several bugs in the SQL 2000 version of Reporting Services
> around support for other browsers. We are working on addressing these for
> SQL 2005 Reporting Services. We plan to support Firefox and Safari in
> addition to IE. Every single feature might not work, but most things
> should.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Morgan Strickland" <Morgan Strickland@.discussions.microsoft.com> wrote in
> message news:20A0483F-2BBD-422B-926D-69DF36B26643@.microsoft.com...
>> We are considering using Reporting Services along with Dundas charts for
>> our
>> web-based reporting application. However, we hear that using Reporting
>> Services will LIMIT us to only I.E. browser. Is this true? Can Reporting
>> Services be used with other web browsers besides I.E.?
>> Thank you,
>> Morgan Strickland
>|||As far as you are not related with Mac, you won´t get in touch with that.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Adrian M." <absolutelynospam@.nodomain_.com> schrieb im Newsbeitrag
news:O6h6Z%23iWFHA.3464@.TK2MSFTNGP10.phx.gbl...
> wow...new browsers popping up all the time. Never even heard of Safari...
> --
> Adrian M.
> MCP
>
> "Brian Welcker [MS]" <bwelcker@.online.microsoft.com> wrote in message
> news:OOoKP5KWFHA.1796@.TK2MSFTNGP15.phx.gbl...
>> There were several bugs in the SQL 2000 version of Reporting Services
>> around support for other browsers. We are working on addressing these for
>> SQL 2005 Reporting Services. We plan to support Firefox and Safari in
>> addition to IE. Every single feature might not work, but most things
>> should.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Morgan Strickland" <Morgan Strickland@.discussions.microsoft.com> wrote
>> in message news:20A0483F-2BBD-422B-926D-69DF36B26643@.microsoft.com...
>> We are considering using Reporting Services along with Dundas charts for
>> our
>> web-based reporting application. However, we hear that using Reporting
>> Services will LIMIT us to only I.E. browser. Is this true? Can Reporting
>> Services be used with other web browsers besides I.E.?
>> Thank you,
>> Morgan Strickland
>>
>