数组转DataTable
/// <summary>
/// 获取KEY
/// </summary>
/// <returns></returns>
private string[][] GetKey(string[,] arr)
{
string[][] key = new string[arr.GetLength(0)][];
//for (int i = 0; i < arr.GetLength(0); i++)
//{
// key[i] =new string [arr.GetLength(1)];
// for (int j = 0; j < arr.GetLength(1); j++)
// {
// key[i][j] = arr[i, j];
// }
//}
key[0] = new string[4];
key[0][0] = "key";
key[0][1] = "item";
key[0][2] = "type";
key[0][3] = "other";
key[1] = new string[4];
key[1][0] = "1";
key[1][1] = "sell-in";
key[1][2] = "in";
key[1][3] = "aa";
key[2] = new string[4];
key[2][0] = "2";
key[2][1] = "sell-out";
key[2][2] = "out";
key[2][3] = "bb";
return key;
}
/// <summary>
/// 获取数据
/// </summary>
/// <returns></returns>
private string[][] GetData()
{
string[][] data = new string[6][];
data[0] = new string[5];
data[0][0] = "FCT";
data[0][1] = "FCT";
data[0][2] = "FCT";
data[0][3] = "FCT";
data[0][4] = "FCT";
data[1] = new string[5];
data[1][0] = "201801";
data[1][1] = "201802";
data[1][2] = "201803";
data[1][3] = "201804";
data[1][4] = "201805";
data[2] = new string[5];
data[2][0] = "2018-1-1";
data[2][1] = "2018-1-1";
data[2][2] = "2018-1-1";
data[2][3] = "2018-1-1";
data[2][4] = "2018-1-1";
data[3] = new string[5];
data[3][0] = "2018-1-1";
data[3][1] = "2018-1-8";
data[3][2] = "2018-1-15";
data[3][3] = "2018-1-22";
data[3][4] = "2018-1-29";
data[4] = new string[5];
data[4][0] = "123";
data[4][1] = "234";
data[4][2] = "345";
data[4][3] = "456";
data[4][4] = "567";
data[5] = new string[5];
data[5][0] = "333";
data[5][1] = "444";
data[5][2] = "555";
data[5][3] = "666";
data[5][4] = "777";
return data;
}
//以上数组 想转成 以下DataTable
key item type other dataType DataWeek DataMonth DataDate qty
1 sell-in in aa fct 201801 Jan-18 2018-1-1 123
1 sell-in in aa fct 201802 Jan-18 2018-1-8 234
1 sell-in in aa fct 201803 Jan-18 2018-1-15 345
1 sell-in in aa fct 201804 Jan-18 2018-1-22 456
1 sell-in in aa fct 201805 Feb-18 2018-1-29 567
2 sell-out out bb fct 201801 Jan-18 2018-1-1 333
2 sell-out out bb fct 201802 Jan-18 2018-1-8 444
2 sell-out out bb fct 201803 Jan-18 2018-1-15 555
2 sell-out out bb fct 201804 Jan-18 2018-1-22 666
2 sell-out out bb fct 201805 Feb-18 2018-1-29 777
...全文
相关推荐
Datatable转实体数组
Datatable转实体数组,人民币转换、重量转换、 转大写、数据集合转换,将数字转化为大写
C#的Json操作类,支持数组,DataTable,DataReader等转Json
C#的Json操作类,支持数组,DataTable,DataReader等转Json
C# 维数组转换为DataTable 的三个方法
C# 维数组转换为DataTable 的三个方法 来了解用C# 操作excel数据转变到dataset 进而到datatable的方式
DataTable转Excel
datatable转Excel
把实体类数组转换为DataTable C#
把实体类数组转换为DataTable C#



