代码如下:if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                FileStream fileStrem = File.OpenRead(openFileDialog1.FileName);
                StreamReader streamReader = new StreamReader(fileStrem);
                string line = null;
                while ((line = streamReader.ReadLine()) != null)
                {
                    string[] strs = line.Split('|');
                    string name = strs[0];
                  
                    string password = strs[1];
               
                    string str = "server=PC-20120601YRRO\\SQLEXPRESS;database=test;uid=sa;pwd=123";
                    SqlConnection conn = new SqlConnection(str);
                    conn.Open();
                    string sql = "insert into T_test(username,pwd)values(@name,@pwd)";
                    SqlCommand comm = new SqlCommand(sql,conn);
                    comm.Parameters.Add(new SqlParameter("name",name));
                    comm.Parameters.Add(new SqlParameter("pwd", password));
                    comm.ExecuteNonQuery();
                }