C# DataTable 自动新增列并赋值

 public void UploadInfo(DataTable input, string tableName)
        {
            try
            {
                //动态添加列到datatable中
                input.Columns.Add("id", typeof(Int64));
                input.Columns["id"].SetOrdinal(0);

                //状态status
                input.Columns.Add("status", typeof(Int64));
                input.Columns["status"].SetOrdinal(1);

                //操作人id
                input.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方法超链接