Visual Basic 2008 Express

[Ken01]

Does anyone know what features are missing from VB 2008/ VB 2010 Express that
are present in the fu1l versions? For example has the facility to amend data on a
database been disabled?

 

[jebenson]

Google and Wikipedia are your friends. That was literally the first result of a search for 'visual studio express version limitations'

https://en.wikipedia.org/wiki/Microsoft_Visual_Studio_Express

The info you want is under the heading "2005–2010 products".


I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!

 

[Ken01]

Hello Jebenson
Thank you for your quick reply.
According to Wiki, VB 2008 and 2010 Express are compatible with MS Access and SQL Server.

However they only seem to have 'read only' access rights as any updates don't actually take place.

The following code, adapted from a Microsoft web-site doesn't work, while at the same time does not
trigger any error.

Try
Me.TestTableAdapter.Update(Me.AphDb1DataSet1.Test)
Me.AphDb1DataSet1.Test.AcceptChanges()
Me.TestTableAdapter.Update(Me.TestBindingSource.Contains(Me.AphDb1DataSet1))
Catch
MsgBox("Update NOT successful ! " & Err.Number)
End Try

 

[jebenson]

First, try removing the line "Me.AphDb1DataSet1.Test.AcceptChanges()" and see if that works.

Second, make sure you have all the Command objects (InsertCommand, UpdateCommand and DeleteCommand) set for the TableAdapter.

Third, what database are you using, SQL Server or Access? If it's Access, check the "Copy to Output Directory" setting in Server Explorer, as it defaults to "Copy always." In this case, check the bin\Debug directory for a copy of the database, and I'll bet you'll find the data there. Changing this setting to "Do not copy" will make the application use the database you selected and not a copy. Here's a link with more information about the Copy to Output Directory setting:

https://msdn.microsoft.com/en-us/library/ms246989(VS.80).aspx

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!

 

[Ken01]

Thanks very much, Jebenson.

Point 2 solved the problem.

Regards

Ken01