GridView显示问题一表存储表头一表存储列值-优快云博客

本文介绍了一种方法，通过使用C#编程将两个SQL查询结果集的数据合并到一个DataTable对象中，并实现了数据的初步处理和整理。

new 一个DataTable，把两表的中数据合并，放到datatable中。

       string sql = "select * from MZ_FPXM";
        SqlDataReader sdr = null;
        SqlDataReader sdr2 = null;
        DataTable dt = new DataTable();
        DataRow dr = null;
        using (sdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, null))
        {
            dt.Columns.Add("科室", typeof(System.String));
            while (sdr.Read())
            {
                dt.Columns.Add(new DataColumn(sdr["MC"].ToString(), typeof(System.Decimal)));
            }
            dt.Columns.Add(new DataColumn("发票张数", typeof(System.String)));
            dt.Columns.Add(new DataColumn("人次", typeof(System.String)));
            dt.Columns.Add(new DataColumn("合计", typeof(System.Decimal)));

            sum = new double[dt.Columns.Count];
             
            SqlParameter[] parms = new SqlParameter[]{
            new SqlParameter("@YYID",yybh),
            new SqlParameter("@KSBH","ALL"),
            new SqlParameter("@RQFR",ksrq),
            new SqlParameter("@RQTO",jsrq)
             };
            using (sdr2 = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "PROC_MZKSGZL", parms))
            {

                DataView dv = dt.DefaultView;
                dv.Sort = "科室";
                while (sdr2.Read())
                {
                    int rowIndex = dv.Find(sdr2["KS"].ToString());
                    if (rowIndex == -1)
                    {
                        dr = dt.NewRow();
                        dr["科室"] = sdr2["KS"].ToString();
                        if (sdr2["SFLB"].ToString() == "西药")
                            dr[sdr2["SFLB"].ToString() + "费"] = Math.Round(decimal.Parse(sdr2["JE"].ToString()), 2);
                        else
                            dr[sdr2["SFLB"].ToString()] = Math.Round(decimal.Parse(sdr2["JE"].ToString()), 2);
                        dr["发票张数"] = Math.Round(decimal.Parse(sdr2["SJZS"].ToString()), 2);
                        dr["人次"] = Math.Round(decimal.Parse(sdr2["RC"].ToString()), 2);
                        dr["合计"] = Math.Round(decimal.Parse(sdr2["ZJJE"].ToString()), 2);
                        dt.Rows.Add(dr);
                    }
                    else
                    {
                        if (sdr2["SFLB"].ToString() == "西药")
                            dt.Rows[rowIndex][sdr2["SFLB"].ToString() + "费"] = Math.Round(decimal.Parse(sdr2["JE"].ToString()), 2);
                        else
                            dr[sdr2["SFLB"].ToString()] = Math.Round(decimal.Parse(sdr2["JE"].ToString()), 2);
                    }
                }
            }

        }
        gvInfo.DataSource = dt;
        gvInfo.DataBind();