View Complete Post
What to do when you need to disable triggers and constraints to perform data synchronization and other tasks with an offline database.
MSDN Magazine April 2007
MSDN Magazine January 2004
MSDN Magazine December 2003
I have a Repeater who should show some data from my ms.sql server. But all code inside the Repater is not shown on my .aspx page. What am i doing wrong. I have a similar Repeater on another page and there it works fine.
<div class="AnsaettelseKontrakt Folders">
<table cellpadding="0" cellspacing="0" width="750px" align="right">
<th class="BrugerHeader" style="width:300px;">Filnavn</th>
<th class="BrugerHeader" style="width:80px;">StÃÂ¸rrelse</th>
<th class="BrugerHeader" style="width:150px;">Dato</th>
<th class="BrugerHeader" style="width:180px;" colspan="2">Brugere</th>
<th class="BrugerHeader" style="width:40px;">VÃÂ¦rktÃÂ¸jer</th>
<asp:Repeater ID="RepeaterAns" runat="server" onitemcommand="Repeater1_ItemCommand" >
I have recently combined my aspnet membership database and main website database into one database file, I'm happy with the schemas, stored procedures etc. (This is a development project not yet a production project.)
My problem is that I can no longer simultaneously connect to the database from Visual Studio if a user is logged in to the website.
Scenario 1: No user is logged in to the website. I can go to the Data Connection window in VS, choose "Add Connection" and then inspect the contents and schemas of the database. This is fine.
Scenario 2: A user is logged in on the website. I try to connect to the website in VS and get the error:
"Cannot open user default database. Login failed. "
Scenario 3: I am connected to the database in VS and nobody is logged into the website. If someone tries to log into the website they get the following error:
So it seems from the above that there can be only one connection to the database at a time? However this was not the case before I combined the membership database with the main website database. I could always make changes as a user logged