我正在为我的前端和C#asmx服务使用angular以与数据库相对应。
我有用于验证用户密码的服务。C#服务返回密码,角度服务验证密码。
C#服务:
[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public void Auth(string username)
{
string password = "";
using (SqlConnection con = new SqlConnection(GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("Select PASSWORD from users where USERNAME = '" + username + "'", con);
//Open Connection
con.Open();
//To Read From SQL Server
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
password = dr["PASSWORD"].ToString();
}
//Close Connection
dr.Close();
con.Close();
this.Context.Response.ContentType = "application/json; charset=utf-8";
this.Context.Response.Write(password);
}
}
角度服务:
service.Login = function (username, password, callback) {
var q = $q.defer;
$http({
url: 'services/ShiftLogService.asmx/Auth',
dataType: "json",
method: "POST",
data: { username: username }
}).success(function (data) {
console.log(data);
}).error(function (data) {
// q.reject();
});
return q.promise;
};
C#服务运行良好。响应很好。我知道这不是最佳做法或安全措施,请放在一边。
角度服务抛出
SyntaxError: Unexpected token l
at Object.parse (native)
at uc (http://localhost:15380/bower_components/angular/angular.min.js:17:6)
at ac (http://localhost:15380/bower_components/angular/angular.min.js:90:253)
at http://localhost:15380/bower_components/angular/angular.min.js:91:164
at q (http://localhost:15380/bower_components/angular/angular.min.js:7:355)
at ed (http://localhost:15380/bower_components/angular/angular.min.js:91:146)
at c (http://localhost:15380/bower_components/angular/angular.min.js:92:403)
at http://localhost:15380/bower_components/angular/angular.min.js:128:305
at m.$eval (http://localhost:15380/bower_components/angular/angular.min.js:142:467)
at m.$digest (http://localhost:15380/bower_components/angular/angular.min.js:140:47)(anonymous function) @ angular.js:13363(anonymous function) @ angular.js:10162(anonymous function) @ angular.js:15621m.$eval @ angular.js:17059m.$digest @ angular.js:16771m.$apply @ angular.js:17121g @ angular.js:11298x @ angular.js:11561v.onload @ angular.js:11624
你能帮我吗?谢谢。
这是因为您返回的是字符串,而不是有效的json。
public class PassWordClass{
public string Password {set; get;}
}
[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public PassWordClass Auth(string username)
{
string password = "";
using (SqlConnection con = new SqlConnection(GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("Select PASSWORD from users where USERNAME = '" + username + "'", con);
//Open Connection
con.Open();
//To Read From SQL Server
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
var pass = new PassWordClass();
pass.Password = dr["PASSWORD"].ToString();
return pass;
}
}
}
这是转换请求的json的正确方法:
$http({
url: 'services/ShiftLogService.asmx/Auth',
responseType : "json", //<-- change like that
method: "POST",
data: { username: username }
})
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句