简单的外部文件导入数据库

//为了参数不重复添加而设计的一个方法

private void InsertData(string name, string password)
        {
            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connStr"].ConnectionString))
            {
                conn.Open();
                using (SqlCommand cmd = new SqlCommand())
                {

                    cmd.CommandText = "insert into T_Login(Name,Password) values(@Name,@Password)";
                   
                    cmd.Parameters.Add(new SqlParameter("@Name", name));
                    cmd.Parameters.Add(new SqlParameter("@Password", password));

                    cmd.Connection = conn;
                    cmd.ExecuteNonQuery();
                
                }
            }
           
        }

 1 private void button1_Click(object sender, RoutedEventArgs e)
 2         {
 3             
 4             string[] allLines=File.ReadAllLines("C:/1.txt");
 5             
 6             foreach (string line in allLines)
 7             {
 8                 string[] data = line.Split(' ');
 9                 name = data[0];
10                 password = data[1];
11                 InsertData(name, password);
12             }
13             MessageBox.Show("完毕");
14             
15         }

 

//在外部只打开一次数据库
//改版

 private void InsertData(SqlConnection conn ,string name, string password)
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.CommandText = "insert into T_Login(Name,Password) values(@Name,@Password)";

                cmd.Parameters.Add(new SqlParameter("@Name", name));
                cmd.Parameters.Add(new SqlParameter("@Password", password));

                cmd.Connection = conn;
                cmd.ExecuteNonQuery();
            }
        }

 

转载于:https://www.cnblogs.com/wangjia2662/archive/2013/03/23/2976573.html