Posts

Showing posts from March, 2011

Donate

Repair A SQL Server 2008 Suspect Database After Upgrading

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

Deploying ASP.NET Web Forms Websites Using ASP.NET Membership Framework

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)

How To Clear Sessions After Logout Button Is Clicked In ASP.NET Web Forms

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

How To Install IIS On Windows 7 Home Premium

Here's the link: Technet Link

Unable To Open EDMX (Entity Framework in Design View) After Closing

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

Insert Parameter Array in .NET (C# Version)

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));

Change Default Browser Of ASP.NET MVC Project

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!!!

Donate