Guest User

Untitled

a guest
Jan 17th, 2019
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.79 KB | None | 0 0
  1. public class BioMatricUsers : System.Web.Services.WebService {
  2. public BioMatricUsers()
  3. {
  4. }
  5. public class my_user
  6. {
  7. public my_user(string i, string b, string l)
  8. {
  9. id = i;
  10. badgeNumber = b;
  11. login = l;
  12. }
  13.  
  14. public string id { get; set; }
  15. public string badgeNumber { get; set; }
  16. public string login { get; set; }
  17. }
  18.  
  19. [WebMethod]
  20. [ScriptMethod(ResponseFormat = ResponseFormat.Json)]
  21. public string GetUsers()
  22. {
  23. OleDbConnection co = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:UsersconfizDesktopatt2000.mdb");
  24. co.Open();
  25. OleDbCommand cmd = new OleDbCommand("SELECT * FROM USERINFO", co);
  26. OleDbDataReader reader = cmd.ExecuteReader();
  27. string jsonString = "";
  28. int i = 1;
  29. MemoryStream ms = new MemoryStream();
  30. my_user user = null;
  31.  
  32. Type type = user.GetType();
  33.  
  34.  
  35. while (reader.Read() && i <= 2)
  36. {
  37. DataContractJsonSerializer serializer = new DataContractJsonSerializer(user.GetType());
  38. user = new my_user(reader["USERID"].ToString(), reader["badgenumber"].ToString(), reader["SSN"].ToString());
  39. serializer.WriteObject(ms, user);
  40. jsonString = Encoding.Default.GetString(ms.ToArray());
  41. i++;
  42. }
  43. ms.Close();
  44. co.Close();
  45. return jsonString;
  46. }
  47. }
  48.  
  49. while (reader.Read() && i <= 2)
  50. {
  51. DataContractJsonSerializer serializer = new DataContractJsonSerializer(typeof(my_user));
  52. user = new my_user(reader["USERID"].ToString(), reader["badgenumber"].ToString(), reader["SSN"].ToString());
  53. serializer.WriteObject(ms, user);
  54. jsonString = Encoding.Default.GetString(ms.ToArray());
  55. i++;
  56. }
Add Comment
Please, Sign In to add comment