var data = db.Query("SELECT Date, XAG FROM metals WHERE Data BETWEEN '@StartDate' AND '@EndDate'");
That should be
var data = db.Query("SELECT Date, XAG FROM metals WHERE Data BETWEEN @0 AND @1");
The Database helper parameter markers are numbers starting from 0 onwards. Named parameters won't work, and they won't work with any database provider if they are between single quotes. That turns them into literal strings.
Mikesdotnett...
All-Star
154901 Points
19864 Posts
Moderator
MVP
Re: When displaying a chart is it possible to let users select a custom period for the data?
Feb 12, 2012 03:32 PM|LINK
That should be
var data = db.Query("SELECT Date, XAG FROM metals WHERE Data BETWEEN @0 AND @1");The Database helper parameter markers are numbers starting from 0 onwards. Named parameters won't work, and they won't work with any database provider if they are between single quotes. That turns them into literal strings.
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter