Posted on: 5/6/2013 9:52:32 PM | Views : 206

I am looking for a tutorial or sample for asp.net (vb 2010) connecting to MS access database, new, update, & delete record. I have done classic ASP where code would be: New: rsAddRecord.Open strSQL, adoCon rsAddRecord.AddNew rsAddRecord.update Update: strSQL = "SELECT Table1.* from Table1 where ID=" & theRecordNo rsUpdate.Fields("Submitted") = "True" rsUpdate.Update Delete: strSQL = "SELECT Table1.* from Table1 where ID=" & theRecordNo rsDeleteRecord.LockType=3 rsDeleteRecord.Open strSQL, adoCon rsDeleteRecord.Delete I have read the MS position on MS Access (buy SQL): It is not recommended to use an Access database in a production web application. For production purposes, consider connecting to a MicrosoftT SQL Server database using the SqlDataSource or ObjectDataSource controls. I get as far as configuring the AccessDa ...

Go to the complete details ...