C#+ACCESS 查询"日期"字段值大于指定日期的记录方法

[lzpuxx]

我想在C#+ACCESS中查询出记录的日期字段（enter_dat1）大于指定“日期”（TextBox3.Text的值,如:2008-10-09）中的记录，用以下的代码出现 OleDbDataReader reader = cmd.ExecuteReader()处出现“至少有一个参数未指定”的错误，请大家指教，或赐与更简单的方法,谢谢！


string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/data/xsgl.mdb");
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DateTime datt = Convert.ToDateTime(TextBox3.Text);
String sql = "select numbe1,nam1,se1,enter_dat1,fiel1 from xsjf where fiel1='" + DropDownList2.SelectedValue.Trim() + "' and enter_dat1 > datt";
OleDbCommand cmd = new OleDbCommand(sql, conn);
OleDbDataReader reader = cmd.ExecuteReader();
GridView2.DataSource = reader;
GridView2.DataBind();

[特别]

String sql = "select numbe1,nam1,se1,enter_dat1,fiel1 from xsjf where fiel1='" + DropDownList2.SelectedValue.Trim() + "' and enter_dat1 > datt";
改成
String sql = "select numbe1,nam1,se1,enter_dat1,fiel1 from xsjf where fiel1='" + DropDownList2.SelectedValue.Trim() + "' and enter_dat1 > #"+datt+"#";
你这个datt应该是变量吧
在ACCESS中，表示日期要用#界定起来,如
select * from table where field=#2009-01-15#

[xuqunying0545]

[Quote=引用 1 楼 sdfkfkd 的回复:]
String sql = "select numbe1,nam1,se1,enter_dat1,fiel1 from xsjf where fiel1='" + DropDownList2.SelectedValue.Trim() + "' and enter_dat1 > datt";
改成
String sql = "select numbe1,nam1,se1,enter_dat1,fiel1 from xsjf where fiel1='" + DropDownList2.SelectedValue.Trim() + "' and enter_dat1 > #"+datt+"#";
你这个datt应该是变量吧
在ACCESS中，表示日期要用#界定起来,如
select * from table where f…
[/Quote]
up

[lzpuxx]

谢谢指教,问题解决!