Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <head runat="server">
- <title></title>
- <script src="Scripts/angular.min.js"></script>
- <script>
- var app = angular.module("myModule", []).controller("myController",
- function($scope, $http) {
- $http.get("UsersService.asmx/GetAllUsers").then(function(response) {
- $scope.users = response.data;
- });
- });
- </script>
- </head>
- <body ng-app="myModule">
- <form id="form1" runat="server">
- <div ng-controller="myController">
- <table>
- <thead>
- <tr>
- <th>ID</th>
- <th>Username</th>
- <th>Password</th>
- <th>LastLogin</th>
- </tr>
- </thead>
- <tbody>
- <tr ng-repeat="user in users">
- <td>{{ user.ID }}</td>
- <td>{{ user.Username }}</td>
- <td>{{ user.Password }}</td>
- <td>{{ user.LastLogin }}</td>
- </tr>
- </tbody>
- </table>
- </div>
- </form>
- </body>
- </html>
- [WebMethod]
- public void GetAllUsers()
- {
- List<User> listUsers = new List<User>();
- string cs = ConfigurationManager.ConnectionStrings["AngularJS_ConnectionString"].ConnectionString;
- using (SqlConnection con = new SqlConnection(cs))
- using (SqlCommand cmd = new SqlCommand("SELECT * FROM Users", con))
- {
- con.Open();
- using (SqlDataReader sdr = cmd.ExecuteReader())
- {
- while (sdr.Read())
- {
- User user = new User();
- user.ID = Convert.ToInt32(sdr["UserID"]);
- user.Username = sdr["Username"].ToString();
- user.Password = sdr["Password"].ToString();
- user.LastLogin = sdr["LastLogin"] as DateTime?;
- listUsers.Add(user);
- }
- }
- }
- JavaScriptSerializer js = new JavaScriptSerializer();
- Context.Response.Write(js.Serialize(listUsers));
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement