.NET读取Text保存为DataSet的解决办法

最新推荐文章于 2022-10-16 19:07:43 发布

洪十二

最新推荐文章于 2022-10-16 19:07:43 发布

阅读量1.1k

点赞数

分类专栏： .NET 文章标签： dataset .net string file object

本文链接：https://blog.csdn.net/marvinhong/article/details/994274

版权

.NET 专栏收录该内容

75 篇文章 1 订阅

订阅专栏

        private void btnReader_Click(object sender, EventArgs e)
        {
            ds = Convert(@"E:/MSNData/material.txt", "material", "/t");
        }

//转换函数

        private static DataSet Convert(string File, string TableName, string delimiter)
        {
            DataSet result = new DataSet();
            StreamReader s = new StreamReader(File);
            string[] columns = s.ReadLine().Split(delimiter.ToCharArray());

            result.Tables.Add(TableName);
            foreach (string col in columns)
            {
                bool added = false;
                string next = "";
                int i = 0;
                while (!added)
                {
                    string columnname = col;
                    columnname = columnname.Replace("#", "");
                    columnname = columnname.Replace("'", "");
                    columnname = columnname.Replace("&", "");
                    if (!result.Tables[TableName].Columns.Contains(columnname))
                    {
                        result.Tables[TableName].Columns.Add(columnname);
                        added = true;
                    }
                    else
                    {
                        i++;
                        next = "_" + i.ToString();
                    }
                }
            }

            string AllData = s.ReadToEnd();
            string[] rows = AllData.Split("/r/n".ToCharArray());

            foreach (string r in rows)
            {
                if (r.Length > 0)
                {
                    string[] items = r.Split(delimiter.ToCharArray());
                    result.Tables[TableName].Rows.Add(items);
                }
            }
            return result;
        }

//delimiter定义说明