How Do I Read A Text Csv File Using Asp.Net

                //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);

                        }
                    }

                }