C #: import the text format to the SQL database

The format of test.txt is as follows:

Sph00001 | 123123123123 | Three Yellow slices
Sph00002 | 465465465 | amoxicillin
Sph00003 | 456123460110 | licorice Tablets
Sph00004 | 45612346023 | watermelon cream
Sph00005 | 4561234678979 | grass coral

Import Statement:

streamreader sr = new streamreader (@ "H:/test.txt"); // file path
string oneline;
while (oneline = sr. readline ())! = NULL)
{< br> 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); // The insert statement is called here

}< br> Sr. Close ();