Guest User

Untitled

a guest
Jun 23rd, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. public List<string> GetAllNames()
  2. {
  3. List<string> names = null;
  4. var connection = new OleDbConnection(connectionString);
  5. var sql = "SELECT [FirstName] FROM [Names]";
  6. var command = new OleDbCommand(sql, connection);
  7.  
  8. connection.Open();
  9. using (connection)
  10. {
  11. OleDbDataReader reader = command.ExecuteReader();
  12.  
  13. while (reader != null && reader.Read())
  14. {
  15. names = (from IDataRecord r in reader
  16. select (string)r["FirstName"]
  17. ).ToList();
  18. var dinNyaString = "";
  19. foreach (var name in names)
  20. {
  21. dinNyaString += name & ", ";
  22. }
  23. //names = reader["FirstName"].ToString();
  24. }
  25. }
  26.  
  27. return dinNyaString;
  28. }
Add Comment
Please, Sign In to add comment