using System; using System.Collections.Generic; using System.Linq; using System.Windows.Forms; namespace txt记事本文件的读写 {     static class Program     {         /// <summary>         /// 应用程序的主入口点。         /// </summary>         [STAThread]         static void Main()         {             //SQLServer 附加mdf文件             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);             }             Application.EnableVisualStyles();             Application.SetCompatibleTextRenderingDefault(false);             Application.Run(new Form1());         }     } }

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; using System.IO; namespace txt记事本文件的读写 {     public partial class Form1 : Form     {         public Form1()         {             InitializeComponent();         }         private void BtnReadTXT_Click(object sender, EventArgs e)         {             if (odfImport.ShowDialog() == DialogResult.OK)             {                 using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TelphoneNo.mdf;Integrated Security=True;User Instance=True"))                 {                     conn.Open();                     using (FileStream fileStream = File.OpenRead(odfImport.FileName))  //打开txt文件                     {                         using (StreamReader stmReader = new StreamReader(fileStream))  //读取txt文件                         {                             string line = null;                             string TelNo = "";                             string Name = "";                             string strIns = "";                             //sql 参数                             strIns = "insert into PhoneNo(TelNO,Name) values(@telNO,@name) ";                             SqlParameter[] sqlPara = new SqlParameter[] {                                     new SqlParameter("telNO",TelNo),                                     new SqlParameter("name",Name)                                 };                             //把读取出来的数据写入.mdf                             using (SqlCommand sqlCmd = new SqlCommand(strIns, conn))                             {                                 //逐行读取                                 while ((line = stmReader.ReadLine()) != null)                                 {                                     string[] strTel = line.Split('-');                                     TelNo = strTel[0].ToString();                                     Name = strTel[1].ToString();                                     sqlCmd.Parameters.AddRange(sqlPara);                                     sqlCmd.ExecuteNonQuery();                                     sqlCmd.Parameters.Clear(); //参数清除                                 }                                 MessageBox.Show("导入成功", "Read TXT");                             }                         }                     }                 }             }             else             {                 return;             }         }     } }