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();