text: Hi all,can any one to told me how to fix my code because I am trying to get information for text file and insert it to database Access. right now I am trying to get the form text file using ADO.net I get the information but I want to see it on console windows
  Hey, I just downloaded your code to see where you are coming from. Thoughts. Have you thought about using the File System Class? That way, you can bypass the Database/ADO.NET altogether, and store everything in a text-file on the server. You would need to delimiate the file for storage, then retrieve it later, and even add to the text-file. Basically a flat-text database. Check out the File System built into .NET to help you out.
  Mainly, StreamWriter and StreamReader. Along with a few other objects.
  Good Luck.
  Well, if you are importing a text file into access, frankly the best tool could be access. No ADO.NET required.
  If you need to go through ADO.NET for some reason, check out the FileHelpers library -- it is great at munging text files.
  thank all right now I use FileHelpers library and I follow the example in how to use it. but I counter one problem the console app can't convert Datatime for the birthdayand this is error message "Error Converting ' BirthDate (mm/dd/yyyy)' to type: 'DateTime'. There are more chars than in the format string: 'dd/MM/yyyy'
  using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Text;
  using System.IO;
  using System.Data.OleDb;
  using System.Data;
  using FileHelpers;
  namespace TechnicalTest
  {
  class Program
  {
  [DelimitedRecord("|")]
  public class Employee
  {
  public string FirstName;
  public string LastName;
  public string Address1;
  public string City;
  public string PostalCode;
  public string PhoneNumber;
  public string SocialInsuranceNumber;
  [FieldConverter(ConverterKind.Date, "m/dd/yyyy")]
  public DateTime BirthDate;
  }
  static void Main(string[] args)
  {
  FileHelperEngine eng = new FileHelperEngine(typeof(Employee));
  Employee[] emp = eng.ReadFile("Employees.txt") as Employee[];
  eng.WriteFile("FileOut.txt", emp);
  foreach (Employee empl in emp)
  {
  Console.WriteLine(empl.FirstName + "-" + empl.BirthDate.ToString("M/dd/yy"));
  }
  }
  }
  }
  "
  Ran into this one before, they use DateTime.ParseExact() which is very finnicky. Best bet is to use a custom field converter that wraps DateTime.Parse(). Note that isn't very performant if you have alot of records, like a few million.