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, moneycommand.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)";}

　　

轉載于:https://www.cnblogs.com/caipz/p/6773938.html

總結

以上是生活随笔為你收集整理的C# 读取TXT文本数据 添加到数据库的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。