Advertisement
Guest User

Untitled

a guest
Apr 17th, 2016
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. List<string> list = (from IDataRecord r in dataReader
  2. select (string)r["FieldName"]
  3. ).ToList();
  4.  
  5. List<int> list = new List<int>();
  6.  
  7. using (SqlDataReader reader = cmd.ExecuteReader())
  8. {
  9. while (reader.Read())
  10. {
  11. list.Add(reader.GetInt32(0));
  12. }
  13. }
  14. return list.ToArray();
  15.  
  16. int size;
  17. object[] data = new object[]{};
  18. size = reader.GetValues(data);
  19.  
  20. DataTable dt as DataTable;
  21. dt.fill(data);
  22.  
  23. ids_array = (from IDataRecord r in idReader
  24. select (string)r["ID"]).ToArray<string>();
  25.  
  26. HashSet<string> hs = new HashSet<string>(
  27. (from IDataRecord r in idReader select (string)r["ID"]).AsEnumerable<string>() );
  28.  
  29. public IList<UserAccount> List()
  30. {
  31. var list = new FluentCommand<UserAccount>("SELECT ID, UserName, Password FROM UserAccount")
  32. .SetMap(reader => new UserAccount
  33. {
  34. ID = reader.GetInt("ID"),
  35. Password = reader.GetString("Password"),
  36. UserName = reader.GetString("UserName"),
  37. })
  38. .AsList();
  39.  
  40. return list;
  41. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement