Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public List<string> GetAllNames()
- {
- List<string> names = null;
- var connection = new OleDbConnection(connectionString);
- var sql = "SELECT [FirstName] FROM [Names]";
- var command = new OleDbCommand(sql, connection);
- connection.Open();
- using (connection)
- {
- OleDbDataReader reader = command.ExecuteReader();
- while (reader != null && reader.Read())
- {
- names = (from IDataRecord r in reader
- select (string)r["FirstName"]
- ).ToList();
- var dinNyaString = "";
- foreach (var name in names)
- {
- dinNyaString += name & ", ";
- }
- //names = reader["FirstName"].ToString();
- }
- }
- return dinNyaString;
- }
Add Comment
Please, Sign In to add comment