tsql where clause checking even or odd number

update student
set isOdd = 1, isEven = 0
where exammark % 2 =1

asp.net mvc c# convert a virtual path to application absolute path

use UrlHelper WebViewPage.Url

e.g.

mvc refresh current view without losing stuff like sorting, filtering etc

return Redirect(Request.UrlReferrer.ToString());

mvc HttpPostedFileBase always null

make sure the form declaration in the view has all necessary attributes, e.g.

@using (Html.BeginForm("Create", "Product", FormMethod.Post, new { enctype = "multipart/form-data" }))

{

      ...

}

found a useful way to show div as a modal

http://jsfiddle.net/r77K8/1/