ADO.Net 按日期查询

using (SqlDataAdapter adapter = new SqlDataAdapter()) //强力推荐Using块，即便异常也可以自动释放内存

{

      try

       {

             adapter.SelectCommand.Connection = new SqlConnection("数据库连接字符串");

             string sql = "select * from xxx where"     //这里可以是用inner join组合的

             if(Dropdownlist1.SelectedItem.Text=="日期")

            {

                     s+=" 日期='"+TextBox1.Text+"'";

            }
            else   if(Dropdownlist1.SelectedItem.Text=="地址")

                {

                   s+=" 地址='"+TextBox1.Text+"'";

                }
             else if(Dropdownlist1.SelectedItem.Text=="地址")

               {

                 s+=" 合同号='"+TextBox1.Text+"'";

                }

            DataTable dt = new DataTable();

             adapter.SelectCommand.CommandText = sql;

            adapter.Fill(dt);

             GridView1.DataSource = dt;

             GridView1.DataBind();

       }

                catch(Exception exp)

                 {

                      Response.Write(exp.Message);

                 }

}