导入CSV 至DataSet or DataTable or SQL

Question

     如题   csv的数据可能有几千条  网上找的怕他会漏掉数据
  朋友们有 用过没有遗漏的 代码么、。？ 共享下  谢谢

Answer 1

 string filename = "";
        filename = Server.MapPath(filename);       StreamWriter write = new StreamWriter(filename, true, System.Text.Encoding.UTF8);
        using(SqlConnection con = new SqlConnection (""))
       { 
        SqlCommand cmd = new SqlCommand ("Select * from Table",con);
        SqlDataReader read = cmd.ExecuteReader(); 
        while (read.Read()) 
        { 
          write.WriteLine(read[0] + "," + read[1] +"," + read[2]); 
        } 
        write.Flush();
        write.Close();
       }
 //或        Response.Clear();
        Response.ClearHeaders();
        System.IO.FileInfo fi = new FileInfo(filename);
        Response.ContentType = "application/octet-stream";
        Response.AppendHeader("Content-Disposition", "attachment;filename= " + HttpUtility.UrlEncode(fi.FullName, System.Text.Encoding.UTF8));
        Response.AppendHeader("Content-Length ", fi.Length.ToString());
        Response.WriteFile(fi.FullName);
        Response.Flush();
        Response.End();