Keeping Database Connection Open
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I am attempting to create an ASP.NET application which constantly accesses a database, from all the examples I have seen in the MSDN documentation it says that the connections should be opened and closed for each transactions. However I would like to lock the records that are shown on the screen so that they cannot be edited by another instance. I cannot find any examples of how to: - 1) Keep the connection open the whole time. 2) Pass the DAL object between ASP.NET pages so that I can have multiple pages containing the data. Chris