Items By Type: FAQ

Conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value

Wednesday, April 9, 2014 1:45 PM

Entity Framework

I managed to generate this error twice within a few days while working with the Entity Framework and SQL Server 2012. I had to resort to searching for a resolution on both occasions so I'm posting about it to sear the cause and solution into my brain.

Click to read more about Conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value ...

Viewed 12678 times

1 Comment for this item

WebMatrix Opens Wrong Version Of Visual Studio

Sunday, May 1, 2011 8:56 AM

Visual Studio WebMatrix

A number of people have complained that clicking the Visual Studio Launch button in WebMatrix opens an older version of Visual Studio instead of the latest version. There is an easy fix to this.

Click to read more about WebMatrix Opens Wrong Version Of Visual Studio ...

Viewed 14768 times

7 Comments for this item

Solving the Operation Must Use An Updateable Query error

Wednesday, April 30, 2008 10:48 PM

ASP.NET 2.0 MS Access ADO.NET ASP.NET 3.5

The unbelievably cryptic Operation Must Use An Updateable Query error is the bane of developers who are just starting out with Access and ASP.NET. You've done your code, plopped your database file in the App_Data folder (or at least, you should have done), and try to run a page that INSERTs or UPDATEs records, and it all stops dead. This brief article explains the cause of the error, and the steps required to stop it recurring.

Click to read more about Solving the Operation Must Use An Updateable Query error ...

Viewed 171670 times

45 Comments for this item

How to get your forum question answered - avoid thread-jacking

Tuesday, November 13, 2007 12:33 PM

ASP.NET 2.0

If you have just been directed to this page, it may be because you have just thread-jacked. If you are not sure what that means, read on for an explanation, and some guidance.

Click to read more about How to get your forum question answered - avoid thread-jacking ...

Viewed 879723 times

26 Comments for this item

Recent Comments

Gautam 11/20/2014 8:01 AM
In response to I'm Writing A Book On WebMatrix
Hello Mike, I read your book, loved it! However, I have a few request/suggestions: 1) an example...

Bret Dev 11/19/2014 8:39 PM
In response to The Difference Between @Helpers and @Functions In WebMatrix
Excellent post! One concern - where can you place global @Functions code within an MVC project to Is...

Rob Farquharson 11/19/2014 4:28 PM
In response to iTextSharp - Links and Bookmarks
How can I place text at an absolute position on the page? Also, how can I rotate text?...

Andy 11/17/2014 8:08 PM
In response to MVC 5 with EF 6 in Visual Basic - Sorting, Filtering and Paging
Hello I'm testing your sorting instructions above. This is great and I was able to get it to work...

Gautam 11/17/2014 5:51 PM
In response to WebMatrix - Database Helpers for IN Clauses
Hi Mike, I am very new to programming: In the above example if I want to use a delete button the...

donramon 11/17/2014 3:22 PM
In response to Entity Framework 6 Recipe - Alphabetical Paging In ASP.NET MVC
Congratulations on your new website look and the excellent articles. Thank you!...

Gautam 11/17/2014 11:26 AM
In response to Looking At The WebMatrix WebGrid
Hi Mike, I add the jquery script at the end of my html file.. when ajax attribute is added to the be...

Chet Ripley 11/15/2014 6:57 PM
In response to Adding A New Field
It appears the command is case sensitive. I had the same issue as Cameron. When I changed the to it...

Alvin 11/14/2014 12:49 PM
In response to Razor Web Pages E-Commerce - Adding A Shopping Cart To The Bakery Template Site
Great article Mike! When do you plan to extend the bakery shopping cart beyond this point?...

Gautam 11/14/2014 10:16 AM
In response to Web Pages - Efficient Paging Without The WebGrid
to get the count can we use only the below sql, why to join category and author table var sql =...