导入
string connStr = @"Data Source=.\sqlexpress;Initial Catalog=MySchool;Integrated Security=True";
openFileDialog1.FileName = "";
openFileDialog1.Filter = "文本文件|*.txt";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
using (SqlConnection conn = new SqlConnection(connStr))
{
using (SqlCommand cmd = new SqlCommand())
{
string[] lines = File.ReadAllLines(openFileDialog1.FileName, Encoding.Default);
cmd.Connection = conn;
StringBuilder sb = new StringBuilder();
foreach (var line in lines)
{
string[] arr = line.Split(',', ',');
if (arr.Length == 2)
{
sb.Append(string.Format("insert into [user] (uUserName,uPwd) values ('{0}','{1}')",arr[0],arr[1]));
}
}
conn.Open();
cmd.CommandText = sb.ToString();
int n = cmd.ExecuteNonQuery();
MessageBox.Show(n.ToString());
}
}
}
导出
string connStr = @"Data Source=.\sqlexpress;Initial Catalog=MySchool;Integrated Security=True";
//1 输入要保存的文件名
//2 查询所有用户
//3 拼接字符串
//4 保存到文件
saveFileDialog1.Filter="文本文件|*.txt";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
string path = saveFileDialog1.FileName;
using (SqlConnection conn = new SqlConnection(connStr))
{
string sql="select * from [user]";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
List<string> users = new List<string>();
while (dr.Read())
{
string name =dr["uUserName"].ToString();
string pwd = dr["uPwd"].ToString();
users.Add(name + "," + pwd);
}
File.WriteAllLines(path, users.ToArray());
MessageBox.Show("保存了" + users.Count());
}
}
}
}