Search between 2 dates in webmatrix

James

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.

Mike Brind

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] 삭제

에서 수정
0

몇 마디 만하겠습니다

0리뷰
로그인참여 후 검토

관련 기사

분류에서Dev

how to get a column with a list of dates between 2 known dates

분류에서Dev

Taking the Differences Between 2 Dates (R)

분류에서Dev

How to count fractional days between 2 dates

분류에서Dev

Calculating Time Difference between 2 Dates

분류에서Dev

Excel get value between 2 dates

분류에서Dev

Reading logs with the word 'ERROR' between 2 dates

분류에서Dev

MySQL query to search in between two time range between two dates using timestamp data

분류에서Dev

how to receive all days between 2 dates in laravel

분류에서Dev

Number of working days between 2 dates according JIRA's configuration

분류에서Dev

differences between dates in sql

분류에서Dev

How to get difference between 2 dates in number of days,hours,minutes and seconds

분류에서Dev

Difference in years between two dates

분류에서Dev

Twig, subtract 2 dates

분류에서Dev

comparing 2 dates with javascript

분류에서Dev

How to search for dates before 1970 with thinking sphinx?

분류에서Dev

Search for the date of today in a Word doc filled with dates

분류에서Dev

How to display all the dates between multiple two dates in a table?

분류에서Dev

Calculating the days between two given dates

분류에서Dev

Converting dates between SQL Server and Postgres with Talend

분류에서Dev

Find Average Interval between Dates in a Pivot Table

분류에서Dev

Datatables and DateTime format of interval between dates not sortable

분류에서Dev

Gap Between two two dates of different cells

분류에서Dev

sqlite : time difference between two dates in decimals

분류에서Dev

Room availability between two dates (beginner)

분류에서Dev

Difference between two dates in excel 2013

분류에서Dev

Webmatrix-하나의 기본 키로 2 개의 테이블 생성

분류에서Dev

How to get the number of weeks and its respective dates between two given dates (VB.NET)

분류에서Dev

Can I download emails recived between dates in JavaMail (IMAP)?

분류에서Dev

Joda Time - Calculation of seconds between two dates throws an exception.

Related 관련 기사

  1. 1

    how to get a column with a list of dates between 2 known dates

  2. 2

    Taking the Differences Between 2 Dates (R)

  3. 3

    How to count fractional days between 2 dates

  4. 4

    Calculating Time Difference between 2 Dates

  5. 5

    Excel get value between 2 dates

  6. 6

    Reading logs with the word 'ERROR' between 2 dates

  7. 7

    MySQL query to search in between two time range between two dates using timestamp data

  8. 8

    how to receive all days between 2 dates in laravel

  9. 9

    Number of working days between 2 dates according JIRA's configuration

  10. 10

    differences between dates in sql

  11. 11

    How to get difference between 2 dates in number of days,hours,minutes and seconds

  12. 12

    Difference in years between two dates

  13. 13

    Twig, subtract 2 dates

  14. 14

    comparing 2 dates with javascript

  15. 15

    How to search for dates before 1970 with thinking sphinx?

  16. 16

    Search for the date of today in a Word doc filled with dates

  17. 17

    How to display all the dates between multiple two dates in a table?

  18. 18

    Calculating the days between two given dates

  19. 19

    Converting dates between SQL Server and Postgres with Talend

  20. 20

    Find Average Interval between Dates in a Pivot Table

  21. 21

    Datatables and DateTime format of interval between dates not sortable

  22. 22

    Gap Between two two dates of different cells

  23. 23

    sqlite : time difference between two dates in decimals

  24. 24

    Room availability between two dates (beginner)

  25. 25

    Difference between two dates in excel 2013

  26. 26

    Webmatrix-하나의 기본 키로 2 개의 테이블 생성

  27. 27

    How to get the number of weeks and its respective dates between two given dates (VB.NET)

  28. 28

    Can I download emails recived between dates in JavaMail (IMAP)?

  29. 29

    Joda Time - Calculation of seconds between two dates throws an exception.

뜨겁다태그

보관