现在的位置: 首页 > 综合 > 正文

GridView 选时间范围内的记录

2012年02月15日 ⁄ 综合 ⁄ 共 822字 ⁄ 字号 评论关闭
        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();

抱歉!评论已关闭.