.NET GENES

Lately, I've installed SQL Server 2008 Developer Edition in my pc and migrated all sql server 2005 databases. Upon attaching/restoring all databases, some were marked as suspect. Below is the sql script to repair those databases. EXEC sp_resetstatus 'Test' ; ALTER DATABASE Test SET EMERGENCY DBCC checkdb( 'Test' ) ALTER DATABASE Test SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB ( 'Test' , REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE Test SET MULTI_USER But as a precautionary measure,I have back-up plans for each database,as to have another copy when things go wrong. Test is the database name. Source: how-to-repair-sql-server-2008-suspect

In my case, i have been experimenting an e-commerce application which uses asp.net membership framework. If I run the website using visual studio 2008, it successfully logs in using the users i have created using the built-in asp.net website administration tool. However, if you deploy this on a production server such as IIS, you cant' log-in. The solution is straightforward in this link: Always set the "applicationName" property when configuring ASP.NET 2.0 Membership and other Providers(Configuring ASP.NET 2.0 Membership)

Solution I found is on this link: ASP.NET Forum Link

Here's the link: Technet Link

Scenario: You may have recently added an entity framework that maps to an sql server table. After that, you suddenly close it. But when you tried to double click the Entity model, it does not open in the design view. Solution: Cannot Open .edmx file in the designer

The first version i created was a vb.net version. Here is the C# version: myConn objCon = Program.connectionstring; string str = objCon(); //pass delegate to string SqlConnection connection = new SqlConnection(str); try { List<Patient>patients = new List<Patient>(); for ( int i = 0; i < 5; i++) { Patient patient = new Patient(); patient.name = "greg" + i; patient.code = i*2; patients.Add(patient); } //insert into array connection.Open(); StringBuilder query = new StringBuilder(); SqlCommand cmd = new SqlCommand(); for ( int j = 0; j < patients.Count; j++) { query.Append( string .Format( "Insert into patients (PatientName,PatientSexCode) values (@names{0},@code{1}); ",j,j));

To change a default browser for an asp.net mvc website to render is not straightforward. However, the steps are just easy: 1. Add a webform or a static html to the application, just leave the default name. 2. Right click on the newly added webform. 3. Click Browse With. 4. Choose the browser like Firefox, IE, or Chrome. 5. Mark it as default. Thats it!!!