select * from 表名 where Date(字段名) BETWEEN CONVERT(DATETIME, '2005-1-1', 102) AND CONVERT(DATETIME'2005-2-1', 102)+1)
select * from database where datefield > to_date('yyyy-mm-dd',startdate) and datefield <to_date ('yyyy-mm-dd',enddate) ---对于oracle的
建两个TextBox. string str = String.Format("select * from table where age>= {0} and age <= {1}Textbox1.Text,Textbox2.Text); 在TextBox中写日期。
oracle需要to_date() sqlserver就不用了string sql = "select * from table where 1=1"; if (条件满足) sql += String.Format(" AND Column > {0} AND column < '{1}'.....",int,string.......); if (条件满足) sql += String.Format(" AND .........);
string str = String.Format("select * from table where age>= {0} and age <= {1}Textbox1.Text,Textbox2.Text);
在TextBox中写日期。
sqlserver就不用了string sql = "select * from table where 1=1";
if (条件满足)
sql += String.Format(" AND Column > {0} AND column < '{1}'.....",int,string.......);
if (条件满足)
sql += String.Format(" AND .........);