导入数据（ADO.Net)

源码记录

在Main 里加上

string dataDir = AppDomain.CurrentDomain.BaseDirectory;
            if (dataDir.EndsWith(@"\bin\Debug\") || dataDir.EndsWith(@"\bin\Release\"))
            {
                dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName;
                AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);
            }  

其中导入按钮里的代码

using System;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;

namespace 登录厕所里hi
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {

            if (Ofdimport.ShowDialog() == DialogResult.OK)
            {

                using (FileStream filestream = File.OpenRead(Ofdimport.FileName))
                {
                    using (StreamReader streamReader = new StreamReader(filestream))
                    {
                        string line = null;
                        while ((line = streamReader.ReadLine()) != null)
                        {
                            string[] strs = line.Split('|');
                            string name = strs[0];
                            int age = Convert.ToInt32(strs[1]);

                            using (SqlConnection conn = new
   SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDBFilename=|DataDirectory|\DB1.mdf;Integrated Security=True;User Instance=True"))
                            {
                                conn.Open();

                                using (SqlCommand cmd = conn.CreateCommand())
                                {

                                    cmd.CommandText = "insert into T_Persons (Name,Age) values(@Name,@Age)";
                                    cmd.Parameters.Add(new SqlParameter("Name",name));
                                    cmd.Parameters.Add(new SqlParameter("Age",age));
                                    cmd.ExecuteNonQuery();

                                }

                            }
                        }
                    }

                }
            }

        }
    }
}