DataTable 导出excel 更新列名或者删除部分列.pdf

DataView dataList = saBatteryHelper.GetSaBatteryList(condition, "PAGE", Int32.Parse(string.IsNullOrEmpty(Imagebutton2.ToolTip) ? "0" : Imagebutton2.ToolTip), this.dg_detail.PageSize, ref total_page, ref total_rec); if (dataList.Table.Columns.Contains("ROW_ID")) dataList.Table.Columns.Remove("ROW_ID"); if (dataList.Table.Columns.Contains("LAST_UPDATED_BY")) dataList.Table.Columns.Remove("LAST_UPDATED_BY"); if (dataList.Table.Columns.Contains("LAST_UPDATE_DATE")) dataList.Table.Columns.Remove("LAST_UPDATE_DATE"); if (dataList.Table.Columns.Contains("CREATED_BY")) dataList.Table.Columns.Remove("CREATED_BY"); if (dataList.Table.Columns.Contains("RELATIONSHIPID")) dataList.Table.Columns["RELATIONSHIPID"].ColumnName = "SA";