首页 > 代码库 > DataSet 动态添加列
DataSet 动态添加列
public DataSet GetNewId(List<string> IdArr) { DataSet ds = new DataSet(); DataTable newtb = new DataTable(); DataColumn column = new DataColumn("cnt", typeof(string));//新增列 newtb.Columns.Add(column); for (int i = 0; i < IdArr.Count; i++) { StringBuilder sbSql = new StringBuilder(); sbSql.Append("insert into y (PatientID,PathologyNumber,PatientState,Classification,HospitalOfDelivery,DepartmentOfDelivery,"+ " Remark8,CliMedicalID,MedicalClass,ImageCheck,ControlType from y where id=‘" + IdArr[i] + "‘; SELECT @@IDENTITY as id"); object o = DbHelperMySQL.GetSingle(sbSql.ToString()); if (o!=null) { DataRow newRow = newtb.NewRow(); newRow["cnt"] = o.ToString(); newtb.Rows.Add(newRow); } } ds.Tables.Add(newtb); return ds; }
DataSet 动态添加列
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。