c#逐行分元素读取记事本txt数据写进数据库

publicvoid InputData() 

        { 

            DataTable dt = newDataTable(); 

            stringstrFilePath = "e:\\ouput1.txt"; 

            FileStream fs = newFileStream(strFilePath, FileMode.Open, FileAccess.Read); 

            StreamReader sr = newStreamReader(fs, System.Text.Encoding.UTF8);//utf-8格式，下面的是gb2312格式 

            ///StreamReader sr = new StreamReader(fs, System.Text.Encoding.Default); 

   

            //SqlConnection conn = DatabaseConnection.GetConnected(); 

            //conn.Open(); 

            stringstrLine0 = sr.ReadLine(); 

            ///当行内需要重新分散元素的是时候，我注释掉以下代码，demo里，用“，”区分行元素，然后，用ado.net插入数据库就可以了 

            /*

            String strLine1 = sr.ReadLine();

            String strLine2 = sr.ReadLine();*/ 

            while(strLine0 != null) 

            { 

                string[] strArray = newstring[4]; 

                strArray = strLine0.Split('，'); 

                DataRow dr = dt.NewRow(); 

                dr[0] = strArray[0]; 

                dr[1] = strArray[1]; 

                dr[2] = strArray[2]; 

                dr[3] = strArray[3]; 

                //string sql = "insert into 你的表名 values('" + dr[0] + "','" + dr[1] + "','" + dr[2] + "','" + dr[3] + "')"; 

                //SqlCommand cmd = new SqlCommand(sql, conn); 

                //cmd.ExecuteNonQuery(); 

                dt.Rows.Add(dr); 

                strLine0 = sr.ReadLine(); 

            } 

            sr.Close(); 

            fs.Close(); 

            //conn.Close(); 

        }