如何在 C# 中创建已知列数和未知行数的数据表

发布于 2025-01-05 17:09:37 字数 882 浏览 0 评论 0原文

我有 60 列和未知行。我不断获取数据，例如 Current.Cursor.Position.X 和 Current.Cursor.Position.Y 以及其中的许多数据。所以不存在未知的行数。我想好好保存这些数据。我不想忙于数据库。我是这个话题的新手。我尝试将它们保存在文本文件中。我成功了，但这不是订单。我想把它安排得井井有条。什么是完美的解决方案？如果您能提供示例代码，这将有助于我更好地理解。

        System.Data.DataTable DT = new System.Data.DataTable();

        DT.Columns.Add( " 1 ");
        DT.Columns.Add("Column2");
        DT.Columns.Add("Column3");
        DT.Columns.Add("Column60");


           DT.Rows.Add(skeleton.Joints[JointID.Head].Position.X,skeleton.Joints[JointID.Head].Position.Y, skeleton.Joints[JointID.Head].Position.Z);


        foreach (DataRow row in DT.Rows)
        {

            StreamWriter fileWriter = new StreamWriter("table.csv",true);
            fileWriter.WriteLine(row[0].ToString() + row[1].ToString() + row[2].ToString());
            fileWriter.Close();

            }

原文

I have 60 columns and unknown rows. I'm getting the datas continuously such as Current.Cursor.Position.X and Current.Cursor.Position.Y and many of them. So there is no unknown numbers of rows. I want to save these datas nicely. I dont want to be busy with db. I'm new on this topic. I tried to save them in a text file. I was successfull, but that wasn't in a order. I want to make it in order. What could be the perfect solution for this? If you can provide example codes, It will be perfect for me to understand better.

        System.Data.DataTable DT = new System.Data.DataTable();

        DT.Columns.Add( " 1 ");
        DT.Columns.Add("Column2");
        DT.Columns.Add("Column3");
        DT.Columns.Add("Column60");


           DT.Rows.Add(skeleton.Joints[JointID.Head].Position.X,skeleton.Joints[JointID.Head].Position.Y, skeleton.Joints[JointID.Head].Position.Z);


        foreach (DataRow row in DT.Rows)
        {

            StreamWriter fileWriter = new StreamWriter("table.csv",true);
            fileWriter.WriteLine(row[0].ToString() + row[1].ToString() + row[2].ToString());
            fileWriter.Close();

            }

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

垂暮老矣 2025-01-12 17:09:37

这段代码应该可以帮助您开始

//create an instance of a table
System.Data.DataTable DT = new System.Data.DataTable();
//dynamically add columns
DT.Columns.Add("Column1");
DT.Columns.Add("Column2");
DT.Columns.Add("Column3");
.
.
.
DT.Columns.Add("Column60");

//this is how you add rows to it
DT.Rows.Add("val1", "val2", "val3",...."val60");

//this is how you retrieve it
foreach (DataRow row in DT.Rows)
{
   Console.Writeline(row[0].toString()); //returns the first column for each iteration
}

希望这对您有帮助..不要忘记投票

This code should get you starting

//create an instance of a table
System.Data.DataTable DT = new System.Data.DataTable();
//dynamically add columns
DT.Columns.Add("Column1");
DT.Columns.Add("Column2");
DT.Columns.Add("Column3");
.
.
.
DT.Columns.Add("Column60");

//this is how you add rows to it
DT.Rows.Add("val1", "val2", "val3",...."val60");

//this is how you retrieve it
foreach (DataRow row in DT.Rows)
{
   Console.Writeline(row[0].toString()); //returns the first column for each iteration
}

Hope this was helpful to you.. dont forget to vote up

回复收藏 0 原文

~没有更多了~