/// <summary>
/// object二维数组转换为DataTable
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static DataTable objectTwoDimensionToDataTable(object[,] obj)
{
if(!obj.HasValue())
{
return null;
}
try
{
DataTable dt = new DataTable();
for (int i = 0; i < obj.GetLength(1); i++)
{
DataColumn col = new DataColumn(i.ToString(), typeof(object)); //列名默认为0,1,2.....
dt.Columns.Add(col);
}
for (int i = 0; i < obj.GetLength(0); i++)
{
DataRow row = dt.NewRow();
for (int j = 0; j < obj.GetLength(1); j++)
{
row[j] = obj[i, j];
}
dt.Rows.Add(row);
}
return dt;
}
catch(Exception e)
{
Debug.WriteLine(string.Format("objToDataTable错误,消息:{0}", e.Message));
return null;
}
}
dt.Columns.Add("num", typeof(int)).SetOrdinal(0); //插入序号列
for (int i = 0; i < dt.Rows.Count ; i++)
{
dt.Rows[i]["num"] = i + 1;
}