小站 我們既定的目標和道路既非受苦亦非享樂而是進步，在每一個明天都比今天進步。

 public static System.Data.DataSet LoadTxtFile(int numberOfRows)
        {
            System.Data.DataSet ds = new System.Data.DataSet();
            //try
            //{
            // Creates and opens an ODBC connection
            string strConnString = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=D:\\;Extensions=asc,csv,tab,txt;Persist Security Info=False; HDR = YES;FMT = TabDelimiter"; 
            //string strConnString = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=D:\\;Extensions=asc,csv,tab,txt;Persist Security Info=False; HDR = NO;FMT = Delimited(|)"; 
            
            string sql_select;
            //string connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dataSourcePath + @";Extended Properties=""text;HDR=NO;FMT=TabDelimiter""";  
            using (System.Data.Odbc.OdbcConnection conn = new System.Data.Odbc.OdbcConnection(strConnString.Trim()))
            {
                conn.Open();
                sql_select = "select top " + 10 + " * from [A3.txt]";
                //Creates the data adapter
                System.Data.Odbc.OdbcDataAdapter obj_oledb_da = new System.Data.Odbc.OdbcDataAdapter(sql_select, conn);

                //Fills dataset with the records from CSV file
                obj_oledb_da.Fill(ds, "TB");
                System.Data.DataView view = new System.Data.DataView(ds.Tables[0]);
                //closes the connection
                System.Data.DataTable dt = view.ToTable(true, "COLUMN9", "COLUMN0", "COLUMN1");
                conn.Close();
            }
            return ds;

        }