62,025
社区成员
发帖
与我相关
我的任务
分享
//数组类似于 11,12,13,14,21,22,23,24,31,32,33,34,。。。。121,122,123,124
#region "转我要的Datatable"
public System.Data.DataTable StoTable(string[] ss,string Tname)
{
System.Data.DataTable Mydt = new System.Data.DataTable(Tname);
string[] KType = { "prior year", "budget", "forecast", "actual" };
// string[] Col = { "KPI Type", "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" };
Mydt.Columns.Add("KPI Type");
Mydt.Columns.Add("Jan");
Mydt.Columns.Add("Feb");
Mydt.Columns.Add("Mar");
Mydt.Columns.Add("Apr");
Mydt.Columns.Add("May");
Mydt.Columns.Add("Jun");
Mydt.Columns.Add("Jul");
Mydt.Columns.Add("Aug");
Mydt.Columns.Add("Sep");
Mydt.Columns.Add("Oct");
Mydt.Columns.Add("Nov");
Mydt.Columns.Add("Dec");
//int i = 0;
for (int J = 0; J < KType.Length; J++)
{
DataRow Dr = Mydt.NewRow();
Dr[0]=KType[J];
int B = 1;
for (int Ind = J; Ind < ss.Length; Ind = Ind + 4)
{
Dr[B] = ss[Ind];
B = B + 1;
}
Mydt.Rows.Add(Dr);
}
//System.Data.DataTable dd = Mydt;
//string bb = "0";
return Mydt;
}
#endregion
private void Form1_Load(object sender, EventArgs e)
{
//遍历添加到Table中
DataTable dt = new DataTable();
for (int i = 0; i < ColumnsList.Length; i++)
{
string[] templist = ColumnsList[i].Split('|');
if (templist.Length != 2) continue;
dt.Columns.Add(templist[1].Trim(), typeof(string));
}
dt.AcceptChanges();
for (int i = 0; i < 4; i++)
{
DataRow dr = dt.NewRow();
for (int j = 0; j < ColumnsList.Length; j++)
{
string[] templist = ColumnsList[j].Split('|');
if (templist.Length != 2) continue;
dr[templist[1].Trim()] = dataList[i, j].Trim();
}
dt.Rows.Add(dr);
}
dt.AcceptChanges();
this.dataGridView1.DataSource = dt;
}
private string[] ColumnsList = {
"序号|rowid","主帐户|masteraccount","主帐号|childaccount","卡号|cardno",
"户名|name","客户号|crmid","科目号|stocktype",
"原金额|orgincount","发生额|currcount","新金额|newcount","状态|state"
};
private string[,] dataList = {
{"1","6624885718651234","000001","057400000000000001","张三风","32240001","805001","100","1","101","正常"},
{"2","6624885718651234","000002","057400000000000002","张三风","32240002","805001","1000","94","1094","正常"},
{"3","6624885718651234","000003","057400000000000003","张三风","32240003","805001","109","9","118","挂失"},
{"4","6624885718651234","000004","057400000000000004","张三风","32240004","805001","234","5","239","注销"},
};
string txtp = "aaa bbb ccc ddd eee";
string[] str = txtp.Split(new char[] { ' ' });
//创建一个表的对象
DataTable dt = new DataTable("Number");
//创建一个列的对象,并把列放入datatable
DataColumn dc = dt.Columns.Add("ID",typeof(string));
//创建行向表中填充数据
DataRow dr;
for (int i = 0; i < str.Length; i++)
{
dr = dt.NewRow();
dr["ID"] = str[i];
dt.Rows.Add(dr);
}