62,046
社区成员
发帖
与我相关
我的任务
分享
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Row"));
dt.Columns.Add(new DataColumn("Col"));
dt.Columns.Add(new DataColumn("Value"));
StreamReader reader = new StreamReader("txt.txt");
//行数
int maxRow = 0;
//列数
int maxCol = 0;
string line = null;
//读取txt文件
while ((line = reader.ReadLine()) != null)
{
string[] fields = line.Split(new char[] { ',' });
int col = int.Parse(fields[0]);
string[] inRow = fields[1].Split('-');
int row = int.Parse(inRow[0]);
string Value = inRow[1] + "," + fields[2];
if (col > maxCol)
{
maxCol = col;
}
if (row > maxRow)
{
maxRow = row;
}
//添加一行数据,格式:所在行、所在列、单元格值
dt.Rows.Add(new object[] { row, col, Value });
}
DataTable dtSoruce = new DataTable();
//根据maxCol值添加列
object[] obj = new object[maxCol];
for (int iCol = 0; iCol < maxCol; iCol++)
{
obj[iCol] = "";
dtSoruce.Columns.Add(new DataColumn("C" + iCol.ToString()));
}
//添加行,每行所有单元格赋空("")值
for (int i = 0; i < maxRow; i++)
{
dtSoruce.Rows.Add(obj);
}
//遍历dt表根据行值、列值给dtSource表单元格赋值
//注意使用索引时值-1
foreach (DataRow dr in dt.Rows)
{
dtSoruce.Rows[int.Parse(dr[0].ToString()) - 1][int.Parse(dr[1].ToString()) - 1] = dr[2].ToString();
}
dtSoruce.AcceptChanges();
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Row"));
dt.Columns.Add(new DataColumn("Col"));
dt.Columns.Add(new DataColumn("Value"));
StreamReader reader = new StreamReader("txt.txt");
int maxRow = 0;
int maxCol = 0;
string line = null;
while ((line = reader.ReadLine()) != null)
{
string[] fields = line.Split(new char[] { ',' });
int col = int.Parse(fields[0]);
string[] inRow = fields[1].Split('-');
int row = int.Parse(inRow[0]);
string Value = inRow[1]+","+fields[2];
if (col > maxCol)
{
maxCol = col;
}
if (row > maxRow)
{
maxRow = row;
}
dt.Rows.Add(new object[] {row,col,Value });
}
DataTable dtSoruce = new DataTable();
object[] obj = new object[maxCol];
for(int iCol=0;iCol<maxCol;iCol++)
{
obj[iCol] = null;
dtSoruce.Columns.Add(new DataColumn("C"+iCol.ToString()));
}
for (int i = 0; i < maxRow; i++)
{
dtSoruce.Rows.Add(obj);
}
foreach (DataRow dr in dt.Rows)
{
dtSoruce.Rows[int.Parse(dr[0].ToString())][int.Parse(dr[1].ToString())] =dr[2].ToString();
}
foreach (DataRow dr in dtSoruce.Rows)
{
this.textBox1.Text += dr[0].ToString();
}
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("No",typeof(int)));
dt.Columns.Add(new DataColumn("Code",typeof(string)));
dt.Columns.Add(new DataColumn("Taxis",typeof(int)));
StreamReader reader = new StreamReader("txt.txt");
string line = null;
while ((line = reader.ReadLine()) != null)
{
string[] fields = line.Split(new char[] { ',' });
dt.Rows.Add(new object[] { int.Parse(fields[0]), fields[1], int.Parse(fields[2]) });
}
MessageBox.Show(dt.Rows.Count.ToString());
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("No"));
dt.Columns.Add(new DataColumn("Code"));
dt.Columns.Add(new DataColumn("Taxis"));
StreamReader reader = new StreamReader("txt.txt");
while (reader.Read()!=-1)
{
string[] fields = reader.ReadLine().Split(',');
dt.Rows.Add(new object[] { fields[0], fields[1], fields[2] });
}
MessageBox.Show(dt.Rows.Count.ToString());