Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public ReaderMap()
- {
- Map(m => m.accountpersonfirstname).Name("E-mail Address");
- Map(m => m.accountpersonlastname).Name("First Name");
- Map(m => m.emailaddress).Name("Last Name");
- }
- class Reader
- {
- public string emailaddress { get; set; }
- public string accountpersonfirstname { get; set; }
- public string accountpersonlastname { get; set; }
- }
- class ReaderMap : CsvClassMap<Reader>
- {
- public ReaderMap()
- {
- Map(m => m.accountpersonfirstname).Name("E-mail Address");
- Map(m => m.accountpersonlastname).Name("First Name");
- Map(m => m.emailaddress).Name("Last Name");
- }
- }
- MySqlCommand cmd = new MySqlCommand(sqlCmd, cn);
- cmd.CommandType = CommandType.Text;
- MySqlDataReader rdr = cmd.ExecuteReader();
- while (rdr.Read())
- {
- Reader dataExport = new Reader();
- dataExport.accountpersonfirstname = rdr.GetString(0);
- dataExport.accountpersonlastname = rdr.GetString(1);
- dataExport.emailaddress = rdr.GetString(2);
- dataList.Add(dataExport);
- }
- var textWriter = new StreamWriter(filePath);
- var csv = new CsvWriter(textWriter);
- csv.Configuration.RegisterClassMap<ReaderMap>();
- foreach (var item in dataList)
- {
- csv.WriteRecord(item);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement