asp.Netドロップダウンテキストフォーマットデータをデータベースにインポートするコード

 
  
StreamReader sr = new StreamReader("E:\\123.txt");//     
  
string oneLine; 
  
while ((oneLine = sr.ReadLine()) != null) 
  
{ 
  
string[] str = oneLine.Split('|'); 
  
string sql = "insert into TableDX(number,name,produce,xinghao) values('" + str[0].ToString() + "','" + str[1].ToString().Replace("'","'") + "','" + str[2].ToString() + "','" + str[3].ToString() + "')"; 
  
string strConn = "Data Source=.;Initial Catalog=master;User ID=sa;Password=sa";//      
  
SqlConnection conn = new SqlConnection(strConn); 
  
 
  
int res = 0; 
  
conn.Open(); 
  
SqlCommand cmd = new SqlCommand(sql, conn); 
  
res = cmd.ExecuteNonQuery(); 
  
conn.Close(); 
  
} 
  
sr.Close(); 
  
this.Response.Write("alert('    ');");