linq 报错 求教

Question

    private static DataClasses2DataContext dc;        private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
        {
            label1.Text = "";
            dc = new DataClasses2DataContext();
            DateTime today = DateTime.Parse(DateTime.Now.ToShortDateString());
            var results = from p in dc.library
                          where System.Data.Linq.SqlClient.SqlMethods.DateDiffDay(Convert.ToDateTime(p.time.ToString()),today)>=0
                          //where Convert.ToDateTime( p.time)<=today
                          select p;
            foreach (library row in results)
                label1.Text += row.time.ToString()+"\n" + row.name.ToString() + row.book.ToString()+"\n";
           
        }
  那个time 字段datetime 类型 在where 里比较他与当前时间时报错无法将类型为“System.DateTime”的对象强制转换为类型“System.String”

Answer 1

System.Data.Linq.SqlClient.SqlMethods.DateDiffDay(p.time,DateTime.Now)==0

Answer 2

刚试了 还是有问题 无法转化string 到datatime