简单的外部文件导入数据库
//为了参数不重复添加而设计的一个方法 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(); } }
我是一个小小虫
用编程改变世界