导入数据（ADO.Net)

Bertha 。 2022-04-04 08:45 96阅读 0赞

源码记录

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