Advertisement
Guest User

Untitled

a guest
Feb 12th, 2016
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.41 KB | None | 0 0
  1. public ReaderMap()
  2. {
  3. Map(m => m.accountpersonfirstname).Name("E-mail Address");
  4. Map(m => m.accountpersonlastname).Name("First Name");
  5. Map(m => m.emailaddress).Name("Last Name");
  6. }
  7.  
  8. class Reader
  9. {
  10. public string emailaddress { get; set; }
  11. public string accountpersonfirstname { get; set; }
  12. public string accountpersonlastname { get; set; }
  13. }
  14.  
  15. class ReaderMap : CsvClassMap<Reader>
  16. {
  17. public ReaderMap()
  18. {
  19. Map(m => m.accountpersonfirstname).Name("E-mail Address");
  20. Map(m => m.accountpersonlastname).Name("First Name");
  21. Map(m => m.emailaddress).Name("Last Name");
  22. }
  23. }
  24.  
  25. MySqlCommand cmd = new MySqlCommand(sqlCmd, cn);
  26. cmd.CommandType = CommandType.Text;
  27. MySqlDataReader rdr = cmd.ExecuteReader();
  28.  
  29. while (rdr.Read())
  30. {
  31. Reader dataExport = new Reader();
  32.  
  33. dataExport.accountpersonfirstname = rdr.GetString(0);
  34. dataExport.accountpersonlastname = rdr.GetString(1);
  35. dataExport.emailaddress = rdr.GetString(2);
  36.  
  37.  
  38. dataList.Add(dataExport);
  39.  
  40. }
  41.  
  42. var textWriter = new StreamWriter(filePath);
  43.  
  44. var csv = new CsvWriter(textWriter);
  45. csv.Configuration.RegisterClassMap<ReaderMap>();
  46. foreach (var item in dataList)
  47. {
  48. csv.WriteRecord(item);
  49. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement