Posts

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

How To Get ASP.NET Web Forms GridviewRow Selected Index In Row Command Event

In your row command event, add a code like this: int selected_index = Convert.ToInt32(e.CommandArgument);

How To Cast SQL Money Field Type To C# Data Type

Given you have a field called customer_salary which is of type money in sql server, to cast and use it in your c# programs, you cast it to decimal. decimal Price = Convert.ToDecimal(reader.GetValue(1));

Choosing Between ASP.NET MVC And ASP. NET WebForms

I've been playing around asp.net mvc just recently, i was really shocked and somewhat struggling with this new framework since i was used to the traditional N-Tier development with asp.net. As I developed simple examples, asp.net mvc is somewhat similar to n-tier development. As such, each layers have been separated to enable designers and coders to work independently with each layer. I have some books in my arsenal but i haven't read them yet.LOL Basically, I'm still a newbie with this stuff. One tip that i read was choosing between asp.net webforms and asp.net mvc. This will provide insights on other developers as well. Choosing between ASP.NET MVC and ASP.NET Webforms Source: ASP.NET MVC 1.0 Quickly In general, choosing between ASP.NET MVC and ASP.NET can be based on the following five criteria: 1. Are you considering test-driven development (TDD)? TDD enables you to write tests for an application first, after which the application logic is developed. An ASP.NET Webfor

Donate