ASP.NET解決DataView.RowFilter不能使用'Between'運算式的方法

2008-07-29

17290
0
ASP.NET

解決DataView.RowFilter不能使用'Between'運算式的方法

最近在討論區看到這樣的問題..把它記錄到我的Blog

一般要查詢資料的日期區間,都會用SQL語法的Between來達到

原始資料如下：

SQL指令：

方法1

SELECT         id, name, tel, date, flag
FROM             [Table]
WHERE         (date BETWEEN '2008/07/10' AND '2008/07/28')

方法2

SELECT         id, name, tel, date, flag
FROM             [Table]
WHERE         (CONVERT(varchar(10), date, 111) >= '2008/07/10') AND (CONVERT(varchar(10),
                          date, 111) <= '2008/07/28')

結果如下：

但DataView.RowFilter好像不支援此運算式,那要如何解決呢,看下列程式碼

asp.net(c#)部分程式碼：

using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using DataSet1TableAdapters; public partial class RowFilter : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { DataSet1TableAdapters.TableTableAdapter db = new DataSet1TableAdapters.TableTableAdapter(); DataTable dt = db.GetData(); string StartDate = "2008/07/10"; string EndDate = "2008/07/28"; DataView dv = dt.DefaultView; //用這種方式,會出現<運算式包含未支援的運算子 'Between'>的錯誤訊息 //dv.RowFilter = "date BETWEEN '2008/07/10' AND '2008/07/28'"; //改用下列這種方式來解決 dv.RowFilter = string.Format("date >= '{0}' and date <= '{1}'",StartDate,EndDate); this.GridView1.DataSource = dv ; this.GridView1.DataBind(); } }

參考網址：

http://www.programmer-club.com/pc2020v5/forum/showsametitleN.asp?board_pc2020=csharp&id=10114
http://www.blueshop.com.tw/board/show.asp?subcde=BRD200807281559109M9&fumcde=FUM20041006161839LRJ&rplcnt=3

回首頁