C# TXT文件导入至数据库

来源：互联网发布：跨越阶层知乎编辑：程序博客网时间：2024/04/30 09:09

转自http://blog.csdn.net/kj297296053/article/details/10304125?locationNum=14

TxT文本内容格式以“|”分割，内容与数据库里表的字段对应

例如： Tom|21

Jenny|25

<span style="font-size:14px;">using System;  using System.Collections.Generic;  using System.ComponentModel;  using System.Data;  using System.Drawing;  using System.Linq;  using System.Text;  using System.Windows.Forms;  using System.IO;  using System.Data.SqlClient;    namespace txt导入至数据库  {      public partial class Form1 : Form      {          public Form1()          {              InitializeComponent();          }            private void button1_Click(object sender, EventArgs e)          {              if (ofdfile.ShowDialog() == DialogResult.OK) //点击form窗体上的导入按钮              {                 using (FileStream fileStream=File.OpenRead(ofdfile .FileName)) //选txt文本                 {                  using (StreamReader streamreader = new StreamReader(fileStream))                   {                      using (SqlConnection conn = new SqlConnection("server=.;database=test;user id=sa;password=123456")) //打开数据库连接                       {                          conn.Open();                          string lines = null;                          using (SqlCommand cmd = conn.CreateCommand())                          {                              cmd.CommandText = "insert into T_persons(name,age)values(@name,@age)";                                                         while ((lines=streamreader.ReadLine()) != null)                              {                                                             string[] strs = lines.Split('|');                                  string name = strs[0].ToString();                                  int age = Convert.ToInt32(strs[1]);                                  cmd.Parameters.Clear();                                  cmd.Parameters.Add(new SqlParameter("name",name));                                  cmd.Parameters.Add(new SqlParameter("age",age));                                  cmd.ExecuteNonQuery();                                                              }                          }                      }                  }               }                 MessageBox.Show("数据导入成功");            }         }      }  }    </span>

0 0