用TEXT文件做数据源

        private void read()
        {
            //text作为数据源的链接字符串
            string strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\test;Extended Properties=""text;HDR=Yes;FMT=Delimited"";";

            using (OleDbConnection objConnection = new OleDbConnection(strConnection))
            {
                objConnection.Open();

                //b.txt是c:\\test下面的一个文件，如果是a.txt ，只要把下面3处b.txt 换成a.txt就可以了
                OleDbDataAdapter myCommandd = new OleDbDataAdapter("select * from b.txt", objConnection);
                DataSet ds = new DataSet();
                myCommandd.Fill(ds, "b_txt");
            }
        }