C#：导入文本格式到sql数据库

test.txt的格式如下：

SPH00001|123123123123|三黄片
SPH00002|465465465|阿莫西林
SPH00003|456123460110|甘草片
SPH00004|45612346023|西瓜霜
SPH00005|4561234678979|草珊瑚

导入语句：

 StreamReader sr = new StreamReader(@"H:/test.txt");//文件路径
            string oneLine;
            while ((oneLine = sr.ReadLine()) != null)
            {
                string[] str = oneLine.Split('|');
                string sql = "insert into GoodsInfo(GoodsCode,GoodsID,GoodsName) values('" + str[0].ToString() + "','" + str[1].ToString() + "','" + str[2].ToString() + "')";
                db.getcom(sql);//此处调用的是插入语句

            }
            sr.Close();