从文本文件提取数据到数据库指定的字段中
文本文件
202171000000 202171255255 宁夏 银川市
202172000000 202175255255 宁夏
202171000000 202171255255 宁夏 吴忠市
202172000000 202175255255 宁夏 银川/隆德市
using System.IO;
//Read data from file
private void ReadDataFromFile( string strFileName )
{
StreamReader srReader = new StreamReader( yourFile );
string strLine;
do
{
strLine = srReader.ReadLine();
// process every line using "strLine"
InsertDB( strLine );
}
while( strLine != null );
srReader.Close();
}
// Insert into DB
private void InsertDB( string strLine )
{
string[] strData = strLine.Split( ' ' );// Separate every line into pieces
string strQuery = "INSERT INTO yourTable "
+ "( yourField1,yourField2,yourField3,yourField4) "
+ " VALUES "
+ "( @yourField1,@yourField2,@yourField3,@yourField4)";
DBCommand myCommand = new DBCommand( strQuery, yourCnn);
myCommand.Paramters.Add( "@yourField1", strData[0] );
myCommand.Paramters.Add( "@yourField2", strData[1] );
myCommand.Paramters.Add( "@yourField3", strData[2] );
myCommand.Paramters.Add( "@yourField4", strData.Length > 3? strData[3]:"" );
myCommand.ExeNonQuery();
myCommand.Close();
}