ado.net实现简单的数据导入和导出

导入

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());
                            
                        }
                    }
                }
            }