如果当前时间加上7天大于数据库中的datetime类型的数据,那么选出这些记录。数据类型这样比较有错吗?为什么一点反应都没的
DateTime now=DateTime.Now;
private void button2_Click(object sender, System.EventArgs e)
{//查看
try
{
now.AddDays(7);
this.dataSet1.Clear(); string sql="select * from Meeting where MDate<='";
sql+=now;
sql+="'and Name='";
sql+="LoginPage.userName'";
this.sqlDataAdapter1.SelectCommand.CommandText=sql;
this.sqlDataAdapter1.SelectCommand.Connection=this.sqlConnection1;
this.sqlConnection1.Open();
this.sqlDataAdapter1.SelectCommand.ExecuteNonQuery();
this.sqlConnection1.Close();
this.sqlDataAdapter1.Fill(this.dataSet1,"Meeting");
this.dataGrid1.DataSource=this.dataSet1;
}
catch(Exception Err)
{MessageBox.Show(""+Err.Message,"",MessageBoxButtons.OK,MessageBoxIcon.Information);
if(this.sqlConnection1.State==ConnectionState.Open)
this.sqlConnection1.Close();
}
}
DateTime now=DateTime.Now;
private void button2_Click(object sender, System.EventArgs e)
{//查看
try
{
now.AddDays(7);
this.dataSet1.Clear(); string sql="select * from Meeting where MDate<='";
sql+=now;
sql+="'and Name='";
sql+="LoginPage.userName'";
this.sqlDataAdapter1.SelectCommand.CommandText=sql;
this.sqlDataAdapter1.SelectCommand.Connection=this.sqlConnection1;
this.sqlConnection1.Open();
this.sqlDataAdapter1.SelectCommand.ExecuteNonQuery();
this.sqlConnection1.Close();
this.sqlDataAdapter1.Fill(this.dataSet1,"Meeting");
this.dataGrid1.DataSource=this.dataSet1;
}
catch(Exception Err)
{MessageBox.Show(""+Err.Message,"",MessageBoxButtons.OK,MessageBoxIcon.Information);
if(this.sqlConnection1.State==ConnectionState.Open)
this.sqlConnection1.Close();
}
}
解决方案 »
- C#如何将MySql里面的gbk_chinese_ci编码的字符串转换成utf-8啊?
- System.Transactions.TransactionException: 该伙伴事务管理器已经禁止了它对远程/网络事务的支持。
- c#中注册时遇到的问题?在线等
- 关于继承中方法调用顺序的疑问
- 新手请教:抽象类|构造函数,谢谢!
- user Control 和customer user control 的问题
- C# winfrom 控件切换改变背景颜色
- sqlserver2005中的数据库连接问题
- [DllImport("EastRiver.dll")]请问那位大佬有用过像这样的DLL引用,为何返回值为msg为空值。。
- 用webbrowser模拟登陆天涯发帖时,radiobutton控件问题
- 关于 statusStrip 的问题
- C#中关于数据库操作的问题
private void button2_Click(object sender, System.EventArgs e)
{//查看
try
{
now.AddDays(7); 改成now=addDays(7);
this.dataSet1.Clear(); string sql="select * from Meeting where MDate<='";
sql+=now; //改成sql+=now.toString();
sql+="'and Name='";
sql+="LoginPage.userName'";
select * from Meeting where MDate<=DateAdd(7,day,getdate())