.net读取以逗号分隔的多行txt文件

Question

.net读取以逗号分隔的多行txt文件，如：11111111111111,GX-CF188,广信,CF188,A1000008A4DCE6                                  
111111111111,GX-CF188,广信,CF188,A1000013443D6A                                  
1111111111111,GX-CF188,广信,CF188,A1000008A44F53                                  
1111111111,GX-CF188,广信,CF188,A1000008AB7FBD                                  
111111111111,GX-CF188,广信,CF188,A1000008AAEDF5 
111111111,Mozilla/5.0 (LG-KV510/CH510V05;U;REX/1.0;BREW/3.1.5;240*400;CTC/2.0)
 Polaris/6.15.WEB,,,                                                            
                                                                                
111111111111,Mozilla/5.0 (LG-KV510/CH510V05;U;REX/1.0;BREW/3.1.5;240*400;CTC/2.0)
 Polaris/6.15.WEB,,, 程序：
try
        {
            StreamReader sr = new StreamReader("E:\\1.txt");
            string online = "";
            string strConn = "Data Source=ptntams36;user id=tams2;password=tams;Integrated Security=no;";
            while ((online = sr.ReadLine()) != null)
            {
                string[] str = online.Split(',');
                string sql = "Insert into Tabledx2(ID,F_NUMBER,F_NAME,produce,xinghao) values(SEQ_TABLEDX2.NEXTVAL,'" + str[0].ToString() + "','" + str[1].ToString().Replace("'", "’") + "','" + str[2].ToString() + "','" + str[3].ToString() + "')";
                OracleConnection conn = new OracleConnection(strConn);
                int res = 0;
                conn.Open();
                OracleCommand cmd = new OracleCommand(sql, conn);
                res = cmd.ExecuteNonQuery();
                conn.Close();
            }        }
        catch (System.Exception h)
        {
            this.Response.Write(string.Format("<script>alert('{0}')</script>", h.Message.ToString()));
        }
备注：无法读取这两行.111111111,Mozilla/5.0 (LG-KV510/CH510V05;U;REX/1.0;BREW/3.1.5;240*400;CTC/2.0)
 Polaris/6.15.WEB,,,                                                            
                                                                                
111111111111,Mozilla/5.0 (LG-KV510/CH510V05;U;REX/1.0;BREW/3.1.5;240*400;CTC/2.0)
 Polaris/6.15.WEB,,,  

Answer 1

  string sql = "Insert into Tabledx2(ID,F_NUMBER,F_NAME,produce,xinghao) values(SEQ_TABLEDX2.NEXTVAL,'" + str[0] + "','" + str[1].Replace("'", "’") + "','" + str[2]??" " + "','" + str[3]??" " + "')";

Answer 2

List<String> lst=new List<String>(File.ReadALLLines(""));
foreach(string s in lst)
{
string[] arr=s.Split(new string[]{","},StringSplitOptions.RemoveEmptyEntries);
}

Answer 3

string sql = "Insert into Tabledx2(ID,F_NUMBER,F_NAME,produce,xinghao) values(SEQ_TABLEDX2.NEXTVAL,'" + str[0].ToString() + "','" + str[1].ToString().Replace("'", "’") + "','" + str[2].ToString() + "','" + str[3].ToString() + "')";你的这句就有问题呀 
111111111111,Mozilla/5.0 (LG-KV510/CH510V05;U;REX/1.0;BREW/3.1.5;240*400;CTC/2.0)
 Polaris/6.15.WEB,,,
str[3]==null,再str[3].ToString()直接跳到catch语句了要先判断一下，再ToString()
最好找一个牛人写个正则表达事，效率应该会高些