Database won't update. Just Installed SQL Server. Please Help

I just installed SQL Server 2005 Express Edition to allow me to create databases in VB Express. The installation went fine (or so it seemed). When I complete the example to create a database and try to save the changes in the file, they are not retained.

I use the following statement to verify the changes have been made, but when I exit and return to the database, the changes are not made. If I make changes, the If statement correctly indicates the number of changes, but the are not saved. Any suggestions?

Dim RowsAffected As Integer = 0

RowsAffected = Me.CustomerTableAdapter1.Update(Me.MyCompanyDataSet1.Customer)

If RowsAffected > 0 Then

MessageBox.Show("Your updates were successful." & vbCrLf & _
RowsAffected.ToString & " row(s) were updated")

Else

MessageBox.Show("No changes were made.")

End If

Thanks...

Hi Patrick,

Check out my answer in this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=331048&SiteID=1.

You're hitting a common question related to running your application in Debug (F5) mode.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1