将今天与数据库中的某个日期比较,然后将比较结果小于某个天数的记录绑定到datagrid上。

  public DataSet RemindManMoney(int dates)
  {
   DataSet objSet=new DataSet();
   objConnection.Open();
   string sql="select * from TUserCard where CIsManPay='否' and DateDiff(day,GETDATE(),CManDate)<="+dates;
   SqlDataAdapter objSda = new SqlDataAdapter(sql,objConnection);
   objSda.Fill(objSet,"TUserCard");
   objConnection.Close();
   return objSet;
  }

private void ddldate_SelectedIndexChanged(object sender, System.EventArgs e)
  {
        int dates=0;
        if(ddldate.SelectedItem.Value=="threedates")
       {
           dates=3;
       }
       if(ddldate.SelectedItem.Value=="sevendates")
       {
         dates=7;
       }
      BindManMoney(dates);
  }

  protected void BindManMoney(int dates )
  {
   
   DataSet objSet=objCard.RemindManMoney(dates);
   dgremindman.DataSource=objSet.Tables["TUserCard"].DefaultView;
   dgremindman.DataBind();

  }