DataTable 修改行的指定值NE

DataTable 修改行的指定值

    public DataTable DepartmentDiseaseCharts()
        {
            DataTable dt = new DataTable();
            using (ServiceController.EF.MSISEntities context = new ServiceController.EF.MSISEntities())
            {
                context.Database.CommandTimeout = 9999;
                string theCondition1 = "";
                string theSQL = String.Format(@"WITH T AS (
SELECT DISTINCT DepartmentCode FROM dbo.Disease WHERE  DepartmentCode !='')
SELECT COUNT(Id) AS DiseaseCount,D.DepartmentCode FROM dbo.Disease D INNER  JOIN T ON T.DepartmentCode = D.DepartmentCode
GROUP BY D.DepartmentCode", theCondition1);
                var testCommand = new SqlCommand(theSQL, (SqlConnection)context.Database.Connection);
                SqlDataAdapter adapterd = new SqlDataAdapter(testCommand);
                adapterd.Fill(dt);

            }
//前边只有两列，添加一列DepartmentName
            dt.Columns.Add("DepartmentName", typeof(string)); //数据类型为 文本
            for (int i = 0; i < dt.Rows.Count-1; i++)
            {
                string code = dt.Rows[i].ItemArray[1].ToString();

                var list = MDMDataService.GetOrgInfoByWord(code).Select(
              t =>
              new Department()
              {
                  Code = t.SubOrgCode,
                  Name = t.SubOrgName,
                  OrgName = t.SubOrgName,
                  ParentOrgCode = t.ParentOrgCode,
                  ParentOrgName = t.ParentOrgName
              }).ToList();
//修改制定行的第三个字段，然后赋值
                DataRow drEmployee = dt.Rows[i];
                drEmployee.BeginEdit();
                drEmployee["DepartmentName"] = string.IsNullOrEmpty(list[0].Name.ToString())?"暂无": list[0].Name.ToString();
                drEmployee.EndEdit();

            }

            return dt;
        }

前台显示打印出来的结果