---------------------- Windows Phone 7手机开发、.Net培训、期待与您交流! ------------------------
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 Import_and_Export
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private readonly static string ConnStr = @"Data Source=.;Initial Catalog=EmployeeSys;Integrated Security=True";
private void button1_Click(object sender, EventArgs e)
{
if (ofdImprt.ShowDialog() != DialogResult.OK)
{
return;
}
using (FileStream fStream = File.OpenRead(ofdImprt.FileName))
{
using (StreamReader sReader = new StreamReader(fStream))
{
using (SqlConnection conn = new SqlConnection(ConnStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "insert into users(name,age) values (@name,@age)";
string line = null;
while ((line = sReader.ReadLine())!=null)
{
string[] str = line.Split('|');
string name = str[0];
int age = Convert.ToInt32(str[1]);
cmd.Parameters.Clear();
cmd.Parameters.Add("@name", name);
cmd.Parameters.Add("@age",age);
cmd.ExecuteNonQuery();
}
}
}
}
}
MessageBox.Show("导入成功!");
}
}
}
---------------------- Windows Phone 7手机开发、.Net培训、期待与您交流! ----------------------详细请查看:http://net.itheima.com/