DateTime t = DateTime.Parse("2002-7-23"); "Select ab1 as 编号,ab2 as 名称,ab3 as 生产日期 from SHD2 where ab3='"+t+"'"
DateTime dt = new DateTime dt = DateTime.Parse(ds.Text) Cmd=new OleDbDataAdapter("Select ab1 as 编号,ab2 as 名称,ab3 as 生产日期 from SHD2 where ab3='"+dt+"'",ConnStr); 建议对事件查询用时间短查询: Cmd=new OleDbDataAdapter("Select ab1 as 编号,ab2 as 名称,ab3 as 生产日期 from SHD2 where ab3<'"+dt+"' and ab3>'"+dt1+"'",ConnStr); 祝你成功!
谢谢你们了,但还是不行呀,"数据类型不匹配",表为空时 就可以运行.DateTime.Parse方法是不是还有一个指定格 式的参数?我的代码:private void Button3_Click(object sender, System.EventArgs e)//更新 { String Provider,DataBase,ConnStr; Provider="Microsoft.Jet.OLEDB.4.0;"; DataBase=Server.MapPath("mesh.mdb"); ConnStr="Provider="+Provider+"Data Source="+DataBase; DateTime t = DateTime.Parse("2002-7-23"); string sql1="Select ab1 as 编号,ab2 as 名称,ab3 as 生产日期 from SHD2 where ab3='"+t+"'"; OleDbDataAdapter Cmd3; Cmd3=new OleDbDataAdapter(sql1,ConnStr); DataSet ds=new DataSet(); Cmd3.Fill(ds,"SHD2"); DataGrid1.DataSource=ds.Tables["SHD2"].DefaultView; DataGrid1.DataBind(); }
补充一点:我用的是ACCESS数据库.
DateTime.Parse方法,默认生成格式是“1999-1-1 00:00:00” 所以ACCESS数据库中字段要是设成短日期的话 你的用 DateTime t = DateTime.Parse("2002-7-23"); "Select ab1 as 编号,ab2 as 名称,ab3 as 生产日期 from SHD2 where ab3='"+t.Date+"'"
"Select ab1 as 编号,ab2 as 名称,ab3 as 生产日期 from SHD2 where ab3='"+t+"'"
dt = DateTime.Parse(ds.Text)
Cmd=new OleDbDataAdapter("Select ab1 as 编号,ab2 as 名称,ab3 as 生产日期 from SHD2 where ab3='"+dt+"'",ConnStr);
建议对事件查询用时间短查询:
Cmd=new OleDbDataAdapter("Select ab1 as 编号,ab2 as 名称,ab3 as 生产日期 from SHD2 where ab3<'"+dt+"' and ab3>'"+dt1+"'",ConnStr);
祝你成功!
就可以运行.DateTime.Parse方法是不是还有一个指定格
式的参数?我的代码:private void Button3_Click(object sender, System.EventArgs e)//更新
{
String Provider,DataBase,ConnStr;
Provider="Microsoft.Jet.OLEDB.4.0;";
DataBase=Server.MapPath("mesh.mdb");
ConnStr="Provider="+Provider+"Data Source="+DataBase;
DateTime t = DateTime.Parse("2002-7-23");
string sql1="Select ab1 as 编号,ab2 as 名称,ab3 as 生产日期 from SHD2 where ab3='"+t+"'";
OleDbDataAdapter Cmd3; Cmd3=new OleDbDataAdapter(sql1,ConnStr);
DataSet ds=new DataSet();
Cmd3.Fill(ds,"SHD2");
DataGrid1.DataSource=ds.Tables["SHD2"].DefaultView;
DataGrid1.DataBind();
}
所以ACCESS数据库中字段要是设成短日期的话
你的用
DateTime t = DateTime.Parse("2002-7-23");
"Select ab1 as 编号,ab2 as 名称,ab3 as 生产日期 from SHD2 where ab3='"+t.Date+"'"
sql语句是一字符串。