I need to get results of a search between 2 dates in Webmatrix. I do not know how I need to have the search entered or what I am doing wrong. This is the code I have. I am not getting any errors but there is nothing but the column names displayed in the grid.
@{
Layout = "~/_SiteLayout.cshtml";
Page.Title = "Management";
var db = Database.Open("OMD");
var startdate = Request["startdate"];
var enddate = Request["enddate"];
var selectCommand ="SELECT * FROM Ordr Where Date BETWEEN '" + startdate + "' AND '" + enddate + "'";
var selectedData = db.Query(selectCommand);
var grid = new WebGrid(source: selectedData, defaultSort: "Date", rowsPerPage:10);
}
@grid.GetHtml(
columns:grid.Columns(
grid.Column("Date", format:@<Text>@item.Date</Text>),
grid.Column("Status", format:@<Text>@item.Status</Text>),
grid.Column("OStore", format:@<Text>@item.OStore</Text>),
grid.Column("CStore", format:@<Text>@item.CStore</Text>),
grid.Column("Employee", format:@<Text>@item.Employee</Text>)
)
)
I am searching with format MM/DD/YYYY like it is in the table.
Here's how to do it safely, using the Razor Database helper parameter conventions:
var db = Database.Open("OMD");
var startdate = Request["startdate"].AsDateTime();
var enddate = Request["enddate"].AsDateTime();
var selectCommand ="SELECT * FROM Ordr Where Date >= @0 AND Date <= @1";
var selectedData = db.Query(selectCommand, startdate, enddate);
Please read this for more information on working with data in ASP.NET Web Pages (Razor): http://www.asp.net/web-pages/tutorials/data/5-working-with-data
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
몇 마디 만하겠습니다