asp.net sqlparameter,dataset合并排序的用法

 private void getData()
        {
            #region
            SqlConnection sqlconn= new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
            SqlCommand cmd = new SqlCommand("select * from open_report, student_login where open_report.studentNum "
+"= student_login.studentNum and open_report.Id = @openID",sqlconn);
            SqlParameter openID = new SqlParameter("@openID", Request.QueryString["openID"].ToString());
            cmd.Parameters.Add(openID);
            SqlDataAdapter sqlAdp = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            sqlAdp.Fill(ds);
            LabStuID.Text=ds.Tables[0].Rows[0]["studentNum"].ToString();
            labName.Text = ds.Tables[0].Rows[0]["studentName"].ToString();
            labTitle.Text=ds.Tables[0].Rows[0]["reportTitle"].ToString();
            linkDownload.NavigateUrl=ds.Tables[0].Rows[0]["attachFilePath"].ToString();
            labTime.Text = ds.Tables[0].Rows[0]["uploadTime"].ToString();
            switch(ds.Tables[0].Rows[0]["passState"].ToString().Trim())
            {
                case "0":
                    labState.Text = "审核中";
                    break;
                case "1":
                    labState.Text = "审核未通过";
                    break;
                case "2":
                    labState.Text = "审核通过";
                    break;
            }
            #endregion
            #region 获得留言内容
            cmd.CommandText = "select studentName as StudentName,replyTime as LeaveMessageTime,replyContent"+
" as Content from open_reply,student_login where senderNum=studentNum and open_id = @openID";
            SqlDataAdapter sqlAdp1 = new SqlDataAdapter(cmd);
            DataSet ds1 = new DataSet();
            sqlAdp1.Fill(ds1);
            cmd.CommandText = "select teacher_Name as TeacherName,replyTime as LeaveMessageTime, "+
"replyContent as Content from open_reply,teacher_detail where senderNum=teacher_Id and open_id = @openID";
            SqlDataAdapter sqlAdp2 = new SqlDataAdapter(cmd);
            DataSet ds2 = new DataSet();
            sqlAdp2.Fill(ds2);
            ds1.Merge(ds2);
            DataView dv = new DataView();
            dv.Table = ds1.Tables[0];
            dv.Sort = "LeaveMessageTime desc";
            GridView1.DataSource = dv;
            GridView1.DataBind();
            #endregion
        }
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值