SqlDataAdapter my = new SqlDataAdapter("SELECT * FROM tblFinish WHERE RecordTime<'Convert.ToDateTime(TextBox4.Text)' AND RecordTime>='Convert.ToDateTime(TextBox3.Text)'", sqlconn);
这句话出错,该怎么改呢??赐教!!
这句话出错,该怎么改呢??赐教!!
然后在sql语句中用@times表示他!试试看吧!
SqlDataAdapter my = new SqlDataAdapter("SELECT * FROM tblFinish WHERE RecordTime<'"+TextBox4.Text.Trim()+"' AND RecordTime>='"+TextBox3.Text.Trim()+"';", sqlconn);t-sql中的日期表示是看作字符串的
TextBox4.Text的日期格式:2005-2-26
只要TextBox4.Text日期格式写正确,这个语句一定能执行