Форум программистов [Powered by Invision Power Board]

Код

   1. string strConn = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq="+pathtofolder+";Extensions=csv,txt;";
   2. try
   3.                 {
   4.                     
   5.                     OdbcConnection oconnectiontofile = new OdbcConnection(strConn);
   6.                     oconnectiontofile.Open();
   7.                     OdbcCommand ocommandtofile = oconnectiontofile.CreateCommand();
   8.                     ocommandtofile.CommandText = "select F5,F17,F9,F10,F6,F16,F18 from " + filename;                                      
   9.                     OdbcDataReader oreader = ocommandtofile.ExecuteReader();                    
  10.
  11.                     
  12.                     while (oreader.Read())
  13.                     {                                       
  14.                         string fa = oreader[0].ToString();
  15.                         string fb = oreader[1].ToString();
  16.                         string fc = oreader[2].ToString();
  17.                         string fd = oreader[3].ToString();
  18.                         string fe = oreader[4].ToString();
  19.                         string ff = oreader[5].ToString();
  20.                         string fg = oreader[6].ToString();
  21.
  22. //                      
  23.                     }                    
  24.                     oreader.Close();
  25.                     ocommandtofile.Dispose();
  26.                     oconnectiontofile.Close();