黑马程序员——txt文件导入导出

---------------------- Windows Phone 7手机开发、 .Net培训、期待与您交流！ ----------------------


1.txt文件内容
tom|12
alice|23
jerry|25
编写程序开始导入如下

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)
{
string strcon = "Data Source=.;Initial Catalog=LearnDataBase;Integrated Security=True";
//如果用户没有选文件就返回
if (openFileDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
using (FileStream filestream = new FileStream(openFileDialog1.FileName, FileMode.Open))
{
using (StreamReader reader = new StreamReader(filestream))
{
using (SqlConnection conn = new SqlConnection(strcon))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "insert into MyTable (name,age) values(@name,@age)";
//如果读的这一行不是最后一行的话就继续循环
while (!reader.EndOfStream)
{
string[] line = reader.ReadLine().Split('|');
//清除参数
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("@name", line[0]));
cmd.Parameters.Add(new SqlParameter("@age", line[1]));
cmd.ExecuteNonQuery();
}
}
}
}
}
MessageBox.Show("导入成功！");
}
}
}


---------------------- Windows Phone 7手机开发、 .Net培训、期待与您交流！ ----------------------