Question: Hi all I have about 5 values in a sqlserver table, one of the fields is 'orderid' I want to update 1 of the values and change its order id. So for example

```
apples is 1
oranges is 2
bananas is 3
pears 4
grapes 5
etc etc

```

I want to update bananas so its order id is 2, but it also updates the rest of the table so that orderid acts like it is a unique field

can anyone suggest the best way to go about this, using either a stored procedure or asp.net c#

Answer: 
Ok after much playing around with this I have found the error to be with the closing comment tags within the Razor if statement.

I think as it starts with a dash, the compiler is treating this as Razor syntax instead of taking it back to HTML content. I have solved the problem using `Html.Raw`:

```
<ul id="product-tabs-nav"><!--
     --><li><a href="#product-summary">Summary</a></li><!--
     @if (AppSettings.EcommerceEnabled)
     {
         @Html.Raw("--><li><a href=\"#product-reviews\">Reviews</a></li><!--");
     }
 --></ul>

```
Comment in razor c# code you can create llike this `@* *@`

So 

```
<ul id="product-tabs-nav"><!-- Some html comment   -->
<li><a href="#product-summary">Summary</a></li>
  @*if (AppSettings.EcommerceEnabled)
  { this is commented
      *@
<li><a href="#product-reviews">Reviews</a></li>
@*
  } this is commented
*@</ul>

```