在webmatrix中的两个日期之间搜索 [英] search between two dates in webmatrix

问题描述

这就是我有的但是我得到一个错误请帮帮我

 @ {Layout =   Layout.cshtml; 
 Page.Title =  过滤WebGrid; 
  var  db = Database.Open（  SRC）; 
  var  selectCommand =   SELECT * FROM Checks ; 
  var  searchTerm =  ; 
  var  startdate =  ; 
  var  enddate =  ; 
  var  selectCommand =   SELECT * FROM Checks日期BETWEEN' + startdate +  'AND' + enddate + ' ; 
 var selectedData = db.Query（selectCommand，searchTerm）; 
 var grid = new WebGrid（source：selectedData，defaultSort：Date，rowsPerPage：10）; 
}  

过滤WebGrid

< pre lang =HTML> < 表格 方法 = post < span class =code-keyword>>
< div id = 网格 >
网站名称：< 输入 type = text id = startdate 名称 = startdate / >
date：< input type = text id = enddate name = enddate / >
< input type = 提交 / >
@ grid.GetHtml（

tableStyle：grid，
headerStyle：grid-header，
alternatingRowStyle： grid-alternating-row，
footerStyle：webgrid-footer，
selectedRowStyle：grid-selected-row，
rowStyle：grid-row-style，
列：grid.Columns（
grid.Column（Site），
grid.Column（Date），
grid.Column（DoorKeypads），
grid.Column（RoomAircon），
grid.Column（RackAircon），
grid.Column（DisplayScreen），
grid.Column（Temperature），
grid.Column（Humidity），
grid.Column（Floor），
grid.Column（UPS），
grid.Column（用户名）
< ）

）

< / div >
< / form >

解决方案

您应该更改此行：

 var selectCommand =SELECT * FROM检查日期BETWEEN''+ startdate +''AND''+ enddate +''; 
 

到此行：

 var selectCommand =SELECT * FROM检查日期BETWEEN''+ startdate +''AND''+ enddate +''; 
 

注意末尾的单个刻度标记在双引号内。

Hi this is what I have but im getting an error please help me

@{  Layout = "Layout.cshtml";
    Page.Title = "Filter WebGrid";
    var db = Database.Open("SRC") ;
    var selectCommand = "SELECT * FROM Checks";
    var searchTerm = "";
    var startdate = "";
    var enddate = "";
    var selectCommand ="SELECT * FROM Checks Where Date BETWEEN '" + startdate + "' AND '" + enddate + '"";
    var selectedData = db.Query(selectCommand, searchTerm);
    var grid = new WebGrid(source: selectedData, defaultSort: "Date", rowsPerPage:10);
 }

Filter WebGrid

<form method="post">
    <div id="grid">
        Site Name: <input type="text" id="startdate" name ="startdate" />
        date: <input type="text" id="enddate" name="enddate" />
        <input type="submit" />
       @grid.GetHtml(

        tableStyle: "grid",
        headerStyle: "grid-header",
        alternatingRowStyle: "grid-alternating-row",
        footerStyle: "webgrid-footer",
        selectedRowStyle: "grid-selected-row",
        rowStyle: "grid-row-style",
        columns:grid.Columns(
            grid.Column("Site"),
            grid.Column("Date"),
            grid.Column("DoorKeypads"),
            grid.Column("RoomAircon"),
            grid.Column("RackAircon"),
            grid.Column("DisplayScreen"),
            grid.Column("Temperature"),
            grid.Column("Humidity"),
            grid.Column("Floor"),
            grid.Column("UPS"),
            grid.Column("Username")
 <          )

        )

    </div>
</form>

解决方案

You should change this line:

var selectCommand ="SELECT * FROM Checks Where Date BETWEEN ''" + startdate + "'' AND ''" + enddate + ''"";

to this line:

var selectCommand ="SELECT * FROM Checks Where Date BETWEEN ''" + startdate + "'' AND ''" + enddate + "''";

Notice the single tick mark at the end is inside the double quotes.

这篇关于在webmatrix中的两个日期之间搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！