This make update manually by Connection string Defined right ?
Yes.
Some remarks.
You converted your database into an mdb, but you also using the new ACE 12.0 driver. This works, however, this dirver is not installed by defualt on a WIndows Serevr. So when using mdb files, you better use the Jet.Oledb.4.0 driver. And you can also use
the DataDirectorty Directive for files located in your App_Data folder:
Dim connectionString As String = "provider=Microsoft.Jet.OleDb.4.0;data source=|DataDirectory|Form_ContinuousSimulated.mdb")
And you're not using an Error handling, so when an error occurs, your connection doesn't close properly. When you're using another syntax, the connection will alwasy be closed and disposed properly, which is very important when using Access files:
hans_v
All-Star
35986 Points
6550 Posts
Re: accessdatasouce1.update using VB code in Asp.net
Nov 10, 2011 08:10 AM|LINK
Yes.
Some remarks.
You converted your database into an mdb, but you also using the new ACE 12.0 driver. This works, however, this dirver is not installed by defualt on a WIndows Serevr. So when using mdb files, you better use the Jet.Oledb.4.0 driver. And you can also use the DataDirectorty Directive for files located in your App_Data folder:
Dim connectionString As String = "provider=Microsoft.Jet.OleDb.4.0;data source=|DataDirectory|Form_ContinuousSimulated.mdb")
http://www.mikesdotnetting.com/Article/78/AccessDataSource-SqlDataSource-and-connecting-to-Access-databases-in-ASP.NET
And you're not using an Error handling, so when an error occurs, your connection doesn't close properly. When you're using another syntax, the connection will alwasy be closed and disposed properly, which is very important when using Access files:
http://www.mikesdotnetting.com/Article/26/Parameter-Queries-in-ASP.NET-with-MS-Access