DateTime starTime = Convert.ToDateTime(dropyear.SelectedItem.Text + "-" + dropmonth.SelectedItem.Text + "-" + "1");//2010-7-1 00:00:00
DateTime endTime = Convert.ToDateTime(DropDownList1.SelectedItem.Text + "-" + DropDownList2.SelectedItem.Text + "-" + "1");//2010-7-1 00:00:00
string strsql = "select * from Tb_gongzi where addtime between '" + starTime + "' and '" + endTime + "'";
//string strsql = "select * from Tb_gongzi where realname='" + txtname.Value + "' and cardNO='" + txtcardid.Value + "' and addtime between '" + starTime + "' and '" + endTime + "'";//2010-07-10 12:00:00 OleDbDataReader dr = AceessHelper.ExecuteReader(strsql);
DateTime endTime = Convert.ToDateTime(DropDownList1.SelectedItem.Text + "-" + DropDownList2.SelectedItem.Text + "-" + "1");//2010-7-1 00:00:00
string strsql = "select * from Tb_gongzi where addtime between '" + starTime + "' and '" + endTime + "'";
//string strsql = "select * from Tb_gongzi where realname='" + txtname.Value + "' and cardNO='" + txtcardid.Value + "' and addtime between '" + starTime + "' and '" + endTime + "'";//2010-07-10 12:00:00 OleDbDataReader dr = AceessHelper.ExecuteReader(strsql);
解决方案 »
- A为n行n列二维数组,如何删除第i行第j列,使A变为n-1行n-1列的二维数组
- 高分 求c#+sql 的好书(有vs2005实例)
- 从非托管代码向托管代码的转化问题
- 请问在哪里下载 msdn 2005 ?
- 大哥们,小弟刚刚涉足ASP.NET 遇到一个很棘手的问题,求求你们了 帮帮我吧
- 托管 EE 不理解表达式的语法??
- 在用formula one,用到读excel文件时,参数变量类型我在c#中不知道用哪种,用过的兄弟进来看一下。谢谢
- 简单问题 我知道WINFORM下控件的ID的字符串,如何找到该控件
- 自动生成入库单号。怎么写啊。我刚学
- 今天生日,散分,同乐!!!
- 大牛帮忙看看这个gridview~~
- StreamReader只能读文件的第一行
结贴 。。
汗,access中时间段得加上#号