我已经建立了与数据库的连接,并且我希望在表格格式的视图中显示数据库中的所有详细信息,但是无法做到这一点,因为我的新人可以帮助任何人。从数据库中获取数据并使用Ajax,Jquery,Asp.Net以表格格式显示MVC
public class EmployeeModel
{
public int EmpId { get; set; }
public string EmpName { get; set; }
public int Age { get; set; }
public int Salary { get; set; }
}
控制器:
private static readonly string connectionString = ConfigurationManager.ConnectionStrings["ConnStringDb1"].ConnectionString;
public ActionResult GetUser()
{
return View();
}
public JsonResult GetAllUser(int EmpId)
{
List employee = new List();
string query = string.Format("Select * From Employee", EmpId);
SqlConnection connection = new SqlConnection(connectionString);
{
using (SqlCommand cmd = new SqlCommand(query, connection))
{
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
employee.Add(
new EmployeeModel
{
EmpId = int.Parse(reader["EmpId"].ToString()),
EmpName = reader.GetValue(0).ToString(),
Age = int.Parse(reader["Age"].ToString()),
Salary = int.Parse(reader["Salary"].ToString())
}
);
}
}
return Json(employee, JsonRequestBehavior.AllowGet);
}
}
查看:
@{
ViewBag.Title = "Home Page";
var EmployeeModel = (List)Model;
}
Click me
$(document).ready(function() {
$(':button').click(function() {
GetEmployeeUsingAjax();
});
});
function GetEmployeeUsingAjax() {
var EmpId = 2;
$.ajax({
type: 'GET',
url: '@Url.Action("GetAllUser")',
data: { "EmpId": EmpId},
dataType: 'json',
success: function (data) {
$.each(data, function (i, item) {
var rows = "
"+ "
" + item.EmpID + ""+ "
" + item.EmpName + ""+ "
" + item.Age + ""+ "
" + item.Salary + ""+ "
";$('#tblProducts tbody').append(rows);
});
},
error: function (emp) {
alert('error');
}
});
}
EmpIdEmpNameAgeSalary
任何人都可以给我建议的解决方案
数据是在控制台牵强,但不显示在表格的形式
+0
任何错误安慰 ? –
+0
成功功能是否打? –
+0
它打。我在控制台jQuery的1.10.2.js得到错误:645遗漏的类型错误:无法读取的不确定 –