C# DataTable 自动新增列并赋值

 public void UploadInfo(DataTable input, string tableName){try{//动态添加列到datatable中input.Columns.Add("id", typeof(Int64));input.Columns["id"].SetOrdinal(0);//状态statusinput.Columns.Add("status", typeof(Int64));input.Columns["status"].SetOrdinal(1);//操作人idinput.Columns.Add("operatorid", typeof(string));input.Columns["operatorid"].SetOrdinal(2);//循环添加到表的列for (int i = 0; i < input.Rows.Count; i++){input.Rows[i][0] = "123456";input.Rows[i][1] = "1";input.Rows[i][2] = "2002";}//这个方法参考下面的超链接DataTableToInsertSql(input, tableName);}catch (Exception ex){}}

DataTableToInsertSql方法超链接