GridView 选时间范围内的记录

        string strConn = ConfigurationManager.ConnectionStrings["MyBlogConnectionString"].ToString();
        strConn = "server=(local);database=MyBlog;User Id=sa;pwd=sa;";
        SqlConnection conn = new SqlConnection(strConn);
        
        string strSql = @"select *
                        from JoinUser
                        where JoinTime>=@time1 and JoinTime<=@time2";
        
        SqlCommand comm = new SqlCommand(strSql,conn);
        DateTime time1=DateTime.Parse(DropDownList1.SelectedValue.ToString());
        DateTime time2=DateTime.Parse(DropDownList2.SelectedValue.ToString());
        comm.Parameters.AddWithValue("@time1", time1);
        comm.Parameters.AddWithValue("@time2",time2);
        SqlDataAdapter da = new SqlDataAdapter(comm);
        DataTable dt = new DataTable();
        da.Fill(dt);
        GridView2.DataSource = dt;
        GridView2.DataBind();

转载于:https://www.cnblogs.com/lishenglyx/archive/2008/09/10/1288011.html