Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Retrieving Data from a Text File

using System; using System.Data; using System.Data.OleDb;     class Program     {         static void Main(string[] args)         {             string sqlSelect = "SELECT * FROM [Category.txt]";             string connectString = "Provider=Microsoft.ACE.OLEDB.12.0;" +                 @"Data Source=..\;" +                 "Extended Properties=\"text;HDR=yes;FMT=Delimited\";";             OleDbDataAdapter da = new OleDbDataAdapter(sqlSelect, connectString);             DataTable dt = new DataTable("Categories");             da.Fill(dt);             foreach (DataRow row in dt.Rows)             {                 Console.WriteLine("{0}; {1}; {2}", row["CategoryID"],                     row["CategoryName"], row["Description"]);             }         }     }