如何使用Asp.Net读取文本Csv文件 [英] How Do I Read A Text Csv File Using Asp.Net

问题描述

我如何阅读文本csv文件并使用Asp.net存储在表格中





plzz帮助我..



数据很大

how do i read a text csv file and store in table using Asp.net


plzz help me ..

well the data is large

推荐答案

请参阅：



用C＃读取和写入CSV文件 [ ^ ]

在.NET中读取CSV文件？ [ ^ ]

如何从c＃中读取csv文件中的数据 [ ^ ]

使用C＃读取CSV文件 [ ^ ]



祝你好运。

Please Refer :

Reading and Writing CSV Files in C#[^]
Reading CSV files in .NET?[^]
How to read data from csv file in c#[^]
Read CSV file using C#[^]

Good luck.

查看此链接。在处理之前请记住，您需要将文件上传到网络服务器。



使用C＃读取CSV文件 [ ^ ]



http://www.c-sharpcorner.com/UploadFile/d3e4b1/saving-reading-uploading-downloading-mechanism-of- csv-fil / [ ^ ]

check this link's. Remember before you process you need to upload the file to web server.

Read CSV file using C#[^]

http://www.c-sharpcorner.com/UploadFile/d3e4b1/saving-reading-uploading-downloading-mechanism-of-csv-fil/[^]

                //Step -1) Read the file from local  and save to Datatable 


                DataTable dt = new DataTable();
                string line = null;
                int i = 0;

                //Pass the file  
                using (StreamReader sr = File.OpenText(Server.MapPath("~/temp/table1.csv")))
                {
                    //Read line by line from CSV file
                    //Save the line to  string  and check for null
                    while ((line = sr.ReadLine()) != null)
                    {
                        //If not null then split with "," comma
                        string[] data = line.Split(',');
                        if (data.Length > 0)
                        {
                            //if Array length is >0  and at initial value first add column to datatable
                            if (i == 0)
                            {
                                foreach (var item in data)
                                {
                                    dt.Columns.Add(new DataColumn());
                                }
                                i++;
                            }
                            //Create DataRow  instance 
                            DataRow row = dt.NewRow();
                            //save all array to DataRow ItemArray collection
                            row.ItemArray = data;

                            dt.Rows.Add(row);
                        }
                    }
                }


//Step-2 ) If DataTable is not null then insert this Datatable to Database using BulkCopy
       
          //After saving csv file to DataTable  insert data using SqlBulkCopy
                if (dt != null && dt.Rows.Count > 0)
                {

                    using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlBulkCopy"].ConnectionString))
                    {
                        cn.Open();
                        using (SqlBulkCopy copy = new SqlBulkCopy(cn))
                        {

                            copy.ColumnMappings.Add(0, 1);
                            copy.ColumnMappings.Add(1, 2);
                            copy.ColumnMappings.Add(2, 3);
                            copy.ColumnMappings.Add(3, 4);
                            copy.ColumnMappings.Add(4, 5);

                            copy.DestinationTableName = "tablename";
                            copy.WriteToServer(dt);

                        }
                    }

                }

这篇关于如何使用Asp.Net读取文本Csv文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！