C# 读取TXT文本数据 添加到数据库

protected void Button1_Click(object sender, EventArgs e)
     {
         //使用FileStream读取文件  
         FileStream fileStream = File.OpenRead(FileUpload1.PostedFile.FileName);
         StreamReader reader = new StreamReader(fileStream);
         SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString); 
         conn.Open();
         //向数据库插入数据    
         SqlCommand command = conn.CreateCommand();
         command.CommandText = insertsql;  
         string line = null;
         while ((line = reader.ReadLine()) != null)
         {
             string[] str = line.Split('|');
             if (str.Length<13)//跳过第一行数据
             {
                 continue;
             }
             string RefParma = str[0];
             string requestid = str[1];
             string agency_name = str[2];
             string channel_coding = str[3];
             string phone = str[4];
             string province_code = str[5];
             string cities_code = str[6];
             string TrafficSts = (str[7] == "20101") ? "1" : "-1";
             string product_type_code = str[8];
             string package_name = str[9];
             string processsing_date = str[10];
             string processsing_time = str[11];
             string money = str[12];
             //RefParma, requestid, agency_name, channel_coding, phone, province_code, cities_code, TrafficSts, product_type_code, package_name, processsing_date, processsing_time, money
             command.Parameters.Clear(); //每次插入都要清除参数  
             command.Parameters.Add(new SqlParameter("RefParma", RefParma));
             command.Parameters.Add(new SqlParameter("requestid", requestid));
             command.Parameters.Add(new SqlParameter("agency_name", agency_name));
             command.Parameters.Add(new SqlParameter("channel_coding", channel_coding));
             command.Parameters.Add(new SqlParameter("phone", phone));
             command.Parameters.Add(new SqlParameter("province_code", province_code));
             command.Parameters.Add(new SqlParameter("cities_code", cities_code));
             command.Parameters.Add(new SqlParameter("TrafficSts", TrafficSts));
             command.Parameters.Add(new SqlParameter("product_type_code", product_type_code));
             command.Parameters.Add(new SqlParameter("package_name", package_name));
             command.Parameters.Add(new SqlParameter("processsing_date", processsing_date));
             command.Parameters.Add(new SqlParameter("processsing_time", processsing_time));
             command.Parameters.Add(new SqlParameter("money", money));
             int tem=command.ExecuteNonQuery();  
         }
         Response.Write("<script>alert('数据导入完成');</script>");
         fileStream.Close();
         reader.Close();
         conn.Dispose();  
     }
     public string insertsql = "insert into Order_Table (RefParma,requestid,agency_name,channel_coding,phone,province_code,cities_code,TrafficSts,product_type_code,package_name,processsing_date,processsing_time,money) values (@RefParma, @requestid, @agency_name, @channel_coding, @phone, @province_code, @cities_code, @TrafficSts, @product_type_code, @package_name, @processsing_date, @processsing_time, @money)";
 }