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> |